Training: Excel – Dashboards in Excel

Ref. MOE-26

Download PDF

Duration:

0.5

day

Exam:

Not certifying

Level:

Advanced

Funding:

Temptraining

ITTA | Trainings | Office Automation | Spreadsheet | Excel – Dashboards in Excel

Description

This training will enable participants to create dashboards that are easily understood and used by everyone.

Participant profiles

Users who analyze data in Excel and present it to others

Objectives

Set up a dashboard
Create specific charts such as maps or gauges
Set up the dashboard to facilitate the use of data

Prerequisites

Knowledge of data analysis, charts and formatting in Excel

Course content

Module 1: Dashboards

Understand the purpose of a dashboard
Determine what values to show on your dashboard
Preparing the data

Module 2: Charts

Adding geographic data
Creating a map chart
Inserting a scatter chart
Inserting gauge type charts

Module 3: Finalizing the dashboard

Setting up data on the dashboard
Adding slicers and timelines
Final formatting

Documentation

Digital course material included

Lab / Exercises

Practice exercises will be given at the end of each module

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.

Additional information

As we care about the quality of our training, ITTA offers you an online skills assessment test before and after your course so that you can evaluate your progress
Explore all our Microsoft Office courses by clicking here