Available in-person or remotely, this training enables beginners to master Excel and its essential functions. You will learn to create and edit spreadsheets, handle tables with ease, and navigate Excel effortlessly to boost your daily productivity.
Objectives
Master basic functions and tools. By the end of this training, you will be able to use Excel's essential features to structure your data.
Is it for you ?
The Beginner Excel training is intended for new users who want to learn how to use Microsoft Excel to create tables and structure a spreadsheet.
Prerequisite
This training is not suitable for users with Mac computers.
Your benefits
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.
Segment 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.
Détails + / -
Segment 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.
💡 Useful information
Our training sessions are offered in Montreal or Quebec City, in person or in virtual format. Dates and locations are provided when you select your session below. If you have any questions regarding registration, schedules, the language of instruction, or cancellation policies, please consult our FAQ .
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote