Excel Advanced Formulas & Calculations 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 Formulas & Calculations Training Course
This Excel Advanced Formulas & Calculations training course is dedicated to users who want to truly master the calculation power of the spreadsheet. Over two highly practical days, you will learn to build robust, readable formulas, combine logical, lookup and conditional functions, and use text, date and statistical functions. You will also discover array formulas and advanced calculation techniques to make your analyses more reliable. By the end, you will be able to design reliable workbooks, automate your calculations and avoid the most common errors.
Complementary courses: to go further, also discover Excel Advanced Skills Training Course, Excel PivotTables Training Course and Excel Advanced Level 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 Formulas & Calculations Training Course
By the end of the course, participants will be able to:
- master relative, absolute and mixed references and the naming of ranges;
- combine logical and conditional functions (IF, IFS, AND, OR);
- use lookup functions (XLOOKUP, VLOOKUP, INDEX/MATCH);
- use text, date and statistical functions;
- build array formulas and advanced calculations;
- make formulas more reliable and handle errors.
Prerequisites of the training: Excel Advanced Formulas & Calculations Training Course
To follow this course under the best conditions, it is recommended to have completed the Excel Intermediate training course or to have equivalent knowledge: basic formulas, references, formatting. Because every participant is unique, a personalised interview is held beforehand in order to adapt the pace and practical cases to your context.
Detailed programme of the training: Excel Advanced Formulas & Calculations Training Course
References and range naming
- Relative, absolute and mixed references. Naming ranges and cells for readable formulas. Best practices for organising a workbook. Auditing and tracing formulas.
Logical and conditional functions
- IF, nested IF and IFS functions. Logical operators AND, OR, NOT. Conditional calculation: SUMIFS, COUNTIFS, AVERAGEIFS. Handling errors with IFERROR.
Lookup and reference functions
- Modern lookup functions (XLOOKUP) and classic ones (VLOOKUP, INDEX/MATCH). Multi-criteria lookups. Combining lookup functions with other calculations.
Text, date and statistical functions
- Text functions (LEFT, RIGHT, MID, CONCAT, SUBSTITUTE). Date and time functions (DATEDIF, NETWORKDAYS). Useful statistical functions (RANK, MEDIAN, STDEV, counting functions).
Array formulas and advanced calculations
- Understand and write array formulas. Dynamic array functions. Advanced multi-condition calculations. Optimise the performance of large workbooks.
The highlights of this training course
- This course: focuses on practice with around 60% of hands-on exercises in Excel; lets you work on your own files; takes place in a small group of 1 to 3 participants; is led by an expert trainer; leads to a certificate of completion.
FAQ
Who is the Excel Advanced Formulas & Calculations training course for?
It is aimed at users who already know the basics of Excel and want to master formulas in depth: logical, lookup, conditional, text, date and statistical functions, and array formulas. It is the ideal course for making calculations more reliable and faster.
What is the difference between VLOOKUP and XLOOKUP?
VLOOKUP searches for a value in the first column of a table and returns a value from a column to its right. XLOOKUP, more recent and more flexible, searches in any column, in both directions, and handles errors and approximate matches. The course covers both, as well as INDEX/MATCH.
What is an array formula?
An array formula performs several calculations on one or more ranges of values and can return one or several results. Combined with Excel’s dynamic array functions, it enables powerful calculations in a single formula. It is covered through hands-on practice in the course.
How long does the Excel Advanced Formulas & Calculations training course last?
The course lasts 2 days, i.e. 14 hours. Sessions are guaranteed from the first registration and take place in a small group of 1 to 3 participants. The programme can be customised and organised at your premises.
Is this 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 by your OPCO may be considered: contact us to explore the funding options 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}