Training: Excel – Preparing for data analysis

Ref. MOE-13

Download PDF

Duration:

0.5

day

Exam:

Not certifying

Level:

Intermediate

Funding:

Temptraining

ITTA | Trainings | Office Automation | Spreadsheet | Excel – Preparing for data analysis

Description

This Excel course will provide participants with the knowledge and skills necessary to prepare their data for analysis. They will learn how to use data tables, perform sorting, or use flash fill.

Participant profiles

Users who analyze data in Excel

Objectives

Work with a data table
Import and export data
Master the data entered in a table

Prerequisites

Basic knowledge of Excel

Course content

Module 1: Data tables

Use the Table function
Convert a table into a data range
Using the Fill button
Using the Flash Fill button
Performing simple, multi-criteria and custom sorting
Removing duplicates

Module 2: Importing and exporting data

Import external data (txt, csv files, data from the web)
Configure the imported columns
Export and share data

Module 3: Data entry in a table

Create and manage drop-down lists
Mastering data validation
Identify erroneous data in a table

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