< Excel Data Analysis Masterclass - Data Visualization

47 casts | 5:02:37 for the total course

created by Mammoth Interactive INC

  • 1. Intro to the Course
  • 2. Dashboards Intro

    • Excel Data Analysis | What Will We Learn In This Section | 2.1

    • Excel Data Analysis | What Are Dashboards | 2.2

    • Excel Data Analysis | Answers You Need Before You Start A Dashboard | 2.3

    • Excel Data Analysis | Best Practices For Dashboard Layout | 2.4

    • Excel Data Analysis | Best Practices For Dashboard Colors | 2.5

    • Excel Data Analysis | Section Summary | 2.6

  • 3. Build a Dashboard Project

    • Excel Data Analysis | What Will We Learn In This Section | 3.1

    • Excel Data Analysis | Build A Wireframe in Excel | 3.2

    • Excel Data Analysis | Prepare Raw Data For Dashboard | 3.3

    • Excel Data Analysis | Prepare Calculation Sheet | 3.4

    • Excel Data Analysis | Section Summary | 3.5

  • 4. Scrolling Data Table

    • Excel Data Analysis | What Will We Learn In This Section | 4.1

    • Excel Data Analysis | Build A Combo Box | 4.2

    • Excel Data Analysis | Complex Lookup | 4.3

    • Excel Data Analysis | Build A Scrolling Data Table | 4.4

    • Excel Data Analysis | Conditionally Format Actual Values vs Budgeted Values | 4.5

    • Excel Data Analysis | Conditional Headers | 4.6

    • Excel Data Analysis | Section Summary | 4.7

  • 5. Show Top Indicators

    • Excel Data Analysis | What We Will Learn In This Section | 5.1

    • Excel Data Analysis | Show Top Matches Over and Under Budget | 5.2

    • Excel Data Analysis | List Box to Select Indicators | 5.3

    • Excel Data Analysis | Toggle Between Top Over or Under | 5.4

    • Excel Data Analysis | Section Summary | 5.5

  • 6. Scrollable Line Chart

    • Excel Data Analysis | What Will We Learn In This Section | 6.1

    • Excel Data Analysis | Prepare Data For Scrolling Chart | 6.2

    • Excel Data Analysis | Scrollable Line Chart | 6.3

    • Excel Data Analysis | Remove Crashing Lines | 6.4

    • Excel Data Analysis | Toggle Visibility of Line Series | 6.5

    • Excel Data Analysis | Finetune the Line Series | 6.6

    • Excel Data Analysis | Section Summary | 6.7

  • 7. Interactivity

    • Excel Data Analysis | What Will We Learn In This Section | 7.1

    • Excel Data Analysis | Add Interactivity to Reports with Pivot Slicers | 7.2

    • Excel Data Analysis | Column Chart Controlled by Slicer | 7.3

    • Excel Data Analysis | Pivot Slicer Sorting | 7.4

    • Excel Data Analysis | Select Only 1 Slicer | 7.5

    • Excel Data Analysis | Dynamic Comments with Slicers | 7.6

    • Excel Data Analysis | Section Summary | 7.7

  • 8. Finetune the Dashboard

    • Excel Data Analysis | What Will We Learn In This Section | 8.1

    • Excel Data Analysis | Add Calculations For Variances in Pivot Tables | 8.2

    • Excel Data Analysis | Conditional Formatting in Pivot Tables | 8.3

    • Excel Data Analysis | Refresh Pivot Table with Easy VBA | 8.4

    • Excel Data Analysis | Section Summary | 8.5

  • 9. Course Summary

    • Excel Data Analysis | Course Summary and next Steps | 9.1

Excel Data Analysis | Intro To The Course | 1.1

Sign in to perform actions on this cast!
@mammoth 25 Followers
2 Views 0 Likes 0 Comments

Comment
Leave a comment (supports markdown format)