Pick your format
Video Conference eLearning
- Starting at $ 197 / participant for module 1.
- 4 module for every level of knowledge.
- All classes are on Zoom
Attend a Class
- Bring your laptop or notebook and join a group in person.
- Select a time and location that is convenient to you.
- Guidance from the teacher as well as from others attending the class.
Team Masterclass
- Learn with your business team.
- In-person classes.
- Minimum of 6 persons.
WhoIs this program for?
- Anyone who wants to improve their efficiency with Excel.
- Anyone who aspires to become a more advanced Excel user.
- Users who do data entry.
- Users who need to modify existing documents.
Program overview
Module 1
Fundamentals Of excel
Learn to become familiar with Excel interface and master the basic tools. Become efficient and comfortable solving frequent problems or issues.
- Understand data entry in Excel
- Be comfortable with the interface’s display and dashboards
- Save documents in different formats
- Use the different items in the ribbon
- Learn to make basic formulas
- Learn how to use simple tools like sorting, filters, etc.
Module 2
excel’s essentials
Master certain concepts and analyzing tools like pivot tables and dynamic charts which will be essential throughout your use of the application.
- Master advanced filters
- Learn to use dynamic pivot tables
- Create simple charts
- Use SOMME.ENS() and SI() fonctions
- Use conditional formatting to better visualize your data
Module 3
Intermediate level
Learn references more in depth and use fonctions that enables you to solve more complex problems. You’ll gain a better understanding of the links, the account manager and Solver tool.
- Master structured references functions
- Create more complex and reusable models
- Learn more advanced functions like INDEX()
- Link Excel to PowerPoint
- Develop creative thinking to solve problems
Module 4
Advanced level
Discover new tools that will allow you to work rapidly even with a really high amount of data. You’ll manipulate matrix formulas and learn de basics of VBA programming.
- Bring your use of pivot tables to another level with Power Pivot
- Learn a new language of formulas (DAX) to manage high data volume
- Link and consolidate information from multiple sources in tables
- Do magic by combining different functions with your knowledge of matrix calculation
- Become comfortable using the developer tab as well as the VBA interface
Click here to download full course outline
DOWNLOAD PDFbenefits of this training program
- Facilitated decision-making
- Good asset for business
- Improved skills
- High level of accuracy
- Increased productivity
Program rollout
| Level | Module | Subject | Duration | Format |
|---|---|---|---|---|
| Beginner | Module 1 | Fundamentals Of excel | 5 x 2 hours |  |
| Module 2 | excel’s essentials | 5 hours |  |
|
| Intermediate | Module 3 | Intermediate level |
5 x 2 hours
5 hours
|
|
| Advanced | Module 4 | Advanced level |
5 x 2 hours
8 hours
|
|
Learn to improve your efficiency and level of comfort in Excel so you become a Pro at data management!
Get started nowWhat our clients have to say
“This program is by far the best I have seen in the industry to date. I highly recommend it.”
“With our personalized formations and blended learning journeys, we’re able to deliver reports of impact within a week!”
“Thanks to Francois, I learned to synchronize my tools to work together, saving me tons of time daily.”
Program coaches
Geoffroy Chapleau
Excel training expert since 2013 and business process improvement consultant, Geoffroy owns a degree in HR and accounting. His diverse backgrounds make it easy for him to connect with students and his expertise leads them to achieve impressive results.
Satisfactionguarantee
Our training programs are 100% guaranteed
Your satisfaction is our priority!
We take necessary actions to ensure you’re satisfied with our programs. If your training doesn’t meet your expectations, we could offer a credit for another training program or even a refund.