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.
Duration
1 day
Schedule
9h to 16h
Regular fee
$375
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$340
Objectives of the training
By the end of this training, you will be able to create and manage spreadsheets effectively.Targeted audience
Excel users with basic knowledge who want to maximize the tool’s potential.Prerequisite
Basic Excel knowledge required.
Benefits for Participants
Discover expert tips for efficiently manipulating and analyzing your data.
Course architecture
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, you will 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
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
If you have any questions about registration, cancellation, schedules, 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
Skill development
Skill development and knowledge integration
Decision support
Basic knowledge
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 quoteDuration
1 day
Schedule
9h to 16h
Regular fee
$375
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$340
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