Go further with Excel and gain greater efficiency and precision in managing and analyzing your data.
Microsoft Excel is the most widely used software in business, across all sectors. Yet, the vast majority of users leverage only a tiny fraction of its capabilities, wasting precious time performing repetitive tasks or trying to figure out how to format their data. Do you sometimes feel overwhelmed by grids, cells, and error messages? This introductory training is specifically designed to demystify the spreadsheet. Step by step, you will learn how to navigate the interface, build professional tables, and automate your basic calculations, ultimately transforming this intimidating tool into an indispensable ally in your daily work.
Is it for you ?
Excel users with basic knowledge who want to maximize the tool’s potential.
Prerequisites
Possess basic knowledge or have completed the CH270 training "Excel for Beginners: Mastering the Software." deally, pass the short test linked at the end of the syllabus under the "To-do" section.
This training is not suitable for Mac users.
What You'll Walk Away With
- ✓ Immediate autonomy: Be capable of creating a functional spreadsheet as soon as you get back to the office.
- ✓ Error elimination: No more manual calculations with a calculator; let Excel do the work (error-free!).
- ✓ Time savings: Discover tips and shortcuts to enter data quickly without having to retype everything.
- ✓ Professional look: Learn how to format your cells so your documents are clear and easy for your colleagues to read.
Training content
Not sure if this training course is right for your level? We offer a short test to assess your knowledge and needs.
1 Understanding Excel’s Mathematical Language
- Creating simple formulas
2 Creating Dropdown Lists
- Using the Data Validation tool
- Naming cell ranges
3 Creating Organized Tables
- Structuring data columns in tables
- Adding calculations to tables
- Using calculation functions
4 Presenting Tables Effectively
- Using conditional formatting
- Maintaining data in a workbook
- Modifying source table data
- Using Excel’s analytical tools
5 Data Analysis
- Using pivot tables
- Modifying and formatting pivot tables
6 Creating and Using Templates
To do
Not sure if this training is suited to your level? Validate your skills: Take the test
📌 Practical information
Our training sessions are offered in Montreal or Quebec City, in person or in a virtual classroom. Dates and locations are specified when you select your session below. If you have any questions, check out our FAQ.
