ComputerImages
Course Descriptions

Microsoft Excel Dashboards Class

What You Will Learn

A dashboard is a Microsoft Excel worksheet that summarizes data using tables and charts, both to provide reports and enable people to query large quantities of information. You can how they work in a YouTube video.

This course shows you how to create a dashboard from scratch. Class discussion and exercises cover —

  • What the dashboard can do and how you can use it,
  • Planning a dashboard,
  • Entering and updating data by copying and pasting, import macros and linking to external data sources,
  • Adding charts to the dashboard,
  • Creating Tables and Pivot Tables and using them with a dashboard,
  • Using Slicers to filter data interactively,
  • Using Combo Boxes to change dashboard settings,
  • Creating dynamic messages with text calculations and functions,
  • Using conditional formatting, functions and the Camera Tool to adjust appearance depending upon the data,
  • Using Excel’s drawing tools to add visual elements to the dashboard, and
  • Testing the dashboard.

6 hours, $260 (available for Windows and Macintosh)

Training Format

  • Live trainer in room — not on-line or remote learning,
  • Exercise-based, hands-on classroom instruction,
  • Emphasis on questions and student participation,
  • Small size (limited to 8), personal attention.

Class Location

Dates and Registration

Prerequisites

A working knowledge of Excel, including how to create formulas and charts, sort and filter data and format a worksheet.

Related Classes and Services

Classes: Excel, Advanced Excel, Excel Macros and Pivot Tables.

We also offer consulting, private classes and one-on-one training. See Excel Services page for more information.

Mailing List and Further Information

Monthly newsletter and schedule: join our Mailing List.
For more information, please contact us.

Class Schedule · ComputerImages Excel Resources · Excel Support Links · Excel Tips

© Copyright 2018, 2017, ComputerImages. All rights reserved.
URL: www.computerimages.com / course_descriptions / d-excel-dashboard-class.html
Excel Dashboards Course Outline, Updated May 8, 2018.