Excel Formulae & Functions

This course will provide a thorough grounding in the use of calculations in Excel. In order to do this effectively, delegates will learn the fundamentals of calculations: creating simple formulae & the use of Excel’s in-built function formulae. This will lead onto the use of statistical and date functions and ultimately the use of logical “IF” statements that deal with multiple answers within formulae.


Calculations will be used in single worksheets, across multiple worksheets (3-d) and ultimately across multiple workbooks.

The delegate will also gain a greater understanding of how spreadsheets can and are being used in businesses today.

One Day Course

Course Outline (PDF)

Course Objectives:

•Focus on the calculation (formulae & function) capabilities of Excel.
• Speed up your productivity and become familiar with the Excel function library.
• Using named ranges to make it easier to refer to cell references.
• Follow calculations others have created and subsequently track and resolve errors.
• Introducing conditional statements in formulae.

Excel Green Logo Microsoft. Green book with white x in centre
Price: £175 + vat

Dates

  • Tuesday 23rd September 2025
  • Tuesday 21st October 2025
  • Friday 21st November 2025
  • Thursday 11th December 2025
  • Thursday 22nd January 2026
  • Tuesday 24th February 2026
  • Wednesday 25th March 2026
  • Wednesday 15th April 2026
  • Thursday 21st May 2026
  • Thursday 18th June 2026
  • Tuesday 21st July 2026
  • Thursday 20th August 2026
  • Tuesday 22nd September 2026
  • Wednesday 14th October 2026
  • Thursday 19th November 2026
  • Monday 14th December 2026