Cerritos Home Susan Fuschetto Home Susan Fuschetto Home Cerritos Home Campus Information Admissions Academic Resources Student Resources Administration Personnel Services Search Cerritos College Computer and Information Sciences rectangle Susan Fuschetto header

Susan Fuschetto
(page divider)

CIS 151 Excel For I.T.

Excel Tutorial 5 - Working with Excel Tables, PivotTables, and PivotCharts

Another excellent tutorial.  This tutorial is about sorting and filtering lists of data in Excel tables; using Subtotals; creating interactive tables and charts (PivotTables and PivotCharts).  These tools are excellent for analyzing lists of data and presenting them in an organized format.  The tutorial will give you a good foundation in tables, subtotaling PivotTables and PivotCharts.  Also, slicer is a new feature in Excel 2010.

If you have created PiviotTables and PivotCharts in older versions of Excel (2003 or older), then you are in for a treat.  Starting with Excel 2007 these tools got a whole lot easier to create and use.  And now there's a new feature the slicer.

Please read all of the directions before getting started on the assignment.

  1. Please note:  Throughout the book it will instruct you to save your files.  In the computer labs on campus you will need to save the files to your USB drive.  If you are using your own computer, then you may save the file to the drive of your choice (hard drive, USB, etc.).
  2. Data file notes:  In order to do this assignment you will need a set of files.  The files are in TalonNet on the Resources page in the Data Files folder.  The data file links are .zip files (compressed set of files).  You will need to download and unzip (uncompress) the files before using them.  Right-click the file link to get the shortcut menu.  Select the Save Target As option and save the file to your drive.  You will then need to unzip (uncompress) the .zip file.  If you are not familiar with unzipping files please read pages FM17 - FM19 or read the Unzipping Files document for a general set of instructions.  The example is from my CIS 101 class.
  3. Read and do the steps in Excel Tutorial 5 pages EX233 - EX293.
  4. Do Case Problem 1 (Zoo Pledges) on pages EX294 - EX295.  When you are done your spreadsheets should look like this document.   Please note there are multiple pages in the answer document so click the Next Page arrow to see all of the pages.  Please note I used Landscape orientation and Scale: Fit to 1 Page. 
  5. Online students:  Upload the LaFouch Museum.xlsx and Zoo Pledges.xlsx files to the Excel Tutorial 5 assignment on the class website in TalonNet.  Please note that you must submit both files at the same time to the assignment in TalonNet.  So complete both the tutorial and the Case Problem 1 before logging in to TalonNet and submitting the assignment.
  6. Traditional students:  During the lab time show the above files listed in step 5 on your computer screen to me.

Last update: 02/07/11