Learn how to create and utilize Pivot Tables in Excel with this comprehensive 52-minute tutorial. Start from the basics and progress to advanced techniques, including data analysis, Pivot Chart creation, and the use of filters and Slicers. Explore topics such as dataset understanding, data cleaning, table formatting, field pivoting, data grouping, value field settings, number formatting, subtotals and grand totals, report layouts, PivotTable styles, and data updating. Follow along with downloadable Excel files and gain practical skills to enhance your data analysis capabilities in under an hour.
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.
