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
What are Pivot Tables and Why are They Useful?
Complete and Continue
Lesson Content Locked
Your session expired. Please sign in again to continue.
Login