Google Sheets: FILTER, ARRAYFORMULA, UNIQUE, WEEKDAY, LEFT, MIN, MAX, IFERROR, Conditional formatting, workflow.
In this tutorial, we are going to tackle some Intermediate level Google Sheets concepts including using functions like:
- FLITER
- ARRAYFORMULA
- MIN and MAX
- IFERROR
- SPARKLINE
- UNIQUE
- WEEKDAY
- LEFT
We are then going to make our Google Sheet more presentable by doing some neat tricks with Conditional Formatting.
However, probably the most important lesson is to consider throughout the whole process is the workflow of this project. I will try and get you into my headspace and talk about:
- How I came to do things in a certain way.
- What I tested before applying to my Google Sheet.
- The order I did things to create the test.
When I am learning something, I find the most benefit in learning by following a project. As you follow along you don’t have to read everything. Actually, I encourage you to get the basic idea of the stage before giving it a try. Then come back to the tutorial for troubleshooting.