Microsoft Excel Dashboards

MODULE 1: Introduction to Dashboards

Topics covered:

• Overview of how dashboards are so useful

MODULE 2: Inserting Graphics for a Dashboard

Topics covered:

• Inserting a Simple Chart
• Using Sparklines with Dashboards
• Using Tables to Dynamically Link Charts & Lists
• Linking Charts Across Worksheets

MODULE 3: Specialist Functions and Formulas

Topics covered:

• The OFFSET Function
• Nested IF Statements Using the AND and OR Operators
• VLOOKUPs
• The MATCH Function

MODULE 4: Dashboard Navigation

Topics covered:

• Creating Bespoke Navigation Bars
• Creating Dashboard Links
• Using Named Objects

MODULE 5: Preparing your Workbook's Layout and Structure

Topics covered:

• Organising Data in Data Tables using IFs
• Using Table Formulas to Make Dynamic Charts
• Using More Table Formulas with Conditional Formatting
• Using OFFSETs, VLOOKUPs and Name Range Lists

MODULE 6: Using Excel Objects for Specialist Dashboard Views

Topics covered:

• Adding a Data Bar into your Dashboard
• Creating a Window Chart
• Creating an Advanced Comparison Chart
• Creating a Timeline Chart

MODULE 7: Using Macros and VBA with Dashboards

Topics covered:

• Looking at Macros and the Visual Basic Interface
• Configuring Controls using Macros
• Ironing out Minor Issues in your Dashboard with VBA
• The Select Case