Want to go beyond the basics of Excel? This training is designed for those who want to unlock the full potential of this tool. Learn how to efficiently manipulate your data, perform precise analyses, and boost your productivity.
Microsoft Excel (MS365) is a powerful data management tool, but its full potential is often underutilized because it can be challenging to master!
This training covers:
Mathematical Language: Master calculations to automate your spreadsheets.
Organization & Visualization: Create dropdown lists, reorganize columns, and use conditional formatting for clear and impactful data.
Advanced Analysis: Get introduced to pivot tables and discover analytical tools to make the most of your data.
Maintenance & Customization: Adapt your models and maintain your workbooks for optimal use.
Objectives
By the end of this training, you will be able to create and manage spreadsheets effectively.
Is it for you ?
Excel users with basic knowledge who want to maximize the tool’s potential.
Prerequisite
Possess basic knowledge or have completed the CH270 training "Excel for Beginners: Mastering the Software." Ideally, pass the short test linked at the beginning of the learning path. This training is not suitable for Mac users.
Your benefits
Discover expert tips for efficiently manipulating and analyzing your data.
Content
Not sure if this training course is right for your level? We offer a short test to assess your knowledge and needs.
By clicking on this link download an Excel file with a few scenarios .
If you encounter difficulties, we recommend that you take the training course Excel: Mastering the Tool .
Understanding Excel’s Mathematical Language
- Creating simple formulas
Creating Dropdown Lists
- Using the Data Validation tool
- Naming cell ranges
Details + / -
Creating Organized Tables
- Structuring data columns in tables
- Adding calculations to tables
- Using calculation functions
Presenting Tables Effectively
- Using conditional formatting
- Maintaining data in a workbook
- Modifying source table data
- Using Excel’s analytical tools
Data Analysis
- Using pivot tables
- Modifying and formatting pivot tables
Creating and Using Templates
💡 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