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
- Getting Your PowerPoint Designs to Actually Match
If you’ve ever used Design Ideas in PowerPoint and never ended up with a consistent PowerPoint slide design, you’re not alone. Each slide looks lovely on its own, but look at them as a complete deck and it’s like four different presentations got shuffled into one file. I was reminded of this exact problem recently,… Read more: Getting Your PowerPoint Designs to Actually Match - A Simple Framework for Better Copilot Prompts
I’ve been testing Copilot presentation prompts a lot this month, and this time I wanted to answer a simple question: does putting more thought into your prompt actually make a difference, or is it all a bit of a lottery? Starting simple I opened Copilot in PowerPoint desktop and hovered over the Copilot icon, which… Read more: A Simple Framework for Better Copilot Prompts - Moving From Corporate to Self-Employed: How to Set Up Your Tech Step by Step
TLDR: Moving from corporate to self-employed doesn’t mean starting your tech setup from scratch. It means being deliberate: keep what works, drop what doesn’t, and learn properly the bits you never had to before. Get this right early and the admin side of self-employment stops feeling like a second job. If you’re moving from corporate… Read more: Moving From Corporate to Self-Employed: How to Set Up Your Tech Step by Step - Copilot for Presentations: Same Prompt, Two Results
I’ve been having a proper play with Copilot for presentations lately, trying to work out whether it can genuinely save small business owners time when building a deck. Short answer: it depends. Longer answer: it depends on where you open it, and even then, results can shift from one day to the next. Why I… Read more: Copilot for Presentations: Same Prompt, Two Results - Word Dictation: A Faster Way to Write
If typing isn’t your favourite part of running a business, I have some good news. The Word dictation feature has been quietly getting better for years, and it’s now useful for everyday work. Instead of typing out your next email or document, you simply talk, and Word turns it into text. I’ll be honest with… Read more: Word Dictation: A Faster Way to Write