Learn how to create Pivot Tables in Excel from scratch in under an hour. Understand dataset analysis, data cleaning, table formatting, field pivoting, data grouping, value field settings, number formatting, sub-totals, grand totals, report layouts, PivotTable styles, Pivot Chart creation, filtering with Slicers, and data updating. Intended for beginners who want to efficiently analyze and visualize data in Excel.
Overview
Syllabus
- Introduction
- Understanding Dataset
- The Importance of Cleaning Data
- Formatting Data as a Table
- Creating a PivotTable
- Analyzing Data by Pivoting Table Fields
- Grouping Data
- Value Field Settings
- Number Formatting
- Sub-totals and Grand Totals
- Report Layouts
- PivotTable Styles
- Creating Pivot Charts from PivotTables
- Filtering with Slicers
- Updating Data
Taught by
Simon Sez IT
Related Courses
Related articles
Reviews
4.0 rating, based on 1 Class Central review
-
Sonam NagaIf you are a beginner to the Pivot table than this course is the right choice.
I didn't even realized how fast the time pass, its only 1 hour class and very precise.
I liked to attend more of your classes. Thank you.
