Google Sheets: Analysing Information – Basic formulas for everyday tasks
Formulas enable us quickly perform actions on data inside our sheets. They are the building blocks towards automating repetitive tasks in a Sheet.
Use these basic functions to build your first formulas and get an introduction to this powerful set of features inside Google Sheets and apply these skills to speed up decision making.
|Totalling up a series of values|
|Creating your first formula|
|Using the SUM function|
|Using the COUNT function|
|Scenarios for using COUNT|
|Complete the quiz|
This video is 4 minutes 20 seconds long:
Examples where you might use these functions could include:
- Quickly adding up values, e.g. money received.
- Totalling up the number of RSVPs to an event.
- Counting the number of orders received.