Master Excel Pivot Tables in this comprehensive 2-hour 40-minute tutorial for beginners. Learn to summarize datasets efficiently by creating and manipulating Pivot Tables. Follow along with the instructor using provided data files to clean and prepare information, create Excel tables, and build Pivot Tables from scratch or using recommended options. Explore various layout options, field management techniques, data summarization methods, and grouping strategies. Gain practical skills in formatting, handling missing data, and customizing report layouts to effectively analyze and present complex datasets.
Overview
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
Taught by
Simon Sez IT
