Lesson Outcomes
After completing this practical lesson, learners will be able to:
- Create spreadsheet reports
- Organise and structure spreadsheet data
- Apply spreadsheet formulas and calculations
- Filter and format spreadsheet data
- Create charts for data reporting
- Present analysed data visually
Overview
Spreadsheet software is widely used to organise, analyse, report, and visualise structured data in business and Robotic Process Automation (RPA) environments. Effective spreadsheet reporting improves data interpretation and supports business decision-making.
This practical lesson introduces learners to spreadsheet reporting, data organisation, filtering, formatting, calculations, and chart creation using spreadsheet tools. Learners will complete practical activities involving the analysis and visual presentation of sales data within a spreadsheet environment.
Scenario: Sales Data Reporting
Learners are provided with a dataset containing sales figures for different products over a period of time.
The task is to analyse the sales data and create a comprehensive spreadsheet report that identifies trends, patterns, and insights using formulas, filters, formatting, and charts.
PA0101 — Create Spreadsheet Reports
Tools/Resources
- PC or laptop
- Spreadsheet software
- Provided sales dataset
Activity Instructions
- Open a blank spreadsheet workbook.
- Import the provided dataset.
- Organise the data into suitable columns.
- Create headings and titles.
- Apply formulas to calculate totals, averages, and summaries.
- Save the completed spreadsheet report.
Expected Outcome
A structured spreadsheet report is created successfully using organised data and formulas.
Evidence Required
- Screenshot of spreadsheet report
- Screenshot of formulas used
- Screenshot of organised dataset
PA0102 — Filter and Format Data
Tools/Resources
- Spreadsheet software
- Imported dataset
- Formatting tools
Activity Instructions
- Apply filters to the dataset.
- Filter data according to selected criteria.
- Apply formatting styles to improve readability.
- Use conditional formatting where appropriate.
- Verify formatting consistency.
Expected Outcome
Spreadsheet data is filtered and formatted correctly.
Evidence Required
- Screenshot of filtered data
- Screenshot of formatted spreadsheet
- Screenshot of conditional formatting
PA0103 — Create Charts
Tools/Resources
- Spreadsheet software
- Dataset and summaries
- Chart tools
Activity Instructions
- Select suitable data for visualisation.
- Create charts such as bar charts, line charts, or pie charts.
- Label chart titles and axes appropriately.
- Insert charts into the spreadsheet report.
- Verify chart accuracy.
Expected Outcome
Charts are created successfully to visualise analysed data.
Evidence Required
- Screenshot of created charts
- Screenshot of labelled charts
- Screenshot of completed report with charts
Key Notes
- Spreadsheet reports improve data analysis and presentation.
- Organised data improves reporting accuracy.
- Filters assist with focused analysis.
- Formatting improves readability.
- Charts visually represent trends and patterns.
- Formula calculations support data summarisation.