Lesson Outcomes
After completing this practical lesson, learners will be able to:
- Create pivot tables using spreadsheet software
- Summarise and analyse large datasets
- Filter and group pivot table data
- Create pivot charts for visual analysis
- Edit and update pivot tables and charts
- Present analysed data professionally
Overview
Pivot tables and pivot charts are powerful spreadsheet tools used to summarise, analyse, group, and visualise large datasets efficiently. Businesses and Robotic Process Automation (RPA) environments use pivot tools to generate reports, identify patterns, and support decision-making processes.
This practical lesson introduces learners to pivot table creation, data grouping, filtering, summarisation, pivot chart generation, and editing within spreadsheet environments. Learners will complete practical activities involving sales performance and regional business data analysis.
Scenario: Regional Sales Performance Analysis
A business organisation has provided a large sales dataset containing regional sales information, product categories, monthly sales figures, and customer transactions.
Learners are required to use pivot tables and pivot charts to summarise, analyse, group, and visualise the sales data for management reporting purposes.
PA0301 — Create Pivot Tables
Tools/Resources
- PC or laptop
- Spreadsheet software
- Sales dataset
Activity Instructions
- Open the provided dataset.
- Select the required data range.
- Create a pivot table.
- Add row labels, column labels, and values.
- Generate summary calculations.
- Save the completed spreadsheet.
Expected Outcome
Pivot tables are created successfully using the provided dataset.
Evidence Required
- Screenshot of pivot table creation
- Screenshot of summarised pivot table data
- Screenshot of organised worksheet
PA0302 — Filter and Group Pivot Table Data
Tools/Resources
- Spreadsheet software
- Pivot table tools
- Dataset
Activity Instructions
- Apply filters to pivot tables.
- Group data according to categories or periods.
- Analyse grouped results.
- Verify the filtered outputs.
Expected Outcome
Pivot table data is filtered and grouped correctly.
Evidence Required
- Screenshot of filtered pivot tables
- Screenshot of grouped data
- Screenshot of analysed outputs
PA0303 — Create Pivot Charts
Tools/Resources
- Spreadsheet software
- Pivot chart tools
- Pivot table data
Activity Instructions
- Select pivot table data.
- Create pivot charts.
- Choose suitable chart types.
- Add chart titles and labels.
- Insert charts into the worksheet.
Expected Outcome
Pivot charts are created successfully from pivot table data.
Evidence Required
- Screenshot of pivot charts
- Screenshot of labelled charts
- Screenshot of worksheet containing charts
PA0304 — Edit and Update Pivot Tables and Charts
Tools/Resources
- Spreadsheet software
- Pivot tools
- Dataset updates
Activity Instructions
- Modify pivot table fields and layouts.
- Refresh pivot tables after data changes.
- Edit pivot chart formatting.
- Verify updated outputs.
Expected Outcome
Pivot tables and charts are updated and edited successfully.
Evidence Required
- Screenshot of edited pivot tables
- Screenshot of updated charts
- Screenshot of refreshed outputs
Key Notes
- Pivot tables summarise large datasets efficiently.
- Pivot charts visually represent analysed data.
- Filtering and grouping improve data analysis.
- Refreshing updates pivot tables after data changes.
- Pivot tools support business reporting and decision-making.
- Correct chart selection improves visual communication.