Main learning outcomes

Successful candidates will be proficient using the advanced features of spreadsheet tools for the analysis of financial data. After passing this module, candidates will feel confident using spreadsheets to carry out logical, statistical, financial, and mathematical operations. They will be able to:

• understand functions such as those associated with logical, statistical, financial, and mathematical operations
• use tables and lists to analyze, filter, sort, validate, and audit data, as well as create and use scenarios
• apply advanced formatting options such as conditional formatting, customized number formatting, and chart formatting
• use linking, embedding and importing features as well as comparing and merging spreadsheets
• Understand the productivity and security features of spreadsheet tools.

Contact us