At the end of the training, the participant will be able to:
Get started with the work interface
Create and present a spreadsheet
Design formulas
Manage tabs and workbooks
Using, analyzing, and charting 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 is proctored by the instructor and is carried out online during the last half-hour of the course. If taking place in a remote classroom, 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 to help you throughout the training.
Teaching methods
Active learning based on examples, demonstrations, experience-sharing, real cases, and an evaluation of what was learned from the training.
Course schedule
1
Get started with the work interface
The interface and how it opens the door to collaborative work (translation, sharing, etc.).
Customizing commands and the Black Office theme.
Hands-on work
Learn about and register for the AVIT® certification option. Working with and customizing your interface.
2
Designing a spreadsheet
Best practices for creating a spreadsheet.
Entering, editing, and deleting data.
Different data formats: Numbers, dates, text, etc.
Creating formulas and presenting a spreadsheet.
Layout, un-highlighting a selection, and printing.
Working with writing tools: Ink equations, etc.
Exercise
Creating spreadsheets.
3
Entering formulas
How to use parentheses.
Principles of absolute addressing and copying formulas ($).
Using common functions (SUM, NB, CONCAT, IF, etc.).
Calculating percentages.
Hands-on work
Using calculation tools.
4
Managing tabs and workbooks
Inserting, copying, moving, renaming sheets.
Setting up link formulas between sheets.
Exchanging information with Word or PowerPoint.
Working collaboratively.
Editing a workbook via a browser.
Sharing links, files, websites, and workbooks.
Working in the Cloud: The limits of Excel Online.
Hands-on work
Working with multiple tabs and workbooks.
5
Creating a data table
Creating and formatting a data table.
Managing large tables.
Sorting, filtering, and deleting duplicate entries.
Data validation.
Conditional formating.
Hands-on work
Organizing data.
6
Using and analyzing data
Quickly creating a pivot table with the Quick Analysis button.
Principle of data analysis.
Creating, updating, and formatting a pivot table.
Choosing subjects to analyze and values to summarize.
Hands-on work
Practicing pivot tables.
7
Charting data
Creating charts: Curve, pie, sparkline, 2D maps, funnel, etc.
Selecting a chart based on what data you want to portray.
Customizing your charts: Colors, scale, etc.
Using SmartArts and timelines.
Spicing up your presentations (SVG, shapes, 3D models) and using drawing tools.
Online option: Schedule and take the AVIT® exam within 4 weeks.
Hands-on work
Creating charts.
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
No session at the moment, we invite you to consult the schedule of distance classes.
3d
- 21h00 
Download in PDF format
Share this course by email