ComputerImages
Course Descriptions

Excel Dashboards Class

Subjects Covered

A dashboard is an 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 raw data by copying and pasting, import macros and linking to external data sources,
  • Adding charts to the dashboard,
  • Creating Pivot Tables and using them with a dashboard,
  • Using Slicers to filter data interactively,
  • Using Excel’s drawing tools to add visual elements to the dashboard, and
  • Testing the dashboard.

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

Class 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.

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

Excel, Advanced Excel, Excel Macros and Pivot Tables.
For private classes, we would be glad to adjust the curriculum to emphasize the topics of greatest interest to the students. See list of Excel topics.

If you prefer project-specific assistance, we are also available to work with you on a consulting basis.

Mailing List and Further Information

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

Class Schedule

ComputerImages15 Court Sq., BostonMA 02108(617) 720-6161 Visit us on FacebookVisit us on Twitter