Lesson Outcomes

After completing this practical lesson, learners will be able to:

• Create spreadsheet tables
• Summarise spreadsheet data
• Sort and filter data
• Validate spreadsheet information
• Format spreadsheet tables professionally
• Visualise summarised data

Overview

Spreadsheet tables are used to organise, summarise, analyse, and present structured data efficiently within business and Robotic Process Automation (RPA) environments. Proper formatting, filtering, sorting, and summarisation improve readability and support accurate business reporting.

This practical lesson introduces learners to spreadsheet table creation, data summarisation, sorting, filtering, validation, formatting, and visualisation using spreadsheet software tools. Learners will complete practical activities involving customer feedback and product analysis data.

Scenario: Customer Feedback Analysis

You are working as an intern at a marketing research firm.

Your supervisor has provided a dataset containing customer feedback on various products. Your task is to summarise the data and present it clearly using spreadsheet tables, calculations, filters, formatting, and charts.

PA0201 — Create Spreadsheet Tables

Tools/Resources

• PC or laptop
• Spreadsheet software
• Customer feedback dataset

Activity Instructions

1. Open the spreadsheet software.
2. Create a new worksheet.
3. Define column headings for the dataset.
4. Input or import the provided data.
5. Convert the dataset into a spreadsheet table.
6. Save the completed worksheet.

Expected Outcome

A structured spreadsheet table is created successfully.

Evidence Required

• Screenshot of spreadsheet table
• Screenshot of organised dataset
• Screenshot of worksheet structure

PA0202 — Summarise Data

Tools/Resources

• Spreadsheet software
• Dataset
• Spreadsheet functions

Activity Instructions

1. Calculate totals and averages.
2. Use spreadsheet functions such as SUM, AVERAGE, and COUNTIF.
3. Generate summary values from the dataset.
4. Verify calculation accuracy.

Expected Outcome

Spreadsheet data is summarised correctly using spreadsheet functions.

Evidence Required

• Screenshot of summary calculations
• Screenshot of spreadsheet functions
• Screenshot of summarised data

PA0203 — Sort, Filter, and Validate Data

Tools/Resources

• Spreadsheet software
• Dataset
• Filtering and validation tools

Activity Instructions

1. Sort data according to selected criteria.
2. Apply filters to display selected information.
3. Validate the dataset for consistency and accuracy.
4. Correct any identified issues.

Expected Outcome

Data is sorted, filtered, and validated successfully.

Evidence Required

• Screenshot of sorted data
• Screenshot of filtered results
• Screenshot of validated dataset

PA0204 — Format Summarised Data

Tools/Resources

• Spreadsheet software
• Formatting tools
• Chart tools

Activity Instructions

1. Apply formatting styles to the spreadsheet table.
2. Use conditional formatting where appropriate.
3. Create charts or graphs from summarised data.
4. Improve readability and visual presentation.

Expected Outcome

Summarised spreadsheet data is formatted and visualised professionally.

Evidence Required

• Screenshot of formatted spreadsheet tables
• Screenshot of conditional formatting
• Screenshot of charts or graphs

Key Notes

• Spreadsheet tables improve data organisation.
• Spreadsheet functions support data summarisation.
• Sorting and filtering improve focused analysis.
• Validation improves data accuracy.
• Formatting improves readability and presentation.
• Charts support visual analysis and reporting.