Microsoft Excel: Formulae & Functions (1 Day)

Product Description

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 & date functions & 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) & ultimately across multiple workbooks. The delegate will also gain a greater understanding of how spreadsheets can & are being used in businesses today.

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

This training may be available onsite; please contact us if you are interested.