Excel Dashboard Design for Business and Industry - Class

Build that customized hi-tech dashboard that fits your exact data needs. Learn to rapidly design powerful Excel dashboards that integrate, parse, analyze, and visualize your data.

Next Class: Check Dates

Microsoft Excel Dashboard Training

Explore Excel's untapped potential.

Class overview.

Our live, hands-on, 3-day class shows you how to develop industry grade dashboards that allow you to interact with and visualize your data in innovative ways.

It focuses on how to develop state of the art dashboards by combining key Excel elements like charts, ActiveX controls, shapes, pictures, Data Validation, Conditional Formatting, and worksheet cells. Also discussed is how to create the various dashboard types that organize your strategic, tactical, analytical… and KPI information.

Our class also covers how to process and calculate your data using various Excel functions, Excel tables, array formulas, Power Query, Power Pivot, and Pivot Tables. Emphasis is also placed on accessing, integrating, and formatting external data using Power Query and how to integrate weekly data downloads with your dashboards. It also shows how to create custom worksheet functions using LAMBDA or VBA to process your tough data.

Join us and we'll show you how to put all the Excel pieces together to produce that hi-tech dashboard that fits your exact needs.

Scroll < > and click to view what is possible.

Example1 Example2 Example3 Example4 Example5 Example6 Example7 Example8 Example9 Example10 Example11 Example12 Example13 Example14

Some key topics we cover in class.

Customers
View Customers >

Prerequisites for our Excel dashboard training.

Newsletter Signup
Newsletter Signup >

Class time, manual, and repeats.

Class syllabus, training, and price options.

Virtual Signup

View the dates and signup for our hands-on live virtual training.
Virtual Signup: $850.00 >

Public Signup

View the dates and signup for our hands-on in-person public training.
In-Person Signup: $950.00 >

Manual Information

Can't take the class, buy the self-study manual, apply the price later.
View Manual >

Onsite Details

Learn how we can help your business save time and effort in Excel.
View Onsite Details >

Class syllabus.

How we run the class: We focus our training on what our customers need. When training begins, we analyze those needs and shift our training outline appropriately. We will stress topics or add topics that our customers want. No two training sessions are ever the same with EMAGENIT.
Class PDF

Class Syllabus

Day-1

 Formula Design, Names, Linking Data, and Table Design

Designing Logic Formulas for Your Excel Dashboard

Processing Text and Performing Lookups with Functions

Designing UIs to Control Your Dashboard Formulas and Displays

Using Dynamic Names to Track Dashboard Data

Using Lambda and VBA to Create Custom Worksheet Functions

Day-2

Using Power Query to Access, Integrate, and Shape Your External Data

Dashboard Type, KPI, and Metric Review

Summarizing, Counting, and Analyzing Dashboard Data Using Logic

Using Array Formulas to Analyze Complex Dashboard Data

How to Use Linked Drawing Shapes and Pictures to Build Adaptive Dashboard Displays

Chart Construction, Formatting, and Constructs for Excel Dashboards

Day-3

Creating Speedometer, Linear, and Doughnut Gauges for Your Dashboards

Using Conditional Formatting to Build Various Status and Project / Timeline Displays

Excel Dashboard Design Strategies for Map Construction

Using Pivot Charts, PivotTables, and Power Pivot in Your Excel Dashboards

If you need to contact us about our class.

Phone Number: 1.805.498.7162

Business Hours: Mon-Fri 8:00 AM - 7:00 PM CT

You can email us at info@emagenit.com >

Form >
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2023

EMAGENIT All Rights Reserved