Microsoft Excel – Creating Dynamic Dashboards

Course Curriculum

Chapter 1: Course Introduction

Lecture 1: Important – Download These First – Working Files

Lecture 2: About This Series

Lecture 3: What You Will Learn

Lecture 4: How To Access Your Working Files

Chapter 2: Deciding On Dashboards

Lecture 1: Deciding On Dashboards

Lecture 2: Reports, Dashboards And Scorecards

Lecture 3: Pondering The Plan

Lecture 4: Selecting Measures And Metrics

Chapter 3: Preparing The Data

Lecture 1: Preparing The Data

Lecture 2: Data Modeling Basics

Lecture 3: Structuring The Workbook

Lecture 4: Connecting To Data – Part 1

Lecture 5: Connecting To Data – Part 2

Lecture 6: Simplifying Data With Named Ranges

Lecture 7: Leveraging The Efficiency Of Tables

Lecture 8: Harnessing The Power Of Pivot Tables

Lecture 9: Managing Connected Data

Lecture 10: Simplifying With Custom Number Formats

Chapter 4: Building Dashboards

Lecture 1: Building Dashboards

Lecture 2: Dashboard Design Rules

Lecture 3: Managing Branding With Custom Themes

Lecture 4: Creating The Navigation Bar – Part 1

Lecture 5: Creating The Navigation Bar – Part 2

Lecture 6: Creating The Navigation Bar – Part 3

Lecture 7: What Is In A Word?

Lecture 8: Building Out Worksheets And Navigation

Lecture 9: Summarizing Data Using Groups

Lecture 10: Configuring Show Values As For Pivot Tables

Lecture 11: Assigning Categories Using Nested If

Lecture 12: Identifying Top Ten Values

Lecture 13: Finding The Last Value In A Series

Chapter 5: Getting Visual

Lecture 1: Getting Visual

Lecture 2: Customizing Display With Text-Based Elements

Lecture 3: Alerting With Conditional Formatting

Lecture 4: Chart And Sparkline Review

Lecture 5: Creating Sparklines For Dashboards

Lecture 6: Creating Charts For Dashboards

Lecture 7: Using A Waffle Chart To Show Progress

Lecture 8: Using The Excel Camera

Lecture 9: Creating A Distribution Histogram

Lecture 10: Hitting The Mark With Bullet Graphs

Chapter 6: Adding Interactivity

Lecture 1: Adding Interactivity

Lecture 2: Displaying The Developer Tab

Lecture 3: Understanding Interactive Dashboard Controls

Lecture 4: Adding Actions To Buttons

Lecture 5: Creating Custom Content With Combo Boxes

Lecture 6: Simplifying With Check Boxes

Lecture 7: Facilitating Filtering With Slicers And Timelines

Lecture 8: Finalizing By Color-Coding, Hiding And Protecting Worksheets

Chapter 7: Generating Dashboards As Output

Lecture 1: Generating Dashboards As Output

Lecture 2: Producing Dashboards As PDF

Lecture 3: Presenting Dashboards With Powerpoint

Lecture 4: Sharing Dashboards Via OneDrive

Chapter 8: Conclusion

Lecture 1: What You Now Know