Section 1 : Getting Started
|
Lecture 1 | Course Structure & Outline | 00:03:26 Duration |
|
Lecture 2 | About Certification | |
|
Lecture 3 | DOWNLOAD Course Resources | |
|
Lecture 4 | Getting to Know the IMDb Movie Database | 00:02:21 Duration |
|
Lecture 5 | Setting Expectations | 00:01:15 Duration |
Section 2 : Excel Pivot Table 101
|
Lecture 1 | Why Pivot Tables | 00:04:11 Duration |
|
Lecture 2 | Structuring Source Data for Analysis in Excel | 00:02:01 Duration |
|
Lecture 3 | Creating Your First Pivot Table | 00:03:13 Duration |
|
Lecture 4 | IMPORTANT Add to Data Model | |
|
Lecture 5 | Navigating the Pivot Table Field List | 00:07:44 Duration |
|
Lecture 6 | KNOWLEDGE CHECK Manipulating the Pivot Table Field List | |
|
Lecture 7 | Exploring Pivot Table Analyze & Design Options | 00:01:34 Duration |
|
Lecture 8 | Selecting, Clearing, Moving & Copying Pivot Tables | 00:05:15 Duration |
|
Lecture 9 | Refreshing & Updating Pivot Tables | 00:07:30 Duration |
|
Lecture 10 | PRO TIP Dealing with Growing Source Data | 00:06:50 Duration |
|
Lecture 11 | Removing & Reviving Data from the Pivot Table Cache | 00:05:42 Duration |
|
Lecture 12 | PRO TIP How Excel Pivot Tables ACTUALLY Work | 00:03:40 Duration |
|
Lecture 13 | HOMEWORK Excel Pivot Table 101 |
Section 3 : Formatting Data with Pivot Tables
|
Lecture 1 | Changing Pivot Table Number Formats | |
|
Lecture 2 | PRO TIP Formatting Empty Pivot Table Cells | 00:01:42 Duration |
|
Lecture 3 | Configuring Pivot Table Layouts & Styles | 00:05:31 Duration |
|
Lecture 4 | PRO TIP Using Tabular Pivot Tables to Create New Source Data | 00:02:20 Duration |
|
Lecture 5 | Customizing Pivot Table Headers & Labels | 00:01:17 Duration |
|
Lecture 6 | Applying Basic Conditional Formats to Pivot Tables | 00:06:51 Duration |
|
Lecture 7 | PRO TIP Adding Data Bars with Invisible Text | 00:02:13 Duration |
|
Lecture 8 | Applying Advanced Conditional Formats to Pivot Tables | 00:06:51 Duration |
|
Lecture 9 | HOMEWORK Excel Pivot Table Formatting |
Section 4 : Sorting, Filtering & Grouping Data with Pivot Tables
|
Lecture 1 | Sorting Data with Pivot Tables | 00:05:02 Duration |
|
Lecture 2 | PRO TIP Fixing Incorrect Alphabetical Sorting | 00:02:02 Duration |
|
Lecture 3 | Filtering Data with Pivot Table Label & Selection Filters | |
|
Lecture 4 | PRO TIP Pivot Table Label Filters with Wildcards | 00:03:15 Duration |
|
Lecture 5 | Filtering Data with Pivot Table Value Filters | 00:03:10 Duration |
|
Lecture 6 | PRO TIP Enabling Multiple Pivot Table Filters | 00:02:42 Duration |
|
Lecture 7 | Grouping & Segmenting Data with Pivot Tables | 00:03:23 Duration |
|
Lecture 8 | PRO TIP Enabling & Disabling Automatic Date Grouping | 00:04:26 Duration |
|
Lecture 9 | Filtering Data with Pivot Table Slicers & Timelines | 00:04:52 Duration |
|
Lecture 10 | Breaking Out Pivot Table Report Filter Pages | 00:04:14 Duration |
|
Lecture 11 | HOMEWORK Sorting, Filtering & Grouping Data with Excel Pivot Tables |
Section 5 : Enriching Data with Pivot Table Calculated Values & Fields
Section 6 : Visualizing Data with Excel Pivot Charts
|
Lecture 1 | Intro to Excel Pivot Charts | 00:02:27 Duration |
|
Lecture 2 | Pivot Chart Demo Column Chart | 00:04:14 Duration |
|
Lecture 3 | Pivot Chart Demo Pie & Donut Charts | 00:05:47 Duration |
|
Lecture 4 | Pivot Chart Demo Clustered Bar Chart | 00:03:26 Duration |
|
Lecture 5 | PRO TIP Preventing Charts from Resizing with Cells | 00:04:46 Duration |
|
Lecture 6 | Changing Pivot Chart Types | 00:03:18 Duration |
|
Lecture 7 | Pivot Chart Demo Stacked Area Chart | |
|
Lecture 8 | Customizing Pivot Chart Layouts & Styles | 00:04:03 Duration |
|
Lecture 9 | Moving Pivot Charts to New Excel Worksheets | 00:02:10 Duration |
|
Lecture 10 | Applying Slicers & Timelines to Multiple Pivot Charts | 00:05:02 Duration |
|
Lecture 11 | Building Dynamic Dashboards with Pivot Tables & Pivot Charts | 00:13:23 Duration |
|
Lecture 12 | HOMEWORK Visualizing Data with Excel Pivot Charts |