Today you will
- look around the template gallery in Excel for the web or Google Sheets
- decide when a template is better than a blank sheet
- pick two templates for your Something Real sheet
- rebuild a small sheet
Open {{code:sm3_problem_statement}} in your {{code:sm3}} folder. You will match templates to it.
Think of something you built from scratch this year. Would a ready-made layout have helped?
A template is a ready-made spreadsheet with headings, sample data and often formulas.
The template gallery is where you find templates like budgets and trackers.
Use a template when its columns fit your problem. Start from a blank sheet when they don't.
Before you edit, click a total to check for a formula.
Example
Aoife wants to know if her candle stall breaks even at 40 candles. She picks a Budget and a Project tracker. She rejects Invoice, because she isn't billing anyone yet.
Watch your teacher first. Then open the template gallery on your own school account and look at a budget template and a tracker template.
Today you only look, so don't type anything in. Follow the steps in the box below and write down the name of each template.
Common snags
- If you can't find a Budget or Tracker template, search for words like budget, expense or planner. Then open the closest match.
- If you typed into the sample by mistake, don't worry, because it's your own copy. Rename it {{code:template_browse_only}} or delete it.
- Excel and Google Sheets give templates different names, and that's normal. Write the exact name your gallery shows.
Unlock the full learning experience
You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.
This lesson is copyright of 123Learn.ie 2017 - 2026. Unauthorised use, copying or distribution is not allowed.