Excel Advanced Level Training Course

This Excel Advanced Level training course is aimed at experienced users who wish to harness the full power of the spreadsheet to analyse, automate and make their processing more reliable. Over two intensive and highly practical days, you will deepen your grasp of complex and nested functions, master PivotTables and discover Excel’s analysis and automation tools (Power Query, macros). You will learn to design dynamic dashboards and save considerable time on your repetitive tasks. By the end, Excel becomes a genuine decision-support and productivity tool.

Complementary courses: to go further, also discover Excel Advanced Skills Training Course, Excel Macros & VBA Training Course and Excel Data Analysis & Automation Training Course.

The sessions are guaranteed from the first registration (except in cases of force majeure).

A preliminary interview takes place between the participant and/or a company contact in order to fully take into account the participant’s profile (level, needs, professional context, challenges, etc.).

Assessment: during the course, the trainer assesses participants’ learning progress through quizzes, role-play and practical exercises. Participants receive a certificate of completion at the end of the course.

This training course is part of our Power Platform Training Courses catalogue. Explore all our Power Platform courses to automate, analyse and build your business applications without code.

By the end of the course, participants will be able to:

• build complex and nested formulas;
• use advanced lookup and conditional calculation functions;
• master PivotTables and PivotCharts;
• import and transform data with Power Query;
• automate repetitive tasks using macros;
• design dynamic, readable dashboards.

To follow this course under the best conditions, it is recommended to have completed the Excel Intermediate or Advanced Skills training course, or to have equivalent knowledge: common formulas and functions, charts, first PivotTables. Because every participant is unique, a personalised interview is held beforehand in order to adapt the pace and practical cases to your context.