Live Help is Currently Available
599CD.com 08/27: MAJOR Bug Fixed in Video Player   Collapse Menus
 
 
New Releases:  8/20: Active Server Pages,  7/22: PowerPoint         [dismiss]
 
   
 

What's New?

Courses  |   Demo  |   Tips  |   Blog  |   Search  |   Help  |   Order

 
 
 
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.
 

Get Free Tips & Tricks
 

Join our mailing list today and get information on our Free Tips & Tricks Newsletter including free video tutorials, eBooks, live seminars, and more.

Email:
Name:
Type in the word to the left:
 
Your email will be kept 100% safe and will never be given to 3rd parties.
 


CLICK HERE for a FREE lesson



Order your first 599CD course now.
Your Satisfaction is Guaranteed!


 

 
 NEW:  Watch all of our courses online in the 599CD Theater
 

599CD Home   |   Learn More   |   What's New?   |   Contact Us   |   Free Demo   |   FAQs   |   Order Now   |   Become an Affiliate   |   TechHelp   |   MYOLP   |   Jobs   |   Chat   |   Downloads   |   Handbooks  (Text)   |    Mailing List   |   Lost Passwords   |   Referral Program   |   Online Poll   |   Troubleshooter   |   Corporate / Educational / Government / Non-Profit Sales   |   Message Forums   |   Testimonials   |   Privacy Policy   |   Tips & Tricks

 

What's New  |  Home  |  Courses  |  Demo  |  Learn More  |  Contact  |  Order