GE341

Management Dashboards with MS Excel

90%

overall satisfaction for this course

?Average calculated from scores obtained from 18 participants who took this course.
See the training dates
  • Duration 2 days
  • Regular fee 945
  • Preferential fee 850?
  • Locations
    • Virtual Classroom
  • Laboratory
    course

Accreditation and partner associations

  • Project Management Institute 12 PDU

Objectives

To provide the knowledge and skills required to use the various features of Excel to create dashboards without VBA programming.

Targeted audience

Managers and employees

Prerequisite

Intermediate knowledge of MS Excel. Experience with dynamic pivot tabless (Course CH166).

Training Details

Content

  • Examples of dashboards: information systems, project heads, etc.
  • Building the dashboard summary page: choosing indicators by department
  • Advanced dynamic pivot tables
  • Advanced macro-commands
  • Budget preparation and follow-up

General Note

At the end of this training, yoiu will have a real exemple of dashboard for a company.

Customer Testimonials

Excellent course to improve their knowledges.

Robert P. / Conseiller Environnements informatiques, Hydro-Québec

Select the training date*

*Unless stated otherwise, all sessions are in French.
  • Virtual Classroom

    July 16 to July 17 2020

  • Virtual Classroom

    November 12 to November 13 2020

Trainer(s) assigned(s)