Course curriculum

  • 1

    Welcome to the course!

    • Instructor bio - John Bura
    • Key pointers for this program
    • Joining the Alumni Community
  • 2

    Introduction to the Course

    • Segment - 01 - Introduction to the Course
    • Segment - 02 - Why should you learn Pivot Tables
    • Segment - 03 - Introduction of the Instructor
    • Segment - 04 - Course Requirements (what software, experience)
    • Source File
  • 3

    PivotTables Fundamental Projects

    • Segment - 05 - What will we learn in this section
    • Segment - 06 - What is a Pivot Table
    • Segment - 07 - Pivot Table Basics
    • Segment - 08 - Pivot Table Compilant Data Sources
    • Segment - 09 - Build a Basic Pivot Table
    • Segment - 10 - Section Summary
    • Segment - 11 - Challenge
    • Source File
  • 4

    Format Pivot Tables

    • Segment - 12 - What will we learn in this section
    • Segment - 13 - Introduction to Formatting Pivot Tables
    • Segment - 14 - Build an Expense Report
    • Segment - 15 - Format the Expense Report Pivot Table
    • Segment - 16 - Finalize the Expense Report Pivot Table
    • Segment - 17 - Section Summary
    • Segment - 18 - Challenge
    • Source File
  • 5

    Excel Tables

    • Segment - 19 - What will we learn in this section
    • Segment - 20 - What are Excel Tables
    • Segment - 21 - Sales Report Analysis
    • Segment - 22 - Complete the Sales Report Analysis
    • Segment - 23 - Format the Sales Report
    • Segment - 24 - Modify Source Data
    • Segment - 25 - Section Summary
    • Segment - 26 - Challenge
    • Source File
  • 6

    Slice and Dice Your Data

    • Segment - 27 - What will we learn in this section
    • Segment - 28 - What is Slicing Data
    • Segment - 29 - Slicing Data Project
    • Segment - 30 - Data Slicer Tools
    • Segment - 31 - Links Slicer to Multiple Pivot Tables
    • Segment - 32 - Section Summary
    • Segment - 33 - Challenge
    • Source File
  • 7

    Connect to Databases

    • Segment - 34 - What will we learn in this section
    • Segment - 35 - Connect to Databases
    • Segment - 36 - Import Data Sources
    • Segment - 37 - Use Pivot Tables to Refine Data
    • Segment - 38 - Consolidate your Data Table
    • Segment - 39 - Format Large Data Sets
    • Segment - 40 - Slicer and Timeline in Large Data Sets
    • Segment - 41 - Refresh and Drill Down from Databases
    • Segment - 42 - Section Summary
    • Segment - 43 - Challenge
    • Source File