Course curriculum

    1. 1. Course Structure Outline

    2. DOWNLOAD: Course Resources

    3. 4. Getting to Know the IMDb Movie Database

    4. 5. Setting Expectations

    1. 1. Why Pivot Tables

    2. 2. Structuring Source Data for Analysis in Excel

    3. 3. Creating Your First Pivot Table

    4. IMPORTANT: Add to Data Model

    5. 5. Navigating the Pivot Table Field List

    6. KNOWLEDGE CHECK: Manipulating the Pivot Table Field List

    7. 7. Exploring Pivot Table Analyze Design Options

    8. 8. Selecting, Clearing, Moving Copying Pivot Tables

    9. 9. Refreshing Updating Pivot Tables

    10. 10. PRO TIP Dealing with Growing Source Data

    11. 11. Removing Reviving Data from the Pivot Table Cache

    12. 12. PRO TIP How Excel Pivot Tables ACTUALLY Work

    13. Quiz 1: QUIZ: Excel Pivot Table 101

    14. HOMEWORK: Excel Pivot Table 101

    1. 1. Changing Pivot Table Number Formats

    2. 2. PRO TIP Formatting Empty Pivot Table Cells

    3. 3. Configuring Pivot Table Layouts Styles

    4. 4. PRO TIP Using Tabular Pivot Tables to Create New Source Data

    5. 5. Customizing Pivot Table Headers Labels

    6. 6. Applying Basic Conditional Formats to Pivot Tables

    7. 7. PRO TIP Adding Data Bars with Invisible Text

    8. 8. Applying Advanced Conditional Formats to Pivot Tables

    9. Quiz 2: Excel Pivot Table Formatting

    10. HOMEWORK: Excel Pivot Table Formatting

    1. 1. Sorting Data with Pivot Tables

    2. 2. PRO TIP Fixing Incorrect Alphabetical Sorting

    3. 3. Filtering Data with Pivot Table Label Selection Filters

    4. 4. PRO TIP Pivot Table Label Filters with Wildcards

    5. 5. Filtering Data with Pivot Table Value Filters

    6. 6. PRO TIP Enabling Multiple Pivot Table Filters

    7. 7. Grouping Segmenting Data with Pivot Tables

    8. 8. PRO TIP Enabling Disabling Automatic Date Grouping

    9. 9. Filtering Data with Pivot Table Slicers Timelines

    10. 10. Breaking Out Pivot Table Report Filter Pages

    11. Quiz 3: Sorting, Filtering & Grouping Data with Excel Pivot Tables

    12. HOMEWORK: Sorting, Filtering & Grouping Data with Excel Pivot Tables

    1. 1. Aggregating Summarizing Data with Pivot Tables

    2. 2. PRO TIP Avoiding the Pivot Table Count Of Trap

    3. 3. Defining Value Calculations with Pivot Tables

    4. 4. Calculating Pivot Table Values of ColumnRow

    5. 5. Calculating Pivot Table Values of Parent

    6. 6. Calculating Pivot Table Values Difference From

    7. 7. Calculating Pivot Table Values Running Total

    8. 8. Calculating Pivot Table Values Rank

    9. 9. Calculating Pivot Table Values Index

    10. KNOWLEDGE CHECK: Pivot Table Value Calculations

    11. 11. Defining Calculated Fields with Pivot Tables

    12. 12. Creating Calculated Fields in Pivot Tables vs. Source Data

    13. 13. PRO TIP Pivot Table Calculations Using Count Columns (Part 1)

    14. 14. PRO TIP Pivot Table Calculations Using Count Columns (Part 2)

    15. 15. Inserting Pivot Table Calculated Items (USE WITH CAUTION)

    16. 16. Generating Solve Order List Formulas Reports

    17. Quiz 4: Enriching Data with Pivot Table Calculated Values & Fields

    18. HOMEWORK: Enriching Data with Pivot Table Calculated Values & Fields

    1. 1. Intro to Excel Pivot Charts

    2. 2. Pivot Chart Demo Column Chart

    3. 3. Pivot Chart Demo Pie Donut Charts

    4. 4. Pivot Chart Demo Clustered Bar Chart

    5. 5. PRO TIP Preventing Charts from Resizing with Cells

    6. 6. Changing Pivot Chart Types

    7. 7. Pivot Chart Demo Stacked Area Chart

    8. 8. Customizing Pivot Chart Layouts Styles

    9. 9. Moving Pivot Charts to New Excel Worksheets

    10. 10. Applying Slicers Timelines to Multiple Pivot Charts

    11. 11. Building Dynamic Dashboards with Pivot Tables Pivot Charts

    12. Quiz 5: Visualizing Data with Excel Pivot Charts

    13. HOMEWORK: Visualizing Data with Excel Pivot Charts

About this course

  • Free
  • 93 lessons
  • 6.5 hours of video content