Excel Module 4 – Advanced Formulas and Functions

Duration: 1 day

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.

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
  • Splitting text into multiple cells
  • Merging data into one cell
  • Extracting data using text functions
  • Tidying data
  • Formatting dates and times
  • Date and time functions
  • Calculating date and time differences
  • ROUND
  • ROUNDUP
  • ROUNDDOWN
  • CEILING
  • FLOOR
  • Lookup functions
  • Creating a lookup table
  • Range naming
  • Using VLOOKUP
  • Using HLOOKUP
  • Using INDEX and MATCH
  • Creating an IF statement
  • Using the AND plus OR functions
  • Nesting functions
  • SUMIF(S)
  • COUNTIF(S)
  • AVERAGEIF(S)
  • ISBLANK
  • ISNUMBER
  • ISTEXT
  • ISERROR
  • IFERROR

I would definitely recommend the course. I found VLOOKUP, MATCH, INDEX, COUNTIF and SUMIFS most useful and I think the course is perfect.

Jing, Mizuho Bank

I most enjoyed MATCH, INDEX and Text functions. Thank you for the course which was very helpful. I was able to achieve my objective.

Reiko, Mizuho Bank

I enjoyed formulas, COUNTIFS and SUMIFS

Jaya , Mizuho Bank

Excellent course and trainer. I would recommend the course, good content and trainer.

Martyn, Welland Medical

I would recommend the course, the trainer has a lot of knowledge and takes time to explain tasks. Very good course, tougher than Module 2. I found it really useful being able to keep the books after along with the worksheets we had been using on the day. Very quick to register for the course and very good facilities.

Richard, Welland Medical

The course showcased the ease and efficiency of using Visio. Venue was lovely

Natasha, Willis Towers Watson

Yes, I would recommend the course, Lisa was very clear in her explanations and very easy to talk to. The examples were easy to follow in order to understand how each function worked. Everything was done in a step by step process, so it was easy to follow and understand

John, Willis Towers Watson

I would recommend the course, theory taught in an intuitive way with good examples to back it up. Really enjoyed the session. It was taught very well and followed on from where Excel 2 left off. The shortcuts and examples were very good.

Daniel, Willis Towers Watson

I would recommend the course, I found it very informative and easy to follow. Really great, it was my second course that I attended. Friendly atmosphere and lots of help provided. I like how Susan shows us how to do a task and then when we do the practical its based on different figures and scenarios so you learn better as your not just copying what Susan did blindly.

Sasha, Total Gas and Power

Excellent course and trainer, I would recommend the course as Lisa always adds beyond the course, by teaching you many shortcuts which will save so much time at work!

Catherine, Willis Towers Watson

I would recommend the course, really useful build on existing Excel knowledge. Susan adapts what she is showing to apply to your work. What I found most useful was All the ‘IFs’ and dates and times and building on dates and times knowledge e.g. networking days

Heather, St Catherine's Hospice

Excellent course and trainer, most defiantly would recommend to my colleagues. Material was well presented, venue and course are great

Ekaterina, Total Gas and Power

I found the course to be very educational without being an overload of information. I think the ratio of people training to trainer to be very good as this meant Susan could offer support to everyone in the room. The written material provided was well present and is a fab idea to be able to have as a take home. I think it was good that the group was given material to work through to keep it interactive. I found it good that this material was different to what was being shown by Susan.

Rebecca, Willis Towers Watson

I would recommend it as I gained a new understanding of the INDEX and MATCH functions that I wasn’t able to grasp, beforehand. Susan was an effective trainer who allowed plenty of time for any questions to be asked and answered and provided sufficient help during the practical exercises.

Daniel, Civil Aviation Authority


Back to all courses