Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Pivot Tables for Beginners
Section 1: Introduction
Course Introduction (5:10)
What are Pivot Tables and Why are They Useful? (6:11)
DOWNLOAD ME: Course Exercise Files
DOWNLOAD ME: Course Instructor Files
Section 2: Preparing Data for Analysis
The Importance of Cleaning Data (3:05)
Removing Blank Rows (5:30)
Removing Duplicate Rows (2:37)
Clearing Formatting (4:26)
Applying Number Formatting (8:38)
Changing the Case (9:15)
Removing Spaces and Non-printing Characters (10:06)
Merging and Splitting Columns (13:00)
Convert Numbers Stored as Text (2:28)
Finding and Replacing Text (6:07)
Spell Check (3:57)
Exercise 01 (4:01)
Section 3: The Importance of Excel Tables
Excel Tables vs Pivot Tables (5:24)
Format Data as a Table (8:47)
Exercise 02 (1:50)
Section 4: Creating a Basic Pivot Table Report
Using Recommended Pivot Tables (5:29)
Creating a Pivot Table from Scratch (5:45)
Pivot Table Ribbons and Fields (6:39)
Pivoting the Fields (5:32)
Adding Multiple Dimensions (2:47)
Deleting Fields and Locking the Report Layout (3:41)
Exercise 03 (1:37)
Section 5: Aggregation and Grouping
Methods of Aggregation (4:09)
Combining Methods of Aggregation (5:37)
Grouping and Ungrouping Data (9:45)
Exercise 04 (3:22)
Section 6: Formatting Values
Applying Number Formatting (4:45)
Handling Cells with No Data (4:00)
Exercise 05 (2:18)
Section 7: Layout Options
Subtotals and Grand Totals (4:26)
Choosing a Report Layout (4:44)
Inserting Blank Rows (2:13)
Exercise 06 (1:58)
Section 8: Formatting Pivot Tables
Applying Pivot Table Styles (4:15)
Modifying Pivot Table Styles (4:19)
Creating a Custom Pivot Table Style (5:37)
Exercise 07 (3:30)
Section 9: Sorting and Filtering
Sorting Pivot Table Data (8:31)
Filtering Pivot Table Data (7:20)
Top 10 Filter (3:31)
Exercise 08 (1:57)
Section 10: Creating Pivot Charts
Selecting the Right Chart Type (8:40)
Clustered Column and Bar Charts (13:40)
Line Charts (9:55)
Pie and Donut Charts (11:31)
Map Charts (8:47)
Applying Chart Layouts (3:06)
Exercise 09 (4:07)
Section 11: Formatting Pivot Charts
Adding a Slicer (7:38)
Formatting a Slicer (6:23)
Adding a Timeline (5:22)
Connecting Slicers and Timelines (5:30)
Exercise 10 (3:00)
Section 12: Applying Conditional Formatting
Highlight Cell Rules (5:37)
Data Bars (4:08)
Color Scales (3:20)
Icon Sets (4:26)
Exercise 11 (1:30)
Section 13: Updating Pivot Tables and Pivot Charts
Adding Data to the Dataset (2:37)
Updating Pivot Tables and Pivot Charts (1:40)
Exercise 12 (1:39)
Section 14: Course Close and Next Steps
Course Close and Next Steps (1:53)
Course Quiz and Certificate of Completion
The Importance of Cleaning Data
Complete and Continue