Management Spreadsheets

Module Description

The Management Spreadsheets module covers the advanced skills needed to use the versatile features of spreadsheets to produce reports, provide statistical or mathematical analysis, and manage data more effectively and productively.

The benefits of data-based decision-making are widely recognised. All types of organisation need workers who are able to use spreadsheets effectively – not just for storing tabular data, but for the sophisticated way that spreadsheets can be used to validate, interpret, and present information.

As data becomes easier to source and share, inputting, extracting, and displaying data (either internally or externally) is now a common task for workers in all types of role and every sector.

TEST FORMAT

Contents & Skill Set

Formatting
Cells Worksheets
Formulas and functions
Using formulas and functions
Charts
Creating charts Formatting charts
Analysis
Using tables Sorting and filtering Scenarios
Validating and auditing
Validating Auditing
Enhancing productivity
Naming cells Paste special Linking, embedding and importing Automation
Collaborative editing
Reviewing and security

Learning outcomes

Successful candidates will be able to use enhanced spreadsheet capabilities to produce better reports with deeper data analysis. After passing this module, candidates will feel confident managing complex data with spreadsheets and collaborating with others. They will be able to:

understand advanced formatting options, including conditional formatting and customized formatting
recognize which functions to use in formulas, and troubleshoot errors
identify the correct chart to display a specific data set, and create or edit such a chart
know how to analyze, validate, audit, and protect data
understand time-saving features such as linking data, paste special, filters, and macros

RELATED EXAMS

GCL 02
OCCUPATIONAL SKILL DIPOMA TEST
Digital skills for employability and productivity.