| |
|
Courses - Microsoft
Excel 224 -
PivotTables Part 2 |
| Description: |
Intermediate Microsoft Excel - PivotTables 2 |
| Running Time: |
84 minutes |
| Pre-Requisites: |
Excel 223 strongly recommended |
| Versions: |
|
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/7/2012 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:
- 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
|
| |
|
Try a FREE Demo Lesson |
| |
| |
| |
|
You may want to read these articles from the 599CD Blog: |
|
| |
|
 |
| |
| Do you have
questions about
Word, Excel, Access, Web Design, or computers in general? Just
ask us anything you'd like.
Click here
for assistance. |
|
|
|
|
|
|
|
|
|
|
|