Training: Excel – Analyze your data

Ref. MOE-23

Download PDF

Duration:

0.5

day

Exam:

Not certifying

Level:

Advanced

Funding:

Temptraining

ITTA | Trainings | Office Automation | Spreadsheet | Excel – Analyze your data

Description

This Excel course will allow participants to analyze their data using pivot tables, filters and data extractions.

Participant profiles

Users who analyze data in Excel

Objectives

Filter and extract data from a database
Create pivot tables
Perform calculations in a pivot table
Create pivot charts
Use slicers and timelines

Prerequisites

Good knowledge of Excel, including items listed in the course listed below: Excel – Preparing for data analysis

Course content

Module 1: Filtering and extracting data

Use the advanced filter
Set up your criteria zones
Define the extraction zone

Module 2: Inserting a pivot table

Prepare the data
Inserting a pivot table
Adding fields to a pivot table
Reorganize the fields in a pivot table
Delete fields from the pivot table
Refresh a pivot table

Module 3: Field settings

Modify summarizing in a pivot table
Use a calculated field in a pivot table
Insert a calculated field in a pivot table

Module 4: Pivot Charts

Create a pivot chart
Add and customize chart elements
Modify the format of pivot charts

Module 5: Using Slicers and Timelines

Insert a slicer
Insert a timeline
Manage slicer settings
Manage report connections

Documentation

Digital courseware 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