Susan Fuschetto
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.
- 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.).
- 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.
- Read and do the steps in Excel Tutorial
5 pages
EX233 - EX293.
- 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.
- 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.
- 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 |
