MS Tips and Tricks | Microsoft Excel 2007 | Pivot Data {Tutorial for beginners}

Affiliates

Amazon.com

Popular Microsoft Excel Books

Excel 2003 Bible

Author: John Walkenbach

Excel 2003 for Dummies

Author: Greg, PhD Harvey

Microsoft Office Excel 2003 Step by Step

Author: Curtis Frye

Excel VBA Programming For Dummies

Author: John Walkenbach

Excel 2003 Personal Trainer

Author: Inc

Microsoft Office Excel 2003 Inside Out

Author: Craig Stinson

Excel 2003 All-in-One Desk Reference for Dummies

Author: Greg Harvey

Popular MS Excel Related Websites

Microsoft Excel 2007 Tutorial for beginners

Welcome to MS Tips and Tricks

Welcome to MS Tips and Tricks - You are at the right place if you need tutorials for beginners - Online Microsoft Excel tutorials for beginners, covering the following categories - Advanced Formulas, Pivot data, Charts, Databases, Customization, Table, Forms, etc.,

Microsoft Excel Tips and Tricks for beginners

15) You could change the sumarization's formulas by right click on the header to change and selecting the Summarize Data By . menu item.

Illustration 10: Chart type changed.

16) As you can see, now you are viewing Average and Max operations.

Illustration 11: Changing formulas.

17) You could see the rows composition for that subtotal by right click and selecting the Show Details menu item.

Illustration 12: Showing details.

18) A new worksheet with the rows that compose the sub total will be created.

Illustration 13: A new worksheet.

19) You could set up the Pivot table options by clicking on the Pivot Table and selecting the Pivot Table Options menu item.

Illustration 14: A new worksheet.

Advertisement

Your Ad Here

Copyright © MS Tips and Tricks
A Division of Gurijala and Company, 2006
Home - Tips and Tricks - Resources - Links - Contact - Site Map - Privacy Policy - Email Webmaster