Change Academy
Training
Training Courses Leadership and Personal Development Systems and Office Applications Project Management Public Training Programme
About Contact Insights Tools Podcast
Excel Module 4 training course hero image – Advanced Excel formulas and complex functions for analysis.

Excel Module 4 - Advanced Formulas and Functions

Learn advanced Excel formulas and functions to manage, transform and analyse data more efficiently. This hands-on Module 4 course helps you use lookup, logic and text functions confidently to save time and reduce errors.

In this course, you will learn how to:

  • Use text functions to clean and restructure data
  • Work with date, time and rounding functions for accurate calculations
  • Build IF statements, nested logic and criteria-based formulas (SUMIFS, COUNTIFS, AVERAGEIFS)
  • Cross-reference data using VLOOKUP, HLOOKUP, INDEX and MATCH
  • Handle errors and test values using IS functions and IFERROR

Who is this course for?

Experienced Excel users who already build basic formulas and now want to work confidently with advanced functions. Ideal for analysts, managers and professionals who regularly work with reports, lists and large datasets.

Enquire Now

“The course is really helpful in improving one's excel skills and the formula / functions shown are relevant to our day to day job. The session was well coordinated with good balance of hands on and demo. The trainer is very helpful and went extra mile to answer some of the trickier scenarios when most of the trainers would say will come back to you and they never come back. Kudos to Susan for being an ideal trainer.”

Vikas Singla – Senior Business Analyst, TotalEnergies

“Teaching method means its more likely I'll use skills learned. Slowly builds up difficulty with real world examples to reinforce each topic. Susan was really friendly and didn't sound patronizing when simple mistakes were made. Exercises and immediate help if required.”

Seb Davies – Senior Industry Operations Analyst, Total Energies

“I was very pleased with the Excel advanced formulas course as it went smoothly from start to finish - you are not only learning the underlying formulas and functions but also applying it with helpful exercises to solidify the concepts. I would highly recommend Irene as an instructor for her professionalism and excellent knowledge of Excel. It was a pleasure to have been taught by her and also appreciated the humour during the class to make the class lively! Overall, I could not recommend Irene and this course enough to improve your Excel skillset.”

Aaron Kharwar – Investment Associate, WTW

Frequently Asked Questions

Course Outline

Course overview

Duration: 1 day (6.5 hours)

Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data.

This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending.

Objectives 

By the end of the course you will be able to:

  • Use a range of Text functions to manage text data
  • Create and use different types of date and time functions
  • Work with rounding functions
  • Use logical statements
  • Build nested formula
  • Use SUMIF, COUNTIF and AVERAGEIF
  • Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions
  • Use IS functions and IFERROR to test cell values

Content

Working with text 
  • Splitting text into multiple cells
  • Merging data into one cell
  • Extracting data using text functions
  • Tidying data
Working with dates and times  
  • Formatting dates and times
  • Date and time functions
  • Calculating date and time differences
Using functions to round numbers up and down 
  • ROUND
  • ROUNDUP
  • ROUNDDOWN
  • CEILING
  • FLOOR
Use lookup functions 
  • Lookup functions
  • Creating a lookup table
  • Range naming
  • Using VLOOKUP
  • Using HLOOKUP
  • Using INDEX and MATCH
Working with logical statements 
  • Creating an IF statement
  • Using the AND plus OR functions
  • Nesting functions
Calculating values based on given criteria
  • SUMIF(S)
  • COUNTIF(S)
  • AVERAGEIF(S)
Using IS and IFERROR and test cell values
  • ISBLANK
  • ISNUMBER
  • ISTEXT
  • ISERROR
  • IFERROR

Get in Touch

Still have questions about this course?

Click Enquire Now and our team will share full details on content, dates, and pricing — and help you decide if it’s the right fit for you or your organisation.

Enquire Now

Related Courses

Excel Module 2 – Data Analysis and Pivot Tables

Expand your Excel knowledge and learn how to structure and analyse large data sets.

View the course outline
Excel Advanced Statistical Analysis

Use some of the hidden statistical analysis tools within Excel to build complex data models.

View the course outline
Excel Power Query and Power Pivot

Learn how to work with and connect multiple data sets to effectively analyse and report on data.

View the course outline

Additional Insights

Continue your learning with related articles, case studies, and podcast episodes that explore how these skills are applied in real-world contexts.

Explore More Training Options

Public Training Programme

Explore our current selection of public courses, available as convenient and cost-effective virtual sessions.

Engage with expert instructors and a diverse peer group in an interactive, online learning environment.

Ideal for those valuing flexibility and affordability, our public courses are ideal where you only have small numbers requiring training and offer training from the comfort of your home or office.

Check Public Dates

Full Training Catalogue

We deliver a wide range of training across Leadership, Personal Development, Project Management, and IT applications. Many organisations choose us because they can source both technical and people-focused training from one trusted provider.

Courses can be tailored to your organisation’s needs, making it easier to upskill teams consistently across different areas. Whether you want to build management capability, strengthen project delivery, or boost everyday software skills, you’ll find relevant options in our catalogue.

View our Leadership and Personal Development Course Catalogue
View our Systems and Office Applications Course Catalogue
View our Project Management Course Catalogue