Mastering Microsoft Excel: Analysing Data With PivotTable
PivotTable is one of the advanced features of Microsoft Excel that allows you to become more productive and increase your day-to-day efficiency. Analysing Data With PivotTable training will expose you how PivotTable is used to manage and analyse data. Discover the tips and tricks that save you the most time and effort. Enjoy learning Analysing Data with PivotTable!
You’ll learn:
- Understanding PivotTable in MS Excel
- Creating and Customizing PivotTable
- Categorizing the Data Fields
- Converting to PivotChart
- Creating and Editing Calculated Field and Item
Learning Methodology
- Instructor-led Training
- Group Discussion
- Hands-On
- Exercises
Who should attend?
Individuals who use Excel in their dayto-day work or those involve in Reporting and Data Analysis but would like to discover the power of
PivotTables in analyzing and summarizing data.
About the Trainer
Kelvin Ng is a Microsoft Certified Trainer (MCT) and Microsoft Office 2010 Master Specialist with 15 years of training experience. He is able to relate practical usage of Formulas and Excel Features in your daily work and save you a great deal of time.
Improve Your Microsoft Excel Skill Now !
Quality Assured
Generate New Idea
Telephone Support
Certified Instructor
Improve Productivity
SMS Support
Practical Example
Updated Resources
Email Support
Courses Outline
Duration: 1 day
1. PivotTable
- Getting to know a PivotTable
- The Best Practice Using a Database for PivotTable
2: Creating PivotTable
- Database Pre-requisite for preparing a PivotTable Report
- Designing a PivotTable
- Adding Elements to the Report
- Creating a Report Filter
– Use Table Field as Report Filter
– Use the Report Filter
– Reset the Filter - Use Slicers to Filter Report
– What is Slicers?
– Remove Slicers - Update the Data Source
– Changes Data Sources
– Create a Dynamic Range for the Data Table
3: Customizing a PivotTable
- Format a PivotTable
– Use PivotTable Style
– Number and Text Format
– Explore the PivotTable Options
– Use the Value Field Settings - Subtotals
- Show Value As
- PivotTable Print Options
- Grand Totals
- Report Layout
4: Grouping. Sorting and Filtering
- Grouping Pivot Fields
– Dates
– Number Fields
– Text - Ungrouping
- Sort and Filtering the PivotTable
5: Use “Fields, Item and Sets”
- Creating Calculated Field
- Creating Calculated Item
- Edit and Delete Calculated Field or Item
6: PivotCharts
- Convert PivotTable to PivotChart
7: PivotTable Wizards
- Multiple Consolidation Ranges