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
- Do you want computer peripherals with that?You’ve sorted out the hardware, the best device and software but have you thought about any additional computer equipment that you might need for your business a.k.a. the computer peripherals? The first thing is to agree on what is a ‘computer peripheral’. The definition that appears when you google it, is: A peripheral device, or… Read more: Do you want computer peripherals with that?
- Improve your results with these advanced search techniquesWe’ve now looked at searching, and hopefully you’re finding your files easily. But how often are the ones that you’re looking for at the top of the results list? Let me share some advanced search techniques with you. Wildcard symbols How often have you remembered part of the filename, but not all of it? There… Read more: Improve your results with these advanced search techniques
- Are you searching your files to save time?How often have you spent hours looking for a file that you know is saved somewhere? Then my question is why? Searching your files is a quicker way to find what you’re looking for! OK, OK, I can hear you saying “I already know how to search Michelle!” But do you? Really? I’m talking about… Read more: Are you searching your files to save time?
- Talking without the video = podcastMaybe you’ve got a lot to say (not just supercalifragilisticexpialidocious) but you don’t like seeing or recording yourself. In this case take a look at the podcast option. Sure you’re recording your voice but that’s it! What’s a podcast? Well a dictionary definition is “a digital audio file made available on the internet for downloading… Read more: Talking without the video = podcast
- Is a video channel more your thing?Maybe your expertise is better shared through a video channel? If your skills are best when you show or demonstrate things to people then this may be the perfect channel option for you. I’m not going to insult you by explaining what a video is, but let’s talk about a few things related to a… Read more: Is a video channel more your thing?