| 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:
- Grouping Data
- Drill to Detail
- Grouping Dates Together (months, quarters, etc.)
- Grouping Numeric Values
- Subtotals
- Subdetails
- Advanced Field Settings
- Formatting PivotTables
- Copying PivotTable Data
- PivotTable Options
- Calculated Fields
- Calculated Items
- Base Fields & Items
- Running Totals
- Showing Data as a Percentage of Previous Data
- Example: Employee Costs using IF, VLOOKUP, and a PivotTable
- Much More
|
