Objectives of the training
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.Targeted audience
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
None
Benefits for Participants
- Gain a better understanding of the tool;
- Use essential keyboard shortcuts to save time;
- Create professional and dynamic tables;
- Design clear charts to illustrate your results.
Course architecture
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.
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.
If you have any questions regarding registration, cancellations, schedules, the language of instruction, etc., you will find answers in our FAQ.
Pedagogical details
Training architecture
Learning by doing, feedback, group discussions and practical exercises.
Type of training
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 quotePrivate 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