📚 Content

This module develops hands-on data handling and analysis skills using spreadsheet tools:

1. Data Sourcing, Cleaning and Preparation

  • Source and import data from multiple formats

  • Refine and clean datasets

  • Identify and correct data quality issues

  • Apply data wrangling techniques (e.g., parsing, formatting, text mining)

  • Perform descriptive, diagnostic, and predictive analysis

2. Data Analysis & Visualisation Using Spreadsheets

  • Create and format spreadsheet reports

  • Use tables to organise and summarise data

  • Apply sorting, filtering, and validation techniques

  • Build charts and visual representations of data

3. Advanced Spreadsheet Techniques

  • Create Pivot Tables and Pivot Charts

  • Analyse and interpret aggregated data

  • Build dashboards for data storytelling

  • Identify trends, patterns, and anomalies

4. Data Integration & Management

  • Import data from CSV files and external sources

  • Connect spreadsheets to databases (e.g., SQL Server)

  • Transform and structure imported data

  • Create relationships between datasets

5. Data Modelling & Reporting

  • Design queries and analyse datasets

  • Automate data collection processes

  • Generate reports and communicate findings

  • Use advanced functions (e.g., DAX where applicable)

6. Data Visualisation with Tools

  • Use charts, pivot visuals, and dashboards

  • Apply data slicing and filtering techniques

  • Present insights clearly for decision-making

🎯 Outcome

By completing this module, learners will be able to transform raw data into meaningful insights using spreadsheets, create professional reports and dashboards, and support data-driven decision-making processes.

PreviousNext