The Complete Excel Pivot Tables Course: Beginner to Advanced

Learn and Master Pivot Tables in Excel with this Beginner to Advanced course from Microsoft experts, Simon Sez IT!

Created by: Simon Sez IT
990,000+ Students, 290+ Courses, Learners in 180+ Countries

What Will I Learn?

• Cleaning and preparing your data
• How to create PivotTables
• Using the fields pane and adding fields and calculated fields
• How to use the value field settings
• Formatting numbers in PivotTable
• Different ways to summarize data
• Grouping and ungrouping PivotTable data and dealing with errors
• Using multiple fields and dimension
• Methods of aggregation
• Choosing and locking the report layout
• How to format PivotTables and apply styles
• Basic to advanced sorting and filtering
• Creating PivotCharts and adding sparklines and slicers
• Selecting the right chart to present your data
• Adding slicers and timelines and applying them to multiple tables
• Combining data from multiple worksheets for a PivotTable
• All about the GETPIVOTDATA function
• How to use 3D maps from a PivotTable
• Adding new data to the original source dataset
• Updating your data in a PivotTable and PivotChart
• Using conditional formatting in a PivotTable
• How to create amazing dashboards

Requirements

• Microsoft Excel for Windows. The course was created using Excel 2019/365 for Windows. All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019.
• Basic to intermediate knowledge of Microsoft Excel is beneficial.

Target audience

• Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions
• Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge.
• People looking to perform Data Analysis using Excel
• Beginner Excel users who want to learn how to use Pivot Tables