Course curriculum

  • 1

    Module 01: Introduction to the Course

    • Segment - 01 - Introduction to the Course
    • Segment - 02 - Why should you learn about Charts and Data Visualization
    • Segment - 03 - Introduction of the Instructor
    • Segment - 04 - Course Requirements (what software, experience)
  • 2

    Module 02: Charts and Basics

    • Segment - 05 - What will we learn in this section
    • Segment - 06 - Main Principles and Chart Visualization Impact
    • Segment - 07 - Choosing the Correct Chart
    • Segment - 08 - Communicate with the End User
    • Segment - 09 - Section Summary
    • Segment - 10 - Challenge
  • 3

    Module 03: Excel Chart Tools

    • Segment - 12 - Chart Design
    • Segment - 13 - Working with Chart Formats
    • Segment - 14 - Chart Types
    • Segment - 15 - Primary and Secondary Axis
    • Segment - 15A
    • Segment - 16 - Chart Templates
    • Segment - 17 - Section Summary
    • Segment - 18 - Challenge
  • 4

    Module 04: Working with Basic Excel Charts & Graphs

    • Segment - 19 - What will we learn in this section
    • Segment - 20 - Excel Column Charts
    • Segment - 21 - Column Charts Challenge
    • Segment - 22 - Excel Bar Charts
    • Segment - 23 - Excel Bar Charts 1
    • Segment - 24 - Bar Charts Challenge
    • Segment - 25 - Excel Line Charts
    • Segment - 26 - Line Charts Challenge
    • Segment - 27 - Excel Pie Charts
    • Segment - 28 - Pie Charts Challenge
    • Segment - 29 - Excel Area Charts
    • Segment - 30 - Area Charts Challenge
    • Segment - 31 - Excel Scatter Charts
    • Segment - 32 - Scatter Charts Challenge
    • Segment - 33 - Excel Bubble Charts
    • Segment - 34 - Bubble Charts Challenge
    • Segment - 35 - Excel Stock Charts
    • Segment - 36 - Stock Charts Challenge
    • Segment - 37 - Excel Surface Charts
    • Segment - 38 - Surface Charts Challenge
    • Segment - 39 - Excel Radar Charts
    • Segment - 40 - Radar Charts Challenge
    • Segment - 41 - Excel Treemap Charts
    • Segment - 42 - Treemap Charts Challenge
    • Segment - 43 - Excel Sunburst Charts
    • Segment - 44 - Sunburn Charts Challenge
    • Segment - 45 - Excel Histogram and Pareto Charts
    • Segment - 46 - Histogram and Pareto Charts Challenge
    • Segment - 47 - Excel Waterfall Charts
    • Segment - 48 - Waterfall Charts Challenge
    • Segment - 49 - Excel Box & Whisker Charts
    • Segment - 51 - Excel Sparklines
    • Segment - 52 - Sparklines Challenge
    • Segment - 53 - Excel Color Scales
    • Segment - 54 - Color Scales Challenge
    • Segment - 55 - Excel 3D Map
    • Segment - 56 - 3D Map Challenge
    • Segment - 57 - Section Summary
  • 5

    Module 05: Excel Advanced Data Visualization

    • Segment - 58 - What will we learn in this section
    • Segment - 59 - Data Visualization with Pivot Chart and Slicers
    • Segment - 60 - Data Visualization with Pivot Chart and Slicers Challenge
    • Segment - 61 - Create Break Even Chart
    • Segment - 62 - Challenge Create Break Even Chart
    • Segment - 63 - Rating Star Chart
    • Segment - 64 - Challenge Rating Star Chart
    • Segment - 65 - Drop Down Menu for Chart
    • Segment - 66 - Challenge Drop Down Menu for Chart
    • Segment - 67 - Risk Score Chart
    • Segment - 68 - Risk Score Chart Challenge
    • Segment - 69 - Dynamic Chart Update
    • Segment - 70 - Challenge Dynamic Chart Update
    • Segment - 71 - Section Summary
  • 6

    Module 06: Conclusion

    • Segment - 72 - Course Summary and Next Steps