ITonlinelearning Academy

Introduction

Learning Objectives

1.1 Structuring Data Correctly

1.2 Data Types & Formatting in Spreadsheets

1.3 Protecting Data Integrity in Spreadsheets

1.4 When Spreadsheets Are the Right Tool (& When They're Not)

2.1 Text Functions for Data Cleaning

2.2 Lookup & Reference Functions

2.3 Logical & Conditional Functions

2.4 Date & Number Functions for Validation

3.1 Building a Data Profile

3.2 Pivot Tables for Data Exploration

3.3 Conditional Formatting for Visual Quality Checks

3.4 Building a Quality Dashboard in a Spreadsheet

4.1 Data Transformation & Import Preparation

4.2 Managing Shared Spreadsheets Responsibly

4.3 Importing & Exporting Data

4.4 Knowing When to Graduate Beyond Spreadsheets

5.1 Harborfield Community Trust - Beneficiary Data Workbook