< 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
  • Excel Data Analysis | Intro To The Course | 1.1

  • Excel Data Analysis | Intro Of The Instructor | 1.2

  • Excel Data Analysis | Course Requirements | 1.3

  • Excel Data Analysis | How To Get Excel | 1.4

• 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