Home > Excel Class Guide > Excel Dashboards

Excel Dashboard Design Class for Business and Industry

Microsoft Excel Dashboard Training

Learn to assemble Excel's "pre-made" features to create powerful hi-tech dashboards that integrate, analyze, and visualize your data.

  • Our 3-day class focuses on developing industry grade dashboards by combining Excel elements like charts, ActiveX controls, shapes...etc.
  • Also covered is how to create various strategic, tactical… dashboard types that organize your KPI information.
  • Other topics include 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 and much more >.

Next Class: 11/30/2022

More Dates >

Black Friday Sale

See the must know topics you will learn.

See What You Master
Close

No time to attend, get a manual instead.

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. Learn More >
  • Buy a manual now, apply the price towards a class later. Manuals are included with our classes.

Key Excel topics covered in class.

Excel Dashboard Preview

Class examples.

Pricing and class options.

virtual learning

Online Virtual Learning

  • Live, hands-on, talk to the instructor training
  • Bring your own problems to class
  • Online Details >
Dates / Signup >
virtual learning

Public In-Person Learning

  • Live hands-on training
  • Bring your own problems to class
  • We can supply a computer
Dates / Signup >
corporate learning

Onsite Hands-On Learning

  • We come to you and solve your problems
  • We cover in person in the USA and Canada
  • We cover the world virtually using your time zone
Details >

Detailed 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 Syllabus

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

Additional Classes:
Beginning Excel
for Business / Industry
Intermediate Excel
for Business / Industry
Advanced Excel
for Business / Industry
Excel Dashboard Design
for Business / Industry
Beginning Excel VBA
for Business / Industry
Excel VBA Data Processing
for Business / Industry
Advanced Excel VBA
for Business / Industry
Learn the key Excel topics and problem solving skills you need to quickly accomplish everyday Excel workplace tasks. Learn to use tables, formulas, functions, and Excel's data tools to quickly perform calculations, analyze data, and create reports. Learn about Excel's advanced querying, formula, and data processing capabilities and use them to build automated calculation and reporting tools. Learn to assemble Excel's pre-made features to create powerful hi-tech dashboards that integrate, analyze, and visualize your data. Learn to build time-saving Excel VBA tools that automate common data processing, calculation, and formatting tasks in seconds. Learn to create powerful data tools in Excel VBA that quickly process, integrate, and report data from multiple sources, files, and folders. Learn to command the advanced abilities of Excel VBA and userforms to create interface driven data processing, analysis, and dashboard tools.

Excel skills needed for our class.

Select this Excel training if you or your group have:

  • Constructed general worksheet formulas like =A1+A2
  • Constructed cell references and range references like A1 or A1:A10
  • Used worksheet functions like SUM, MAX, MIN...before
  • Used Microsoft Excel's data tools before
  • Formatted a worksheet before
  • Built charts and drawing shapes

The training details.

If you need to contact us about our training.

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 >

Contact us by form.

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

Copyright © 2002-2022

EMAGENIT All Rights Reserved