This course will show you how to quickly build effective spreadsheets that are presented well. You'll improve your ability to use mathematical formulas. You'll learn how to implement a pivot table. You’ll be able to validate your skills with TOSA® certification, offered as an option.
Training at your location, our location or remotely
Ref. LMX
1d - 7h
Would you like to transpose this course—without changes—for your company?
A la carte training
Do you want a training course tailored to the needs of your company and its teams? Your training will be built to measure by our experts!
This course will show you how to quickly build effective spreadsheets that are presented well. You'll improve your ability to use mathematical formulas. You'll learn how to implement a pivot table. You’ll be able to validate your skills with TOSA® certification, offered as an option.
Teaching objectives
At the end of the training, the participant will be able to:
Consolidate your initial knowledge of Excel.
Master essential shortcuts
Use calculation formulas and functions
Analyze data and understand pivot tables
Intended audience
Self-taught Excel users who need to build their skills or are unsure if they want to attend an advanced-level training.
Prerequisites
Frequent user of Excel who has never been trained. Initial knowledge of Excel.
Course schedule
Effectively using shortcuts and essential commands
Mastering best practices and shortcuts: Avoid dead ends.
Knowing fast, effective, useful commands.
Hands-on work
Learn about and register for the TOSA® certification option. Discovering and applying useful shortcuts and best practices of use.
Designing an Excel table
Designing a simple table and laying it out.
Mastering the features of a structured table.
Presenting a data list.
Identifying the pros and cons of a structured table and a data list. Selection criteria.
Presenting and printing a table, a list.
Using Excel themes and styles.
Hands-on work
Creating and laying out a table. Designing filters and data lists. Applying formulas and functions.
Mastering calculation formulas and functions
Building your knowledge of simple operations: + - * / operators.
Mastering formulas with parentheses and percentages.
Using the $ character in formulas.
Paste link or paste values.
Copy and paste: Understanding how to copy formulas.
Discovering calculation functions: Common statistics (AVERAGE, COUNT, or COUNTA).
Creating calculation formulas in common management tables.
Hands-on work
Creating and editing computing formulas. Observations of differences in results.
Analyzing data
Getting to know pivot tables: Creating, updating, and formatting them.
Understanding and using report filters.
Choosing analysis fields and values.
Editing value field parameters. Choosing types of calculations.
Managing row and column labels.
Understanding the principle of data analysis in pivot tables.
Formating: The “Format as Table” command.
Online option: Schedule and take the TOSA® exam within 4 weeks.
Hands-on work
Creating pivot tables and analyzing data.
Certification
If registering for the TOSA® certification option, you must do so at the same time as course registration. The exam is made up of a 60-minute adaptive test with 35 exercises. The result indicates your skill level. Merely taking the course is not sufficient to achieve a maximum score. The exam must be both scheduled and then taken online within 4 weeks following the start of your session.
Practical details
Hands-on work
Discussions, experience-sharing, demonstrations, tutorials, and real cases.
Teaching methods;
Active learning based on examples, demonstrations, experience-sharing, real cases, and an evaluation of what was learned from the training.
Customer reviews
4,6 / 5
Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed.
Dates and locations
Select your location or opt for the remote class then choose your date.
Remote class
No session at the moment, we invite you to consult the schedule of distance classes.
1d
- 7h00 
