Microsoft Excel Pivot Tables Deep Dive
In this course, participants will delve into the powerful features of Microsoft Excel pivot tables. From the basics of pivot tables to advanced features such as custom groupings and calculated fields, participants will learn how to effectively analyse and visualize their data. The course will also introduce Microsoft Power Pivot, offering even more options for data analysis. Note: Our advanced Excel courses are regularly updated to include the latest AI releases and best practice.
Description
- Understand the basics of pivot tables.
- Convert data to tables.
- Adjust field list settings.
- Create multiple reports with one click.
- Add data bars to pivot tables.
- Master pivot table settings
- Add and remove calculated fields to pivot tables.
- Calculate the difference between columns.
- Add smart custom number formatting.
- Create custom groupings for pivot tables.
- Group dates as unique.
- Add slicers to easily filter data.
- Add dynamic charts.
- Add a timeline to pivot tables.
- Gain an understanding of Microsoft Power Pivot.
About this course:
In this course, participants will delve into the powerful features of Microsoft Excel pivot tables. From the basics of pivot tables to advanced features such as custom groupings and calculated fields, participants will learn how to effectively analyse and visualize their data. The course will also introduce Microsoft Power Pivot, offering even more options for data analysis.
Note: Our advanced Excel courses are regularly updated to include the latest AI releases and best practice.
Target Audience:
- Anyone who works with data and wants to improve their data analysis skills or wants to take their pivot table skills to the next level.
Prerequisites
- Intermediate understanding of Microsoft Excel
- Stable internet connection.
- No previous understanding of pivot tables is required.
- Having a second display is beneficial but not required.