Title: MEPT01 - Mastering Excel PivotTable Course
Duration: 4 hours
Prerequisites:
- Must be proficient in basic Excel
Total Duration: 4 hours
Course Overview
This course is designed for individuals aiming to elevate their proficiency in Excel PivotTables. Participants will delve into the intricacies of PivotTable creation, customization, and analysis, gaining a deep understanding of this powerful data analysis tool.
Course Outline
1. Getting Started with PivotTable
2. Advanced techniques and features
- Choosing layout
- Custom number formatting
- Manipulate width column
- Working with a subtotal and grand total
- Custom sorting
- Filter top items
- The solution to placing PivotTable together in a sheet
- Setting default PivotTable layout and options
3. Filtering in PivotTable
- Slicer and Timeline
- Setting connections
- Tips in setting filter
4. Understanding the Pivot cache
5. Working with Calculated Item and Field
6. Grouping date and item
7. Calculate values by manipulating the displayed value
- Calculating percentages
- Calculating differences
- Calculating running total
8. Working with PivotChart
8. Introduction to measure
- Overview of measure
- Advantages of using the measure
- Steps on how to add measure