WSQ Microsoft Excel Intermediate

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 Intermediate aims to bridge the performance gaps experienced by users who have surpassed the basics but have yet to reach an intermediate level of expertise.

What You'll Learn

This course uses a part-to-whole sequencing method to structure the five learning units, each building progressively on the knowledge acquired in the previous one. The course starts with Learning Unit 1, which introduces formulas and functions, including understanding formula errors, using logical functions to calculate with conditions, using conditional summary functions to calculate summary business statistics, and using lookup functions to search and match specific data.

Subsequent Learning Units 2 through 4 delve deeper into practical skills, concentrating on organising, managing, and protecting multiple worksheets and workbooks with large data sets. This sequential approach ensures that learners develop a solid understanding of how to effectively organise and manage worksheets and workbooks in Excel, including protecting and removing duplicate records.

In Learning Unit 5, learners apply their accumulated knowledge to create and format charts using the data they have worked with. This final unit is designed to consolidate the skills learned throughout the course, enabling learners to effectively organise, manage, and protect worksheets and workbooks with data sets, including creating and formatting charts to display the data.

Formulas and Functions

• Organise cell range using names
• Manage formula errors
• Use logical functions to calculate with conditions
• Use conditional summary functions to calculate summary business statistics
• Use lookup functions for search and match for specific data

Managing Workbooks and Protection

• Manage worksheet with large data sets
• Manage multiple worksheets and workbooks
• Apply protection to worksheets & workbooks

Working with Data Ranges

• Sort and filter data set
• Separate content into multiple sets

Working with Tables

• Create table to manage data sets and remove duplicate records

Working with Charts

• Create and format charts
• Display data using histograms

Minimum Entry Requirement

● WPLN Level 4.

● Attended our WSQ Microsoft Excel Essentials or

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