Spreadsheets – here is the What, Why, When and How.
What?
A spreadsheet is a computer application for organization, analysis, and storage of data in tabular form.
Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.
Wikipedia.org
A spreadsheet should be your first choice if either you’re working with figures to work out (calculate) something, or you have a lot of information (numbers and/or text) that needs some type of analysis.
Why?
Spreadsheets have been designed to be able to handle large amounts of information, and are formatted in rows and columns.
For numbers, spreadsheets have in-built calculations (known as functions) that means you don’t have to write long or complex formulas.
In terms of mixed information (text and numbers), a spreadsheet includes a range of commands and features to sort, filter and show information visually (graphs).
This can make it easier to see patterns or answer questions based on the information.
When?
Anything involving numbers or calculations then a spreadsheet should be the first thought in terms of the type of program to use.
For large amounts of information (or data), a spreadsheet is the easiest way to work with it.
Depending on your skill and needs a database is an alternative option.
How?
As with other types programs, today the favourite spreadsheet is between Microsoft and Google.

Microsoft Excel
Google Sheets


Apple Numbers
Take a look at my Services to see how I can help.
Latest Posts
- Microsoft Loop: Stop Wondering Which Copy Is the LatestLoop components let you share one piece of content in several places, and every copy stays up to date. Change it once, and the change appears everywhere it has been pasted. That includes Teams chats or channels and Outlook emails. If you have ever worried about which version of a list is the right one,… Read more: Microsoft Loop: Stop Wondering Which Copy Is the Latest
- Can I Use Microsoft 365 Family for My Business? What to Know FirstTLDR: Can I use Microsoft 365 Family for my business? Microsoft’s consumer terms describe Family and Personal as being for personal use. The only clear commercial exception is a workplace programme most small business owners can’t join. One clause lifts the non-commercial restriction, but I found the wording unclear, so I wouldn’t rely on it.… Read more: Can I Use Microsoft 365 Family for My Business? What to Know First
- The One Simple Key That Speeds Up Microsoft LoopThe quickest way to add content to a Loop page is the forward slash key. Press it, and a menu appears listing everything you can add. These Microsoft Loop slash commands let you build a whole page from the keyboard. Once you’ve tried it, hunting for buttons feels very slow. How do you add things… Read more: The One Simple Key That Speeds Up Microsoft Loop
- Copilot Instructions in Word and Outlook: 5 Surprising ResultsDoes Customise Copilot in Word and Outlook use the instructions you set up on the web? In my test, it did seem to change what Copilot wrote. But Copilot gave me a different answer every time, so I can’t say the setting was the only reason. Think of it as a nudge, not a guarantee.… Read more: Copilot Instructions in Word and Outlook: 5 Surprising Results
- Copilot Knows Less About You Than You’d ThinkCopilot work account data is the handful of details from your Microsoft account that Copilot uses to personalise answers. It’s far less than you might expect. On the Copilot Basic licence that comes with a business plan, mine showed my office location and nothing else. The paid Premium licence adds a little more, but not… Read more: Copilot Knows Less About You Than You’d Think




