YOUR AD GOES HERE

Google Sheets for Beginners: Learn Data Analysis Step by Step

Published 29, Oct 2026

The Data Signal


Description:
New to Google Sheets or data analysis? Follow along as we turn a small list of orders into an analysis you can explain.

We start with a £30 mistake: one order counted twice. Then we clean the data, calculate revenue, compare regions and build a chart, with each step shown on screen.

You'll learn how to navigate Sheets, import a CSV, use tables and filter views, write formulas, match lists with XLOOKUP, and build pivot tables. We also cover conditional formatting, sharing permissions, version history and exporting your work.

DOWNLOAD THE PRACTICE FILES AND FORMULAS
https://github.com/david-ikenna-ezekiel/thedatasignal/tree/main/google-sheets-data-analysis

Start with data/orders.csv and follow along. The folder includes the product lookup list, copyable formulas, expected results and a completed reference so you can check your work. The orders are fictional practice data.

CHAPTERS
00:00 The £30 mistake
00:48 Start with your data
01:59 Find your way around
03:22 Clean the data
04:48 Organise it as a table
05:37 Sort and filter
06:33 Make your first calculation
08:36 Answer a question with SUMIFS
09:31 Match lists with XLOOKUP
11:03 Build a pivot table
12:58 Charts and conditional formatting
14:26 Share and recover your work
15:53 Save and export your work
16:12 Your turn to analyse

YOUR TURN
Add another order, fill in its Revenue and Category formulas, and check that your pivot total matches your formula total. Then group by product and write one sentence explaining what you found.

Subscribe to The Data Signal for more practical walkthroughs on data analysis and data tools.

#GoogleSheets #DataAnalysis #GoogleSheetsTutorial

Releted More Videos

You May Also Like

YOUR AD GOES HERE

YOUR AD GOES HERE