MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Microsoft Excel - Creating Dynamic Dashboards

Course Summary

Learn how to create functional, attractive dashboards to present your data in more useful ways.

  • +

    Course Syllabus

    • Course Introduction
      • Important - Download These First - Working Files
      • About This Series
      • What You Will Learn
      • How To Access Your Working Files
    • Deciding On Dashboards
      • Deciding On Dashboards
      • Reports, Dashboards And Scorecards
      • Pondering The Plan
      • Selecting Measures And Metrics
    • Preparing The Data
      • Preparing The Data
      • Data Modeling Basics
      • Structuring The Workbook
      • Connecting To Data - Part 1
      • Connecting To Data - Part 2
      • Simplifying Data With Named Ranges
      • Leveraging The Efficiency Of Tables
      • Harnessing The Power Of Pivot Tables
      • Managing Connected Data
      • Simplifying With Custom Number Formats
    • Building Dashboards
      • Building Dashboards
      • Dashboard Design Rules
      • Managing Branding With Custom Themes
      • Creating The Navigation Bar - Part 1
      • Creating The Navigation Bar - Part 2
      • Creating The Navigation Bar - Part 3
      • What Is In A Word?
      • Building Out Worksheets And Navigation
      • Summarizing Data Using Groups
      • Configuring Show Values As For Pivot Tables
      • Assigning Categories Using Nested If
      • Identifying Top Ten Values
      • Finding The Last Value In A Series
    • Getting Visual
      • Getting Visual
      • Customizing Display With Text-Based Elements
      • Alerting With Conditional Formatting
      • Chart And Sparkline Review
      • Creating Sparklines For Dashboards
      • Creating Charts For Dashboards
      • Using A Waffle Chart To Show Progress
      • Using The Excel Camera
      • Creating A Distribution Histogram
      • Hitting The Mark With Bullet Graphs
    • Adding Interactivity
      • Adding Interactivity
      • Displaying The Developer Tab
      • Understanding Interactive Dashboard Controls
      • Adding Actions To Buttons
      • Creating Custom Content With Combo Boxes
      • Simplifying With Check Boxes
      • Facilitating Filtering With Slicers And Timelines
      • Finalizing By Color-Coding, Hiding And Protecting Worksheets
    • Generating Dashboards As Output
      • Generating Dashboards As Output
      • Producing Dashboards As PDF
      • Presenting Dashboards With Powerpoint
      • Sharing Dashboards Via OneDrive
    • Conclusion
      • What You Now Know

Course Fee:
USD 49

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations , Data & Information Management and E-Commerce Community

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top