Spreadsheets and Practical Data Handling

Introduction

Spreadsheets are often the first tool analysts use because they make data visible and let you calculate, filter, compare, and summarise information quickly. They are useful for learning analytical thinking, checking a small dataset, and preparing a clear report.

In this module, you will work with spreadsheet structure, formulas, conditional logic, lookups, sorting and filtering, pivot tables, and common data-cleaning tasks. The examples use familiar sales and customer data, but the same techniques apply to many business problems.

What you will learn in this module

• How to organise data in rows and columns
• How to use common formulas and conditional calculations
• How to sort, filter, and validate records
• How lookup formulas connect related tables
• How pivot tables summarise data and support quick analysis