Course curriculum
-
-
1. Course Structure Outline
-
DOWNLOAD: Course Resources
-
4. Getting to Know the IMDb Movie Database
-
5. Setting Expectations
-
-
-
1. Why Pivot Tables
-
2. Structuring Source Data for Analysis in Excel
-
3. Creating Your First Pivot Table
-
IMPORTANT: Add to Data Model
-
5. Navigating the Pivot Table Field List
-
KNOWLEDGE CHECK: Manipulating the Pivot Table Field List
-
7. Exploring Pivot Table Analyze Design Options
-
8. Selecting, Clearing, Moving Copying Pivot Tables
-
9. Refreshing Updating Pivot Tables
-
10. PRO TIP Dealing with Growing Source Data
-
11. Removing Reviving Data from the Pivot Table Cache
-
12. PRO TIP How Excel Pivot Tables ACTUALLY Work
-
Quiz 1: QUIZ: Excel Pivot Table 101
-
HOMEWORK: Excel Pivot Table 101
-
-
-
1. Changing Pivot Table Number Formats
-
2. PRO TIP Formatting Empty Pivot Table Cells
-
3. Configuring Pivot Table Layouts Styles
-
4. PRO TIP Using Tabular Pivot Tables to Create New Source Data
-
5. Customizing Pivot Table Headers Labels
-
6. Applying Basic Conditional Formats to Pivot Tables
-
7. PRO TIP Adding Data Bars with Invisible Text
-
8. Applying Advanced Conditional Formats to Pivot Tables
-
Quiz 2: Excel Pivot Table Formatting
-
HOMEWORK: Excel Pivot Table Formatting
-
-
-
1. Sorting Data with Pivot Tables
-
2. PRO TIP Fixing Incorrect Alphabetical Sorting
-
3. Filtering Data with Pivot Table Label Selection Filters
-
4. PRO TIP Pivot Table Label Filters with Wildcards
-
5. Filtering Data with Pivot Table Value Filters
-
6. PRO TIP Enabling Multiple Pivot Table Filters
-
7. Grouping Segmenting Data with Pivot Tables
-
8. PRO TIP Enabling Disabling Automatic Date Grouping
-
9. Filtering Data with Pivot Table Slicers Timelines
-
10. Breaking Out Pivot Table Report Filter Pages
-
Quiz 3: Sorting, Filtering & Grouping Data with Excel Pivot Tables
-
HOMEWORK: Sorting, Filtering & Grouping Data with Excel Pivot Tables
-
-
-
1. Aggregating Summarizing Data with Pivot Tables
-
2. PRO TIP Avoiding the Pivot Table Count Of Trap
-
3. Defining Value Calculations with Pivot Tables
-
4. Calculating Pivot Table Values of ColumnRow
-
5. Calculating Pivot Table Values of Parent
-
6. Calculating Pivot Table Values Difference From
-
7. Calculating Pivot Table Values Running Total
-
8. Calculating Pivot Table Values Rank
-
9. Calculating Pivot Table Values Index
-
KNOWLEDGE CHECK: Pivot Table Value Calculations
-
11. Defining Calculated Fields with Pivot Tables
-
12. Creating Calculated Fields in Pivot Tables vs. Source Data
-
13. PRO TIP Pivot Table Calculations Using Count Columns (Part 1)
-
14. PRO TIP Pivot Table Calculations Using Count Columns (Part 2)
-
15. Inserting Pivot Table Calculated Items (USE WITH CAUTION)
-
16. Generating Solve Order List Formulas Reports
-
Quiz 4: Enriching Data with Pivot Table Calculated Values & Fields
-
HOMEWORK: Enriching Data with Pivot Table Calculated Values & Fields
-
-
-
1. Intro to Excel Pivot Charts
-
2. Pivot Chart Demo Column Chart
-
3. Pivot Chart Demo Pie Donut Charts
-
4. Pivot Chart Demo Clustered Bar Chart
-
5. PRO TIP Preventing Charts from Resizing with Cells
-
6. Changing Pivot Chart Types
-
7. Pivot Chart Demo Stacked Area Chart
-
8. Customizing Pivot Chart Layouts Styles
-
9. Moving Pivot Charts to New Excel Worksheets
-
10. Applying Slicers Timelines to Multiple Pivot Charts
-
11. Building Dynamic Dashboards with Pivot Tables Pivot Charts
-
Quiz 5: Visualizing Data with Excel Pivot Charts
-
HOMEWORK: Visualizing Data with Excel Pivot Charts
-
About this course
- Free
- 93 lessons
- 6.5 hours of video content