| |
|
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 8/30/2008 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 |
| |
| |
|
 |
Huge Discounts Available
When you purchase multiple classes together - up to 50% off! |
|
| |
Student Interaction:
Microsoft Excel 224
|
Richard on 1/1/2007:
This is part 2 of the PivotTables series. |
|
Denise Nichols on 2/23/2008: I have followed the instructions exactly however when I right click on the Date field and select Group and Show Detail option / Group I get the following error message - "Cannot group that selection." What can the problem be? |
|
Richard Rost on 2/28/2008: Denise, without seeing exactly what you're doing, I really can't say what the problem is. What time-index in the video are you getting to when you get this problem? I'll see if I can recreate it. Since nobody else has complained here about this (and I know several thousand people have taken this class) it's got to be something you're doing different... but don't worry, we'll figure it out. |
|
|
| |
| |
|
You may want to read these articles from the 599CD Blog: |
|
| |
|
 |
Need
Help? |
| |
|
| Do you have
questions about
Word, Excel, Access, Web Design, or computers in general? Just
ask us anything you'd like. |
|
|
|
|
|
| |
|
CLICK HERE for a FREE
lesson |
Order
your first 599CD course now.
Your Satisfaction is Guaranteed!
|
|
|
|
|
|
|
|
