Go further with Excel and gain greater efficiency and precision in managing and analyzing your data.
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.
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." Ideally, pass the short test linked at the beginning of the learning path. This training is not suitable for Mac users.
What You'll Walk Away With
Discover expert tips for efficiently manipulating and analyzing your data.
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
📌 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.
