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

  • Wednesday 22nd May 2024
  • Tuesday 18th June 2024
  • Tuesday 16th July 2024
  • Monday 19th August 2024
  • Thursday 19th September 2024
  • Tuesday 22nd October 2024
  • Friday 22nd November 2024
  • Thursday 12th December 2024
Back to all Courses