Call us today: 0800 028 3045

Microsoft Excel – Mastering Formulas and Functions Course

Is it right for me?

Our Excel Mastering Formulas and Functions course shows you how to construct basic formulas and functions in Excel.

It is aimed at existing Excel users who can create and amend spreadsheets but find formulas frustrating.

What will I get out of it?

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

  • Create different types of formula
  • Use absolute references in formulas
  • Use a range of Excel functions
  • Use the auditing tools to see how formulas are constructed

Versions available

2003, 2007, 2010

Related courses in our range

What does it cover?

Creating formulas

  • Basic formulas
  • Formula syntax
  • Operators and brackets
  • Ordering calculations

Using basic functions

  • The function wizard
  • Copying formulas
  • Autocalculate

Using maths functions

  • SUM
  • PRODUCT

Absolute vs relative references in formulas

  • Editing formulas
  • Using absolute references in formulas
  • Using partial absolute referencing

Working with percentages

  • Creating formulas with percentages
  • Formatting as a percentage

Formula auditing

  • Using the auditing facility
  • Tracing how formulas are made up
  • Evaluating formulas

Statistical functions

  • MAX and MIN
  • AVERAGE, MEDIAN and MODE

Range names

  • Naming ranges
  • Using range names in formulas

Using VLOOKUP

  • Constructring a simple VLOOKUP formula

Count functions

  • COUNT
  • COUNTA
  • COUNTBLANK

Date and time functions

  • Using date functions
  • Using time functions

Text functions

  • Using text functions

“I attended this course to increase my knowledge and confidence using Excel, this has been achieved. The trainer presented very well. An easy to follow course.”

Jenny Breeden, Administrator, Welland Medical

Course Summary

  • Duration: 1 day
  • Price: £185.00+VAT
  • Location: Crawley
  • Select date:

Send to a colleague

Please enter details below and click 'submit'

Tailor this course

If you are interested in this course but would like it tailored to your specific needs, contact Karen Osborn on 0800 028 3045.

Alternatively, enter your details below and one of our team will contact you.


Thales Training & Consultancy is a highly successful training services company based in Crawley. We help companies to develop advantage through learning and development. Highly trusted by leading enterprises, we deliver a full range of dedicated training solutions that enable organisations to achieve key business goals. The 4 core services we offer are Training Courses, Supply Management, Bespoke Services and Managed Services. Our successful partnerships with clients prove that the delivery and management of the right training and development can significantly enhance the pursuit of business excellence.


Thales Training & Consultancy. Registered in England and Wales. Registered Office: Sackville House, Northwood Park, Gatwick Road, Crawley, West Sussex RH10 9XN. Registered in England Number: 1597499. Thales Training serve the local area of Crawley, Gatwick, West Sussex, Surrey and Kent as well as offering training courses at locations around the UK