Synopsis:
This two-part series provides a practical introduction to Microsoft Excel's formula and function capabilities, equipping learners with the skills to perform calculations, analyse data, and generate meaningful insights. Participants will learn how to apply commonly used spreadsheet functions as well as statistical techniques to improve data management and decision-making.
1. Spreadsheet Functions in MS Excel
Learn how to create formulas and use commonly applied Excel functions, including logical tests and lookup functions, to automate calculations and improve spreadsheet efficiency.
2. Statistical Functions in MS Excel
Learn how to apply statistical functions and techniques in Excel to summarise, analyse, and interpret data for business and reporting purposes.
This course is delivered through videos, hands-on activities and supplementary reading materials, providing a practical and flexible learning experience.
Intended For:
Competency Mapping:
