Things to do · Tech

Learn spreadsheets and build one you use

A spreadsheet you build yourself can total a budget, compare quotes or summarise a year of records, and the skills carry between Excel and Google Sheets. Microsoft and Google each run help hubs for their own app, and the Open University's OpenLearn has a free six-hour course on summarising data with charts in Excel.

GentleFreeA few weeksIndoorsOn your own

Christmas present ideas for someone who wants to learn spreadsheets and build one you use

Presents that help someone get started, drawn from this page. They are ideas, not recommendations: we have not tested any of the products, so check sizes and details before you buy.

Kit to give

Or give your company

Some of the best presents cost little: offer to go along the first time. Print a promise card to put under the tree.

Some of these are affiliate links: if you buy or book through them we may earn a commission at no extra cost to you. Amazon links are searches, so compare what comes up.

More Christmas gift ideas for people who love doing things Stocking fillers

Where to learn

Microsoft's Excel help and learning hub is a set of linked guides rather than a single course. It groups them under getting started, collaborating, formulas and functions, importing and analysing, formatting and troubleshooting, with guides to the IF, VLOOKUP and XLOOKUP functions, drop-down lists, freezing panes and PivotTables, and to Copilot in Excel.

Google's Sheets training sits in the Google Workspace Learning Center. It has quick start guides to getting started and to switching from Microsoft Excel, a printable cheat sheet, and guides to analysing data with charts, pivot tables and formulas, and to tracking changes and going back to earlier versions. Sheets runs on the web, Android and iOS.

For a structured course, OpenLearn's Data analysis, visualisations in Excel is six hours of study at introductory level. It covers frequency tables, histograms, contingency tables and scatter diagrams, and using Excel functions to solve problems. You need Excel or a similar program. You can start without signing in, but you need a free account to track progress and earn the free statement of participation.

HubWhat it coversCost (as last listed)
Microsoft Excel help and learningGetting started, formulas and functions (IF, VLOOKUP, XLOOKUP), drop-down lists, PivotTables, Copilot in ExcelHelp pages open to read; Excel prices not given on the page
Google Sheets training and helpQuick starts, switching from Excel, formulas, charts and pivot tables, version history, printable cheat sheetHelp pages open to read; no price given on the page
OpenLearn (Open University), Data analysis, visualisations in Excel6 hours, introductory, quizzes; histograms, scatter diagrams and Excel functions; free statement of participationFree; needs Excel or a similar program

What you can do afterwards

  • Keep a running budget with totals, which pairs well with tracking a month of spending.
  • Use IF to flag rows, and XLOOKUP or VLOOKUP to pull a figure from another table.
  • Summarise a long list in a pivot table, or turn it into a histogram or scatter chart as the OpenLearn course shows.
  • Share a sheet with family or a club, follow who changed what, and go back to an earlier version in Google Sheets.

How to start

  1. Choose the app you already have, Excel or Google Sheets, and work through the getting started guides on its official help hub.
  2. For a structured course with quizzes, sign up to OpenLearn's free Data analysis, visualisations in Excel, about six hours of study.
  3. Build one real spreadsheet, such as a month of spending, and add a chart or pivot table to summarise it.

Where to go

We opened these links on 20 November 2026 and found them to be what we say. Dates, places and prices are on the official page, where they stay up to date.

Questions people ask

Is there free Excel training from Microsoft?

Microsoft's Excel help and learning hub has guides from getting started to functions and PivotTables. It is a collection of help pages rather than a structured course.

Is there a free structured spreadsheet course?

OpenLearn's Data analysis, visualisations in Excel is free, takes about six hours at introductory level, and gives a free statement of participation if you sign up and complete it.

Is Google Sheets hard to learn if I know Excel?

Google's Sheets training includes a quick start guide written for people switching from Microsoft Excel.

What is a pivot table?

A tool for summarising a large table, such as totals by month or category. Both Microsoft and Google cover pivot tables in their help hubs.

Where this comes from: Microsoft Support, Excel help and learning; Google Workspace Learning Center, Google Sheets training and help; OpenLearn, Data analysis, visualisations in Excel. Opened 20 November 2026.

Read next

Tech

Cath Bowie logs on from Aberdeen, and 24,000 people come to watch her play Fortnite

Cath Bowie, 78, from Aberdeen, began playing Fortnite after watching her teenage grandson, then started broadcasting her games live on Twitch when he told her nobody would watch. She now has more than 24,000 followers and a Guinness World Records title. Her story, what the research says about games and memory, and how to start playing or streaming safely.

5 October 2026, 3 min read, with a film

More like this

← All activities

The Second Start — our free email list

Our email is starting soon: one real story and one thing to try. Join now to get the first one. Free: the 7-Day Restart Plan (PDF) when you join.

Make this site yours

Three quick questions and we'll show you what fits: no beginner tips if you're already fit, no marathons if you're just starting. It stays in this browser, and you can change it any time.

How active are you at the moment?
Your age (optional)
What interests you? (pick any)