Microsoft Excel 2007 Maximising Pivot Table

Course details

This 1-day pivot table course is an intensive 7 hour programme design to help you apply and get the most out of your data. It is not just a breeze through which you normally get from an Excel course covering many other topics. This course will show learners various scenarios on how a pivot table can be used to help users go beyond the basic usage. In this course you will also learn how to create formulas in a pivot table as well as creating pivot charts.

What will i learn?

• Introduction to Pivot Table
• Creating a Pivot Table
• Editing/Updating a Pivot Table
• Filtering Data by Creating a Page Field
• Creating a Chart from Pivot Table
• Customize a Pivot Table
• Creating a Formula in a Pivot Table Report
• Printing Pivot Table and Pivot Chart
• Import Text File
• Consolidate Multiple Worksheets in a Pivot Table Report
• Pivot Table Keyboard Shortcuts

Who is this course for?

Learners who have attended our Microsoft Excel 2007 Foundation and Microsoft Excel 2007 Functions for Decision Making modules or must be well versed in those topics covered in these modules.