We use Excel XP in this course,
but the lessons are valid for all versions of Excel from 95 to 2003.
There are cosmetic changes in Excel 2007. Order before 2/27/2024 to
get a FREE upgrade to our 2007 version when released!
This class was just recently completed. The
full outline will be posted here shortly. Excel 224 is the second of our
two-part series on PivotTables. It covers:
Drill to Detail
Grouping Dates Together (months, quarters, etc.)
Grouping Numeric Values
Advanced Field Settings
Copying PivotTable Data
Base Fields & Items
Showing Data as a Percentage of Previous Data
Example: Employee Costs using IF, VLOOKUP, and a PivotTable