Home > Excel Class Guide > Excel Dashboards
Microsoft Excel Dashboard Training

Excel Dashboard Design for Business & Industry

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.

Next Class: Check Dates

  • Live, Hands-On, Industry Topics
  • Bring your problems
  • Limited class size
  • Taught by an Excel software developer
Dates / Sign Up >

Class overview.

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.  Key Topics >

Holiday Sale
Bolt

Key Topics

Bolt

Some key topics we cover in class.

See What You'll Learn!
See What You Master
Close
Bolt

Some Class Examples

Bolt
Excel Dashboard Preview
Bolt

Can't Attend? Get the Manual.

Bolt

Covers the Excel topics, strategies, and methods needed to solve your Excel workplace tasks quickly.

  • Our manual is a combination of beginning, intermediate, and advanced Excel topics and also covers hi-tech dashboard design.
  • Covers everything from typing data to using functions and formulas to automated reporting using Power Query, Excel tables, and Pivot Tables.
  • Also discusses must know topics like problem organization; using names to pass data efficiently; and data processing.
  • 100's of real world examples included.
  • Buy the manual now and apply its price to a class later. Just let us know when purchasing a class. The manual comes with the class.
See the Manual >
Bolt

Class Syllabus

Bolt
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

Bolt

Required Class Skills

Bolt

Select this Excel training if you or your group have:

Bolt

Class Details

Bolt

Duration, #days, and audience details about our class.

Bolt

Contact Us

Bolt

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-2022

EMAGENIT All Rights Reserved