Archive for the ‘Tutorial’ Category
Google spreadsheets has 2 build-in random-number functions. Rand() and Randbetween().
Most of the time, I use randbetween(), because it offers a quick and easy way to insert some random numbers. However, this function only insert rounded numbers.
If you want to insert random numbers with decimals, you can use Rand(). I will explain both functions here.
Let’s say we have 2 tables that we want to combine:
In both tables, we have Personal nr. and we want to add the data from the second table to the data from the first table.
For this we will use VLOOKUP.
Progress bar
In these posts, I’ll show you how to build a really basic planning tool in Google Docs.
This tutorial is meant to get you started with using more advanced features of Google spreadsheets. Though it will not touch any of the real complicated stuff.
Let’s get started. Read more