Change Academy
Training Courses
Training Services Public Training Programme Leadership and Personal Development Systems and Office Applications Project Management
About Contact Podcast
Excel Mastering Formulas and Functions training course hero image – Build confidence using advanced Excel functions.

Excel - Mastering Formulas and Functions

Ideal for those already using Excel but who really want to get to grips with formulas and functions.

Enquire Now

Course overview

Duration: 1 day (6.5 hours)

Our Excel Mastering Formulas and Functions course looks at how to confidently use formulas and functions within Excel.

It looks at how to correctly construct formulas and explains how to build common formulas such as working with percentages.  It investigates a range of built in Excel functions and shows you how to use the formula auditing tools to help when things go wrong. 

This course is aimed at existing users of Excel who want to further their skills. Participants should be able to confidently create and amend worksheets.

Objectives 

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

  • Construct Formulas
  • Use a range of common Functions
  • Work with absolute and relative references in formulas
  • Create percentage calculations
  • Use named ranges in formulas
  • Use the XLOOKUP command
  • Create formulas with date and use date functions
  • Use formulas in conditional formatting
  • Use a range of Count functions
  • Use the formula auditing tools

Content

Formulas vs Functions

  • Constructing formulas
  • Using functions
  • Common Excel functions
  • Using the function wizard vs the formula bar
  • Formulas in tables

Absolute vs relative references in formulas

  • Using absolute references in formulas
  • Using partial absolute referencing

Range Naming

  • Naming ranges
  • Using range names in formulas
  • Single and multi-cell ranges

Working with percentages

  • Creating formulas with percentages
  • Percentage breakdowns
  • Percentage increases
  • Formatting as a percentage

Using Lookups

  • Using XLOOKUP to insert information from other spreadsheets

Calculating with dates

  • Calculating with dates
  • Using date functions

Using formulas in conditional formatting

  • Using conditional formulas
  • Using functions in conditional formatting

Count functions

  • COUNT
  • COUNTA
  • COUNTBLANK

Formula auditing

  • Using the auditing facility
  • Tracing how formulas are made up
  • Tracing precedents and dependants
  • Evaluating formulas
  • Error checking
  • Showing formulas on a sheet

Testimonials

"Yes. The course had very useful content and was delivered at a good pace. Susan really knows her stuff and is very engaging. Her tone, cadence and language is really clear. She encourages questions and at no point do you feel out of your depth or unsupported. The conditional formatting with formulas and XLOOKUP were especially useful."

Adam Mitchell - Scheduling Support Officer, Gatwick Airport Limited

"This was the best Excel training I have completed and Irene was a great instructor. We were able to ask questions and she run through how the tasks could be used in our day to day which I found very helpful. Breaking down of the tasks really helped my understanding on topics I have always struggled with!! Great course, great instructor and pitched at just the right level."

Alice Driscoll - National Account Manager, TotalEnergies

"100% - very useful. Carla was amazing, she helped all of us individually and didn't rush any of us. She was very thorough and always made sure we all understood before she moved on. She was very approachable and friendly and made us all feel comfortable. All of the documents provided to practise were so good and really useful. Amazing course, really thorough and has helped me massively in my day to day job."

Kirsty Redhead - Industry Operations Executive, Total Energies

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 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.

View the course outline
Excel – Working with Macros

Learn how to use Macros in Excel to automate your work and start to see the power these can give you.

View the course outline
VBA in Excel – Part 1

Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time.

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