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!
4.55 (434 reviews)
1,975
students
15 hours
content
Mar 2023
last update
$79.99
regular price
What you will 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
Related Topics
4336404
udemy ID
10/6/2021
course created date
10/25/2021
course indexed date
Bot
course submited by