Course curriculum

    1. Segment - 01 - Introduction to the Course

    2. Segment - 02 - Why should you learn Pivot Tables

    3. Segment - 03 - Introduction of the Instructor

    4. Segment - 04 - Course Requirements (what software, experience)

    5. Source File

    1. Segment - 05 - What will we learn in this section

    2. Segment - 06 - What is a Pivot Table

    3. Segment - 07 - Pivot Table Basics

    4. Segment - 08 - Pivot Table Compilant Data Sources

    5. Segment - 09 - Build a Basic Pivot Table

    6. Segment - 10 - Section Summary

    7. Segment - 11 - Challenge

    8. Source File

    1. Segment - 12 - What will we learn in this section

    2. Segment - 13 - Introduction to Formatting Pivot Tables

    3. Segment - 14 - Build an Expense Report

    4. Segment - 15 - Format the Expense Report Pivot Table

    5. Segment - 16 - Finalize the Expense Report Pivot Table

    6. Segment - 17 - Section Summary

    7. Segment - 18 - Challenge

    8. Source File

    1. Segment - 19 - What will we learn in this section

    2. Segment - 20 - What are Excel Tables

    3. Segment - 21 - Sales Report Analysis

    4. Segment - 22 - Complete the Sales Report Analysis

    5. Segment - 23 - Format the Sales Report

    6. Segment - 24 - Modify Source Data

    7. Segment - 25 - Section Summary

    8. Segment - 26 - Challenge

    9. Source File

    1. Segment - 27 - What will we learn in this section

    2. Segment - 28 - What is Slicing Data

    3. Segment - 29 - Slicing Data Project

    4. Segment - 30 - Data Slicer Tools

    5. Segment - 31 - Links Slicer to Multiple Pivot Tables

    6. Segment - 32 - Section Summary

    7. Segment - 33 - Challenge

    8. Source File

    1. Segment - 34 - What will we learn in this section

    2. Segment - 35 - Connect to Databases

    3. Segment - 36 - Import Data Sources

    4. Segment - 37 - Use Pivot Tables to Refine Data

    5. Segment - 38 - Consolidate your Data Table

    6. Segment - 39 - Format Large Data Sets

    7. Segment - 40 - Slicer and Timeline in Large Data Sets

    8. Segment - 41 - Refresh and Drill Down from Databases

    9. Segment - 42 - Section Summary

    10. Segment - 43 - Challenge

    11. Source File

About this course

  • Free
  • 49 lessons
  • 3 hours of video content