Microsoft Excel serves as a gateway to various data technologies and platforms widely utilised in the ICT sector, including databases, business intelligence tools, and data visualisation software.

Excel mastery-level allows professionals to seamlessly integrate Excel with these technologies, facilitating smooth data exchange, analysis, and reporting across multiple systems. This integration enhances collaboration, interoperability, and overall efficiency within ICT teams and across departments.

Excel mastery-level proficiency is crucial for ICT sector employees to maintain competitiveness, efficiency, and effectiveness in their roles.

The WSQ Microsoft Excel Mastery course aims to equip professionals with expertise in performing sophisticated data analysis using advanced formulas, functions, and visualization techniques. This proficiency enables them to identify patterns, trends, and anomalies more effectively, thereby supporting informed decision-making and problem-solving.

2 Days

16 Hours

Probability and Statistics

- Starting with the fundamentals of probability and statistics provides a solid foundation for understanding data analysis. It includes the basics of probability, how to calculate probability, and the concepts of probability distribution, which are crucial for analysing data variability and making predictions. This knowledge is essential for effectively utilising advanced statistical functions and tools in Learning Units 2 and 3.

Advanced Statistical Functions

- Building on the foundational knowledge, this unit focuses on using advanced statistical functions to identify value deviation, determine the degree of variation, compute quartiles, and analyse correlations between variables. Additionally, learners will learn to identify ranked high and low values, enhancing their ability to perform sophisticated data analysis in Excel.

Advanced Statistical Tools

- This unit provides practical learning to learners to perform natural language queries on data for intuitive analysis, conduct ANOVA (Analysis of Variance) to compare datasets, and calculate moving averages to identify trends. It also covers rank and percentile calculations to determine data positions and sampling techniques for accurate data representation.

Managing PivotTable Reports

- This unit dives deeper into leveraging PivotTables for robust data analysis and reporting. The learners will learn to create integrated reports using data models, generate multiple reports from a single dataset, and drill down into details for deeper insights. It also covers applying built-in analysis calculations and working with custom-calculated fields to tailor reports to specific needs.

Array and Summary Functions

- Leveraging the knowledge acquired from previous learning units, the learners will learn array functions and spill ranges, change data layouts using TRANSPOSE, and sort data dynamically with SORT and SORTBY. They will also learn to extract unique values with UNIQUE, perform data lookups using XMATCH and XLOOKUP, and compute summary values with AGGREGATE and SUMPRODUCT.

Upon successful completion of the WSQ Microsoft Excel Mastery assessment, participants who have attended at least 75% of the course will receive a SkillsFuture WSQ Statement of Attainment (SOA) along with a Certificate of Attendance by @ASK Training.