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 Mastery: Creating Interactive Dashboards

Course Summary

Learn how to create amazing interactive Excel Dashboards that will wow your boss & take your career to the next level.


  • +

    Course Syllabus

    • Introduction
      • Course Overview and Introduction to Excel Dashboards
    • Getting Your Data Ready
      • Ideal Data Formats
    • Design Principles
      • Getting Your Design Right
    • Display Principles
      • Charts and Tricks for Trending
      • Secondary Axis
      • Smoothing Data
      • Sparklines
      • Formatting Tricks
      • Highlighting Comparisons
      • Top and Bottom Ranking
      • Frequency Distribution
      • Target vs Variance Charts
      • Performance Against Target Range
      • Bullet Graphs
      • Win/Loss/Draw Conditional Format
      • Dynamic Data Range
      • Dynamic Labels
      • Text Formulas
      • Symbols in Formulas and Charts
      • Charts Referencing Non-contiguous Ranges
      • Embedding Graphics in Charts
      • Dynamic, Dynamic Data Validation Lists
      • In Cell Charts
      • Panel Charts
      • Step Charts
      • Supplementary Excel Lecture: Excel 2013 Chart Formatting
      • Supplementary Excel Lecture: Excel 2013 Chart Labels
      • Supplementary Excel Lecture: Excel 2013 Combo Charts
    • Interactive Controls
      • Form Controls Introduction
      • Check Boxes
      • List Boxes
      • Option Buttons
      • Group Boxes
      • Scroll Bar
      • Buttons
      • Combo Box with Macro
      • Dynamic Date Filters 4 Ways
      • Dynamic Named Range with OFFSET
      • Dynamic Named Range with INDEX
      • Dynamic Ranges for Charts
      • Animating Charts
      • INDIRECT Function Tricks
      • Rollover Technique
      • Scroll and Sort Table
      • Supplementary Excel Lecture: Inserting Drop Down Lists
    • Analysing the Data
      • PivotCharts
      • Slicers
      • Capture Slicer Selection in Formula
      • GETPIVOTDATA Function
      • Slicer & PivotChart Olympic Dashboard Overview
      • Supplementary Excel Lecture: Creating PivotTables
      • Supplementary Excel Lecture: Choosing Fields
      • Supplementary Excel Lecture: PivotTable Layout
      • Supplementary Excel Lecture: Filtering PivotTables
      • Supplementary Excel Lecture: Modifying PivotTable Data
      • Supplementary Excel Lecture: Insert a Table and Style Options
      • Supplementary Excel Lecture: Add Rows and Columns to a Table
      • Supplementary Excel Lecture: Perform a Function in a Table
      • Supplementary Excel Lecture: Summarize a Table with a PivotTable
      • Supplementary Excel Lecture: VLOOKUP Formula Sorted List
      • Supplementary Excel Lecture: VLOOKUP Formula Exact Match
      • Supplementary Excel Lecture: HLOOKUP Formula Sorted List
      • Supplementary Excel Lecture: HLOOKUP Formula Exact Match
      • Supplementary Excel Lecture: CHOOSE Function
      • Supplementary Excel Lecture: INDEX and MATCH Formula
      • Supplementary Excel Lecture: IF Function
      • Supplementary Excel Lecture: Nested IF Formula
      • Supplementary Excel Lecture: IF AND Formula
      • Supplementary Excel Lecture: IF OR Formula
      • Supplementary Excel Lecture: IF NOT Formula
      • Supplementary Excel Lecture: IFERROR Function
      • Supplementary Excel Lecture: SUMIF and SUMIFS Formulas
      • Supplementary Excel Lecture: AVERAGEIF and AVERAGEIFS Formulas
      • Supplementary Excel Lecture: COUNTIF and COUNTIFS Formulas
      • Supplementary Excel Lecture: SUMPRODUCT Formula
    • Automating Your Dashboard
      • Linking to Access
      • Incorporating New Data Automatically
      • Auto Refresh PivotTables
      • Supplementary Excel Lecture: Introduction to Macros
      • Supplementary Excel Lecture: Recording a Macro
      • Supplementary Excel Lecture: Assign a Macro to a Button or Shape
      • Supplementary Excel Lecture: Run a Macro Upon Opening a Workbook
      • Supplementary Excel Lecture: How to Inspect and Modify a Macro
    • Putting It All Together
      • Quick Re-cap
      • Example Dashboard Tour
      • Pyramid Chart
      • Array Formula Alternative to SUMIFS
      • LARGE and SMALL Array and DAVERAGE
      • Rank Values with PivotTable
      • Scatter Chart
      • DMAX, DMIN, DAVERAGE
      • Formatting Quickly
    • Distributing Your Dashboard
      • Checking and Publishing
      • Excel Web App - Introduction
      • Preparing Your File for Excel Web App
      • Publish with Excel Web App
      • Password Protection
      • Supplementary Excel Lecture: Workbook Passwords
      • Supplementary Excel Lecture: Protecting Workbooks
      • Supplementary Excel Lecture: Unlocking Cells
    • Bonus: Tour de France Dashboard
      • Dashboard Overview
      • SUMIFS Formula
      • INDEX, MATCH and OFFSET Formula
      • INDEX, MATCH Multiple Array Formula
      • Zoom Images VBA Code
    • Homework
      • Homework Challenge
      • Mynda's Homework Dashboard Part 1
      • Mynda's Homework Dashboard Part 2
    • Course Wrap Up
      • Thanks for Joining


Course Fee:
USD 197

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
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