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
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.
3d
- 21h00 
Download in PDF format
Share this course by email