Course curriculum

    1. Segment - 01 - Introduction to the course

    2. Segment - 02 - Introduction of the Instructor

    3. Segment - 03 - Course Requirements

    4. Segment - 04 - How to get Excel

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

    2. Segment - 06 - What are Dashboards?

    3. Segment - 07 - Answers you need before you start a dashboard

    4. Segment - 08 - Best Practices for Dashboard Layout

    5. Segment - 09 - Best Practices for Dashboard Colors

    6. Segment - 10 - Section Summary

    1. Segment - 11 - What will we learn in this section?

    2. Segment - 12 - Build a Wireframe in Excel

    3. Segment - 13 - Prepare Raw Data for Dashboard

    4. Segment - 14 - Prepare Calculation Sheet

    5. Segment - 15 - Section Summary

    1. Segment - 16 - What will we learn in this section?

    2. Segment - 17 - Build a Combo Box

    3. Segment - 18 - Complex Lookup

    4. Segment - 19 - Build a Scrolling Data Table

    5. Segment - 20 - Conditionally Format Actual Values vs Budgeted Values

    6. Segment - 21 - Conditional Headers

    7. Segment - 22 - Section Summary

    1. Segment - 23 - What will we learn in this section?

    2. Segment - 24 - Show top matches over and under budget

    3. Segment - 25 - List box to select indicators

    4. Segment - 26 - Toggle between Top Over or Under

    5. Segment - 27 - Section Summary

    1. Segment - 28 - What will we learn in this section?

    2. Segment - 29 - Prepare Data for Scrolling Chart

    3. Segment - 30 - Scrollable Line Chart

    4. Segment - 31 - Remove Crashing Lines

    5. Segment - 32 - Toggle Visibility of Line Series

    6. Segment - 33 - Finetune the Line Series

    7. Segment - 34 - Section Summary

About this course

  • Free
  • 46 lessons
  • 5 hours of video content