Conditional formatting is something I only got into recently. I love when my spreadsheets do all kinds of things automatically, especially giving me statistics and pulling certain data from a big sheet. So naturally, because I also like my spreadsheets to look nice, I looked into conditional formatting. The basic usage is pretty simple, but if you want to take it a step further, you need some formulas, so I thought I’ll share how it’s done. Read More
This one is going to be all about the QUERY function. I love using this one. You can do a lot of exciting things with it. Make sure to also read Part 1 and Part 2 to get to know the setup as well as some other functions and neat examples.
QUERY is an awesome function because you can basically use your spreadsheet as a database and query it which means you have a lot of possibilities. In some cases it is also a lot easier to use than doing the same thing by using other functions. Read More
Make sure to read Part 1 of the tutorial, as it explains the setup I work with (my GR shelves) that helps you to better understand what I’m doing!
The first tutorial was more of an introduction of the basic functions that you need/use all the time. Now I’m going a bit further and explain some of the more complicated ones that can come in quite handy and even more important: how to get some neat results by combining them. Read More
If you love statistics/numbers about books as much as I do, then you’re going to love this one.
The list of functions that I regularly use and want to show you is quite long, so this tutorial is split into 3 parts.
I thought it would be especially fun if I chose an example everyone can do themselves. That’s why I am going to use my GR shelf as example data. Read More