Formulae and Calculations - SS09

General Description

To get the most out of your spreadsheets, creating the appropriate functions is essential. Engage financial, statistical, date/time, logical and look-up functions to build powerful and dynamic spreadsheets.

Target Audience

This session is intended for participants with knowledge of, and skills in the fundamental use of Microsoft Excel, who require high level skills in writing, auditing and correcting formulae.

Pre-requisites

Participants should be competent in the learning outcomes of sessions SS01, SS02 and SS03.

Duration

3 hours

Learning Outcomes

• Use the ROUND, ROUNDUP and ROUNDDOWN functions
• Discuss how rounding functions work
• Use the AVERAGE, STANDARD DEVIATION, MODE and MEDIAN functions
• Use a selection of the financial functions
• Use the AND, OR and NOT functions
• Use the IF function
• Create nested IF functions
• Set up data to use lookup functions
• Name ranges of cells
• Use the CHOOSE, VLOOKUP, HLOOKUP and ISERROR functions
• Nest functions together to solve complex problems