Training: Excel – Analyze your data

Ref. MOE-23

Download PDF

Duration:

0.5

day

Exam:

Not certifying

Level:

Advanced

Funding:

Eligible

Home > 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 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