Excel Dashboard Design for Business and Industry

Microsoft Excel Dashboard Training

Next Class: Check Dates

Build that customized hi-tech dashboard that fits your exact data needs!

  Learn to quickly design powerful hi-tech dashboards that integrate, parse, analyze, and visualize your data. Canned dashboard programs cannot match the flexibility of Excel.

Class overview.

What makes our training different?

Our 3-day class  focuses on developing industry grade dashboards by combining Excel elements like charts, ActiveX controls, shapes...etc. It covers how to create various strategic, tactical… dashboard types that organize your KPI information.

Our class also discusses how to process and calculate your data using various functions / formulas, Excel tables, array formulas, and Pivot Tables.

Emphasis is also placed on accessing, integrating, and formatting downloaded external data in your dashboards using Power Query. Join us and we'll show you how to put all the Excel pieces together to produce that hi-tech dashboard that fits your needs.  See the Video >

Onsite Classes Designed for Your Problems

Some key topics we cover in class.

See What You Master
Close

Prerequisites for our Excel training.

Excel Manuals

Class time, duration, manual, and repeats.

Class syllabus and training options.

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

Day-1

Dashboard Formula Design, Using Names, and Linking Data

Storing, Filtering, and Referencing Your Dashboard Data

Designing Logic Formulas for Your Excel Dashboard

Processing Date, Time, and Text Data

Designing UIs to Control Your Dashboard Formulas and Displays

Using Dynamic Names to Track Dashboard Data

Using Table Lookups to Access and Display Your Dashboard Data

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

Building Milestone Charts for Your Excel Dashboards

Excel Dashboard Design Strategies for Map Construction

Using Pivot Charts and PivotTables 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 >

Click to View Form
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2023

EMAGENIT All Rights Reserved