WSQ Microsoft Excel Advanced

Microsoft Excel holds significant importance in the engineering service sector for several reasons, including data storage and organisation and preliminary data analysis. Excel is a versatile tool for storing and organising large engineering data sets. Its spreadsheet format allows for systematic arrangement, categorisation, and easy retrieval of information, which is crucial in managing the vast amounts of data generated in engineering projects.

In essence, Excel provides a platform for preliminary data analysis, allowing engineering teams to perform calculations quickly, create charts, and visualise trends. Not understanding the features of Excel can pose various risks, especially in a professional setting where accurate data management and analysis are crucial (Schulz, 2023).

For instance, inaccurate data entry and manipulation may lead to errors in calculations and analyses, resulting in flawed reports, financial miscalculations, and misinformed decision-making. Inefficient use of Excel can also lead to a loss of productivity. Users may spend excessive time on routine tasks that could be automated, impacting overall work efficiency.

Hence, the WSQ Microsoft Excel Advanced aims to bridge the performance gaps experienced by users who have surpassed the intermediate but have yet to reach an advanced level of expertise in using PivotTables and performing data queries across multiple sources to extract pertinent data for stakeholders and by employing relevant techniques used in statistical software.

What You'll Learn

This course uses a part-to-whole sequencing method to structure the six learning units, each building progressively on the knowledge acquired in the previous one. The course starts with Learning Unit (LU) 1, Advanced Formulas and Functions, which introduces a series of business statistical formulas and functions for summarising and analysing categorical or numerical data sets, including utilising nested conditions, lookup, text, date, and time functions.

After learning the advanced formulas and functions in LU1, the learners will apply their knowledge to use built-in data analysis tools in Excel to analyse data sets to identify trends and patterns in LU2 Managing and Analysing Data Ranges. Learning to apply built-in data analysis tools in Excel in LU2 helps the learners to organise and summarise data sets using the common types of statistical software that will be taught in LU3 Organising and Summarising Data. In LU3, learners will practice creating a scenario summary report, including consolidating data by position or category, and using formulas.

In LU4 Working with PivotTables, the learners will learn to create and format PivotTables using slicers. After that, the learners apply their accumulated knowledge to perform data queries across multiple sources to extract pertinent data for stakeholders and apply relevant techniques used in statistical software in LU5 Working with Web and External Data. Lastly, the learners will practice applying macro recording functionality to aid automation of working with data set and performing repetitive tasks in LU6 Working with Macros.

This sequential approach ensures that learners apply their skills in effectively utilising business statistical formulas and functions for summarising and analysing categorical or numerical data sets that include creating and formatting a PivotTable, working with web and external data, and macros.

Minimum Entry Requirement

● WPLN Level 5.

● Attended our WSQ Microsoft Excel Intermediate or

● Some knowledge of Microsoft Excel skills and know how to work with Microsoft Excel function.