Learn spreadsheets and build one you use
A friend has invited you to do this with them.
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
- Excel book for beginnersAmazon a printed reference to keep beside the keyboard
- Desk calculatorAmazon for checking a spreadsheet's totals by hand
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.
| Hub | What it covers | Cost (as last listed) |
|---|---|---|
| Microsoft Excel help and learning | Getting started, formulas and functions (IF, VLOOKUP, XLOOKUP), drop-down lists, PivotTables, Copilot in Excel | Help pages open to read; Excel prices not given on the page |
| Google Sheets training and help | Quick starts, switching from Excel, formulas, charts and pivot tables, version history, printable cheat sheet | Help pages open to read; no price given on the page |
| OpenLearn (Open University), Data analysis, visualisations in Excel | 6 hours, introductory, quizzes; histograms, scatter diagrams and Excel functions; free statement of participation | Free; 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
- Choose the app you already have, Excel or Google Sheets, and work through the getting started guides on its official help hub.
- For a structured course with quizzes, sign up to OpenLearn's free Data analysis, visualisations in Excel, about six hours of study.
- Build one real spreadsheet, such as a month of spending, and add a chart or pivot table to summarise it.
Where to go
- Microsoft, Excel help and learning
- Google Workspace Learning Center, Google Sheets training and help
- OpenLearn, Data analysis, visualisations in Excel
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.
Plan this
Two ways to plan it.
Plan it yourself Free
The links you need to book it, get there, find somewhere to stay and eat, and see what else there is to do nearby. They are searches for you to run; nothing is saved.
Show the links
Plan it with dates
Pick a day, or a month, and we will set out how to get ready, step by step, with a date and a reason for each. Courses and classes have start dates and can fill up, so the plan begins with finding and booking one. Kit comes after the first session, once you know what you need.
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
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.
How to spot a scam text, email or call: the patterns that give them away
The recurring patterns in scam texts, emails and calls — urgency, secrecy, unexpected contact, unusual payment — with the specific costumes they wear, the hang-up-and-call-back rule, and exactly where to report them in the UK and US.
