Pivot Tables Excel - Detailed Beginners Pivot Table Tutorial

This beginner tutorial teaches how to clean Excel data and use Pivot Tables to summarize and analyze transactional datasets. It covers creating and formatting Excel tables, building Pivot Tables, managing fields, aggregating and grouping data, and formatting reports.

Syllabus

- What Are Pivot Tables
- Cleaning Excel Data
- Removing Blank Rows
- Removing Duplicate Rows
- Clearing Formatting
- Applying Number Formatting
- Changing the Case
- Removing Spaces and Non-printing Characters
- Merging and Splitting Columns
- Converting Numbers Stored as Text
- Find and Replace
- Spell Checking
- Excel Tables vs. Pivot Tables
- Formatting Data as an Excel Table
- Using Recommended Pivot Tables
- Creating a Pivot Table from Scratch
- Pivot Table Ribbons and Fields
- Pivoting Fields
- Adding Multiple Dimensions
- Deleting Fields and Locking the Report Layout
- Methods of Aggregation
- Combining Methods of Aggregation
- Grouping and Ungrouping Data in Excel
- Applying Number Formatting
- Handling Cells with No Data
- Subtotals and Grand Totals
- Choosing a Report Layout
- Inserting Blank Rows