Step 8: Copy and Sort the Data

You’ve accomplished a lot with your data set, summary stats, charts, and histograms. Another skill you’ll need to be able to do is sort data in an Excel worksheet for reporting purposes. You’llcopy the data so that you can learn how to sort it. This is a good skill that applies to any Excel application.

In this step, you will create Tab 5: Sorted Data. When you’re finished, you’ll be ready to conduct your quantitative analysis.

See below for example of sorted spreadsheet.

Copy the Data so That You Can Learn How to Sort It

Many times we want to sort data on an Excel worksheet for reporting purposes. Let’s see what other perspectives the functions of sorting and subtotaling yield.

  1. Begin by following the steps in the “How to Copy Excel 2010 Sheet to Another Sheet” provided below. This will allow you to retain your work for Steps 2 through 7. Place the sheet at the end of the workbook and title the tab "Sorted Data."
  2. Delete all rows containing Section 2 and Section 3 work. Be sure to leave the section in cells F417:I422, as this section is referenced for the Vlookup function populating the region; otherwise, you will get a #N/A or #REF! Error in the column for region.
  3. Apply the ability to sort data on each column of the spreadsheet, so that you can sort by employee #, hire date, role, etc.
  4. Experiment with the filter funnel, sorting the data by various columns. For example, try sorting by employee number from smallest to largest. Try sorting by role in ascending order (A-Z).
  5. Sort the spreadsheet by region.
  6. Employ the subtotal feature to subtotal the salary for each region, with a grand total for the company.
  7. Format the entire spreadsheet to print, so that the columns fit on the pages, and Row 1 repeats on each page.

How to Copy Excel 2010 Sheet to Another Sheet

Attribution
How do I copy a sheet within a workbook in Excel?, by AshlenDube from COM Library is available under aCreative Commons NonCommercial 4.0 Internationallicense. © 2015 COM Library.

How to Copy Excel 2010 Sheet to Another Sheet

Here are the steps to copy a sheet within a workbook in Excel:

  1. Find the tab for the sheet you want to copy at the bottom of the screen.

  1. Right click on the sheet you want to copy.
  2. Select "Move or copy."
  3. Check the "Create a copy" box towards the bottom of the menu

  1. Press OK

That's it!