Training: Excel – Charts and Graphs

Ref. MOE-21

Download PDF

Duration:

0.5

day

Exam:

Not certifying

Level:

Advanced

Funding:

Eligible

Home > Trainings > Office Automation > Spreadsheet > Excel – Charts and Graphs

Description

This Excel course will enable you to master the creation of graphs and diagrams, as well as their formatting.

Participant Profiles

This module is intended for anyone who has to create and use graphs in the course of their jobs, as well as to make a graphic analysis of data

Objectives

Present their data in a visual way using the most appropriate graphics
Use graphical objects
Create graphs for data analysis

Prerequisites

Prior to attending this training, participants should have a working knowledge of Microsoft Excel or have completed the following training modules: Excel – Fundamentals, Excel – Becoming more efficient and Excel – Preparing for data analysis

Course Content

Module 1: Charts

Creating a chart
Moving and resizing a chart
Apply a predefined chart layout or style
Add or remove chart elements
Manually change the layout and formatting of chart elements
Select the most representative chart type
Create a two axis chart
Insert a trend line
Save a graph as a template

Module 2: Graphic Objects

Insert shapes and connectors
Formatting graphic objects
Define the default style for your objects
Use the Selection Pane

Module 3: Graphical analysis of data

Create an age pyramid
Create an climatogram
Create a bubble chart

Documentation

Digital course material included

Lab / Exercises

Practice exercises will be given at the end of each module

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

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