Learn the basics of Microsoft Excel (MS365) to boost your productivity and collaborate effectively.
Microsoft Excel is the most widely used software in businesses across all industries. Yet the vast majority of users only utilize a tiny fraction of its capabilities and waste valuable time performing repetitive tasks or figuring out how to format their data.
Do you sometimes feel overwhelmed by grids, cells, and error messages?
This introductory course is specifically designed to demystify the spreadsheet. Step by step, you’ll learn how to navigate the interface, create professional-looking spreadsheets, and automate basic calculations—turning this intimidating tool into an indispensable ally in your daily work.
Is it for you ?
This training is intended for anyone (support staff, administrative assistants, managers, professionals) who is new to Microsoft Excel or who has learned the program “on the job” and wishes to acquire a solid foundation and effective work methods.
Prerequisites
This training is not suitable for users with Mac computers.
What You'll Walk Away With
- ✓ Get started right away: Be able to create a functional spreadsheet as soon as you return to the office.
- ✓ Eliminate errors: No more manual calculations with a calculator—let Excel do the work (and without errors!).
- ✓ Save time: Discover tips and shortcuts for entering data quickly without having to retype everything.
- ✓ Professional presentation: Learn how to format your cells so your documents are clear and easy for your colleagues to read.
Training content
During this program, you will cover the basics of Excel and familiarize yourself with its environment, interface, and essential tools. You will learn to efficiently handle, organize, and analyze data while discovering key features to optimize your use of the software.
1 Environment and Data Manipulation
- Navigating Excel with ease: exploring the interface and customizing the ribbon.
- Entering and manipulating data: quick selections, the fill handle, and keyboard shortcuts.
- Spreadsheet management: techniques for creating and modifying sheets in a structured way.
- Auto-fill lists and the golden rules for flawless tables.
2 Using Mathematical Language
- Using basic functions: learn to create arithmetic formulas (addition, subtraction, multiplication) and use essential functions such as SUM, AVERAGE, and percentage calculations.
- Logic and automation: introduction to the IF function to automate your data analysis.
- Managing references: understanding the use of dollar signs ($) and absolute references to copy your formulas without errors.
- Data analysis: introduction to pivot tables to summarize your information in just a few clicks.
- Conditional formatting: learn to automatically highlight your cells based on your results (e.g., highlighting negative numbers in red).
- Charts and visualization: creating histograms and pie charts to turn your figures into clear decisions.
📌 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.
