Please read direction carefully, and look at the videos “THIS IS A EXCEL DATA ENTRY CLASS”

Get perfect grades by consistently using Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20

Order a Similar Paper Order a Different Paper


  • Apply professional formatting and worksheet design guidelines
  • Create functions
  • Combine data from different workbooks
  • Delete Rows/Columns
  • Enter and edit data on multiple worksheets at the same time
  • Compare data using charts created in Excel
  • Identify the correct chart type based on message and comparison
  • Analyze and interpret data—determine the message to be communicated and create a point of view


Step 1: Select the Data

Review classmates’ submissions for Assignment 1Choose two classmates’ workbooks that you find interestingCopy each of the worksheets from the original students’ documents into a new workbook (sample below):

Example of how initial data will look in A2 when copied over

Step 2: Create the charts

Decide on a message you would like to communicate with the data table provided.  Remove any extraneous columns/rows/data not relevant to chart message.

Create a chart for each set of data including:

  • A directed point of view message as chart title
  • Chart type that accurately communicates the message chosen (reminder: No 3-D charts)
  • Data Labels
  • Axis Titles
  • No series errors
  • Legend (if appropriate)

Move each chart to its own worksheet (as a Chart Sheet)

Format chart to be legible and professional looking (should be able to read all data)

Step 3: Create 4 new functions

Using any of the Built-in functions from Excel you will create 2 new functions on


worksheet (

for a total of 4 new and unique functions


Several functions can be found in Chapter 6 from Week2 Detailed Readings (Meeting Excel’s Built-in Functions)

  • Make sure the functions are relevant to the data set
  • The functions should provide some sort of analysis
  • Include labels in the cells near the functions to let the audience know what the number represents

Note: If original student already had a function on the worksheet, choose a new/different function to enhance the data.

Strive for the labels on the left giving the audience a report format


Professionally format all worksheets.

Ensure Data Labels clearly designate analysis for the audience.

Step 4: Apply Worksheet Design Guidelines

Special Note on Worksheet Design Guidelines:Design Guidelines were likely created by the original student.  If you used the Copy Worksheet procedure, the comments, etc may have copied with it.

Add and/or adjust all worksheet design guidelines to reflect your own information.  You will not be able to add comments to the chart sheets.  This is expected.  Add your comments to each of the data worksheets.

Reminder: “Grouping” the worksheets will save time on many of the design guidelines (Week1 Detailed Readings, Chapter 3)

If you need a refresher on how to complete the Worksheet Design Guidelines, the video is below.  If not, proceed to Step 5.


Step 5: Print to PDF & Submission

Print all four worksheets into one PDF document VIDEO LINK

A total of 2 documents will be submitted in the assignment upload area:

  1. One Excel workbook with 4 worksheets (2 data sheets, 2 chart sheets)
  2. One PDF that includes a print version of all 4 worksheets.  The PDF will be used to upload to your Portfolio in a later class

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and PhD writers.

Get a 15% discount on your order using the following coupon code SAVE15

Order a Similar Paper Order a Different Paper