Course curriculum

  • 1

    Welcome to the course!

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

    Module One

    • Segment - 01 - Introduction to the course
    • Segment - 02 - Introduction of the Instructor
    • Segment - 03 - Course Requirements
    • Segment - 04 - How to get Excel
  • 3

    Module Two

    • Segment - 05 - What will we learn in this section?
    • Segment - 06 - What are Dashboards?
    • Segment - 07 - Answers you need before you start a dashboard
    • Segment - 08 - Best Practices for Dashboard Layout
    • Segment - 09 - Best Practices for Dashboard Colors
    • Segment - 10 - Section Summary
  • 4

    Module Three

    • Segment - 11 - What will we learn in this section?
    • Segment - 12 - Build a Wireframe in Excel
    • Segment - 13 - Prepare Raw Data for Dashboard
    • Segment - 14 - Prepare Calculation Sheet
    • Segment - 15 - Section Summary
  • 5

    Module Four

    • Segment - 16 - What will we learn in this section?
    • Segment - 17 - Build a Combo Box
    • Segment - 18 - Complex Lookup
    • Segment - 19 - Build a Scrolling Data Table
    • Segment - 20 - Conditionally Format Actual Values vs Budgeted Values
    • Segment - 21 - Conditional Headers
    • Segment - 22 - Section Summary
  • 6

    Module Five

    • Segment - 23 - What will we learn in this section?
    • Segment - 24 - Show top matches over and under budget
    • Segment - 25 - List box to select indicators
    • Segment - 26 - Toggle between Top Over or Under
    • Segment - 27 - Section Summary
  • 7

    Module Six

    • Segment - 28 - What will we learn in this section?
    • Segment - 29 - Prepare Data for Scrolling Chart
    • Segment - 30 - Scrollable Line Chart
    • Segment - 31 - Remove Crashing Lines
    • Segment - 32 - Toggle Visibility of Line Series
    • Segment - 33 - Finetune the Line Series
    • Segment - 34 - Section Summary
  • 8

    Module Seven

    • Segment - 35 - What will we learn in this section?
    • Segment - 36 - Column Chart Controlled by Slicer
    • Segment - 37 - Pivot Slicer Sorting
    • Segment - 38 - Select Only 1 Slicer
    • Segment - 39 - Dynamic Comments with Slicer
    • Segment - 40 - Section Summary
  • 9

    Module Eight

    • Segment - 41 - What will we learn in this section?
    • Segment - 42 - Add Calculations for Variances in Pivot Tables
    • Segment - 43 - Conditional Formatting in Pivot Tables
    • Segment - 44 - Refresh Pivot Table with Easy VBA
    • Segment - 45 - Section Summary
  • 10

    Module Nine

    • Segment - 46 - Course Summary and Next Steps