Excel Advanced Skills Training Course
Key information
Upcoming sessions
Would you like to schedule this training on a specific date? Contact us by email or via the contact form.
Description of the training: Excel Advanced Skills Training Course
This Microsoft Excel advanced-skills training course is aimed at users who already have the basics of the spreadsheet and want to become fully independent with its advanced features. Over two hands-on days, you will consolidate the building of complex formulas, lookup and conditional functions, then harness the full power of PivotTables to analyse large volumes of data. You will also learn to structure your workbooks cleanly, automate repetitive tasks and make your calculations reliable in order to produce clear, professional dashboards. By the end of the course, Excel becomes a genuine day-to-day analysis and decision-support tool.
Complementary courses: to go further, also discover Excel Advanced Level Training Course, Excel PivotTables Training Course and Excel Macros & VBA Training Course.
Good to know
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.
Objectives of the training: Excel Advanced Skills Training Course
By the end of the course, participants will be able to:
- build advanced formulas and functions (lookup, logical, conditional, text and date);
- name and structure data ranges to make workbooks reliable;
- create, format and use PivotTables and PivotCharts;
- consolidate data from several sheets or files;
- design readable management dashboards and indicators;
- automate recurring tasks using Excel’s built-in tools.
Prerequisites of the training: Excel Advanced Skills Training Course
To follow this course in the best conditions, it is recommended to have completed the Excel Intermediate training course or to have equivalent knowledge: entering and formatting data, basic formulas (SUM, AVERAGE), relative and absolute references, and creating simple charts. Regular use of the spreadsheet will make it easier to assimilate the advanced modules. Because every participant is unique, a personalised interview is held beforehand to adapt the pace and practical cases to your context.
Detailed programme of the training: Excel Advanced Skills Training Course
Excel refresher and best practices
- Review of how a workbook is organised: sheets, named ranges and good naming practices. Reminders on relative, absolute and mixed references. Advanced conditional formatting to highlight key information. Securing and protecting sheets and cells.
Advanced formulas and functions
- Lookup functions (XLOOKUP, VLOOKUP, INDEX/MATCH) and practical data-matching cases. Logical and conditional functions (nested IF, IFS, AND, OR). Conditional calculation functions (SUMIFS, COUNTIFS, AVERAGEIFS). Text and date functions to clean and prepare data.
PivotTables and charts
- Create a PivotTable from a database. Group, filter, sort and calculate (calculated fields and items). Use slicers and the timeline to make the analysis interactive. Build PivotCharts and choose the right visual representation.
Data consolidation and analysis
- Turn data into a structured table to make formulas reliable. Consolidate data from several sheets or files. Introduction to Power Query to import and transform external sources. Control data quality and handle duplicates.
Dashboards and automation
- Design a clear dashboard: indicators, formatting and readability. Automate repetitive tasks using built-in tools (data validation, drop-down lists, data-entry forms). Introduction to recorded macros to speed up common tasks. Distribute and share your tables securely.
The highlights of this training course
- This course: focuses on practice, with around 60% of guided exercises in Excel; lets you work on your own files for immediate application; runs in a small group of 1 to 3 participants for personalised support; is led by a certified expert trainer; and leads to a certificate of completion.
FAQ
What is Excel?
Microsoft Excel is the spreadsheet application in the Office suite: it lets you enter, organise, calculate and analyse data within worksheets. Beyond formulas, Excel offers powerful analysis tools (PivotTables, charts, conditional formatting) and automation. MFE-IT’s Excel advanced-skills course is aimed at already-initiated users who want to make the most of these advanced features.
What is a PivotTable?
A PivotTable is an Excel tool that instantly summarises and analyses large volumes of data without writing a single formula. In a few clicks, you group, filter and calculate totals, averages or percentages across several analysis dimensions. It is one of the cornerstones of the Excel advanced-skills course, along with slicers, the timeline and PivotCharts.
What is the difference between Excel and Power BI?
Excel is a versatile spreadsheet, ideal for entering, calculating and analysing data on an occasional or recurring basis. Power BI is a Business Intelligence tool dedicated to modelling and visualising data from multiple sources, with publishable interactive dashboards. The two are complementary: the skills acquired in Excel (PivotTables, Power Query) then make the move to Power BI easier.
How long is the Excel Advanced Skills training course?
The Excel advanced-skills course lasts 2 days, i.e. 14 hours. Sessions are guaranteed from the first registration and run in a small group of 1 to 3 participants. The programme can be personalised and delivered at your premises.
Is the Excel Advanced Skills training course eligible for CPF or OPCO funding?
This course is funded directly by the company and is not eligible for CPF. Depending on your situation, funding through your OPCO may be considered: please contact us to explore the funding options best suited to your project.
.elementor-accordion .elementor-tab-title .elementor-accordion-icon{margin-right:10px}.elementor-accordion .elementor-tab-title .elementor-accordion-icon + a,.elementor-accordion .elementor-tab-title .elementor-accordion-title{padding-left:4px}