Google Sheets Course

Lesson 1 • Creating and Managing Spreadsheet Files

Teaches file creation, renaming, copying, and deletion within Google Drive. Connects file management habits to organised, professional workflows.

Lesson 2 • Navigating the Google Sheets Interface

Covers the toolbar, menu bar, sheet tabs, and cell grid layout. Establishes spatial awareness needed for all subsequent tasks.

Lesson 3 • Basic Cell Selection and Range Operations

Covers selecting single cells, ranges, rows, and columns efficiently. Range selection underpins formatting, formulas, and data manipulation.

Lesson 4 • Entering and Editing Cell Data

Introduces text, number, and date entry along with basic editing techniques. Accurate data entry is the prerequisite for all formula and analysis work.

Lesson 1 • Managing Rows, Columns, and Sheets

Covers inserting, deleting, resizing, hiding, and freezing rows and columns. Structural control is essential for building scalable, navigable spreadsheets.

Lesson 2 • Conditional Formatting Fundamentals

Applies rule-based formatting to highlight values, duplicates, and trends. Conditional formatting transforms static data into visually actionable information.

Lesson 3 • Borders, Colours, and Cell Styles

Introduces border styles, fill colours, and alternating row themes. Visual structure guides the reader's eye and separates data sections clearly.

Lesson 4 • Cell Alignment and Text Wrapping

Teaches horizontal and vertical alignment, text wrap, and merge options. Alignment choices directly affect readability in reports and dashboards.

Lesson 1 • Date and Time Functions

Covers TODAY, NOW, DATEDIF, EDATE, and date arithmetic for time-based analysis. Date functions power deadline tracking, scheduling, and age calculations.

Lesson 2 • Text Functions for Data Cleaning

Introduces CONCATENATE, LEFT, RIGHT, MID, TRIM, and UPPER/LOWER for text manipulation. Text functions are critical for standardising imported or inconsistent data.

Lesson 3 • Essential Math and Statistical Functions

Covers SUM, AVERAGE, MIN, MAX, COUNT, and COUNTA for everyday calculations. These functions form the backbone of nearly every analytical spreadsheet.

Lesson 4 • Logical Functions for Decision Making

Teaches IF, AND, OR, and nested logic to automate conditional outputs. Logical functions enable spreadsheets to respond dynamically to changing data.

Lesson 1 • XLOOKUP for Modern Data Retrieval

Covers XLOOKUP as the modern replacement for VLOOKUP and HLOOKUP. Its flexible syntax reduces formula complexity and handles missing values natively.

Lesson 2 • HLOOKUP and Horizontal Lookups

Extends lookup skills to horizontally structured tables using HLOOKUP. Understanding both orientations prepares students for diverse real-world data layouts.

Lesson 3 • INDEX and MATCH for Flexible Lookups

Introduces INDEX and MATCH as a powerful alternative to VLOOKUP. This combination handles left-side lookups and dynamic column references.

Lesson 4 • Cross-Sheet and Cross-File References

Teaches referencing data from other sheets and imported external files. Cross-sheet references enable modular, multi-tab reporting architectures.

Lesson 1 • Filtering Data with AutoFilter

Teaches applying, customising, and clearing AutoFilter to isolate relevant records. Filtering is the fastest way to focus analysis on a specific data subset.

Lesson 2 • Removing Duplicates and Cleaning Data

Covers built-in duplicate removal, UNIQUE function, and data cleanup techniques. Clean data is the prerequisite for trustworthy analysis and reporting.

Lesson 3 • Using Filter Views for Collaboration

Introduces Filter Views that let each user apply personal filters without affecting others. This feature is essential for shared spreadsheets in team environments.

Lesson 4 • Data Validation for Input Control

Applies validation rules to restrict cell inputs to lists, numbers, or date ranges. Validation prevents data entry errors before they corrupt downstream analysis.

Lesson 1 • Sparklines for In-Cell Trends

Introduces sparklines as compact, in-cell trend indicators for row-level data. Sparklines add analytical depth to summary tables without requiring separate charts.

Lesson 2 • Customising Chart Appearance

Covers titles, legends, axis labels, colours, and gridline settings. Visual customisation ensures charts align with brand standards and audience expectations.

Lesson 3 • Choosing the Right Chart Type

Explains when to use bar, line, pie, scatter, and combo charts. Matching chart type to data structure is the foundation of effective visual communication.

Lesson 4 • Sharing and Exporting Visualisations

Teaches publishing charts, embedding them in documents, and exporting as images. Sharing skills ensure visualisations reach stakeholders in the right format.

Lesson 1 • QUERY Function for SQL-Style Analysis

Uses the QUERY function to filter, sort, and aggregate data with SQL-like syntax. QUERY replaces multiple nested formulas with a single, readable expression.

Lesson 2 • Calculated Fields and Custom Summaries

Introduces calculated fields to derive new metrics directly inside a PivotTable. Custom calculations extend PivotTable analysis beyond standard aggregation.

Lesson 3 • Building PivotTables from Scratch

Covers inserting a PivotTable, selecting source data, and configuring rows and values. PivotTables are the fastest tool for summarising thousands of records.

Lesson 4 • SUMIF, COUNTIF, and Conditional Aggregation

Applies SUMIF, COUNTIF, AVERAGEIF, and their multi-criteria variants to aggregate selectively. Conditional aggregation answers targeted business questions from large datasets.

Lesson 1 • Recording and Running Macros

Teaches recording, saving, and executing macros to automate repetitive formatting and data tasks. Macros reduce manual effort and ensure process consistency across runs.

Lesson 2 • Protecting Sheets and Ranges

Covers sheet protection, range-level permissions, and editor restrictions. Protection prevents accidental or unauthorised changes in shared workbooks.

Lesson 3 • Collaboration Tools and Comments

Teaches real-time co-editing, comments, suggestions, and notification settings. Effective collaboration features reduce version conflicts and communication delays.

Lesson 4 • Introduction to Google Apps Script

Introduces the Apps Script editor, basic JavaScript syntax, and simple automation scripts. Apps Script unlocks custom functions and workflow automation beyond built-in tools.