Change Academy
Training Courses
Training Services Public Training Programme Leadership and Personal Development Systems and Office Applications Project Management
About Contact Podcast

Excel Module 4 -

Advanced Formulas and Functions

Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time.

Enquire Now

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

Testimonials

“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

“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

“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

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

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