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

  • Friday 22nd November 2024
  • Thursday 12th December 2024
  • Thursday 23rd January 2025
  • Thursday 20th February 2025
  • Thursday 20th March 2025
  • Wednesday 16th April 2025
  • Tuesday 20th May 2025
  • Tuesday 24th June 2025
  • Thursday 24th July 2025
  • Tuesday 19th August 2025
  • Tuesday 23rd September 2025
  • Tuesday 21st October 2025
  • Friday 21st November 2025
  • Thursday 11th December 2025
Back to all Courses