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.