top of page


How to Create Pivot Tables in Google Sheets
Pivot Tables are an efficient and powerful way to analyse large amounts of data and make meaningful insights with minimal effort
Dec 21, 20228 min read
362
0


IMPORT RANGE Function in Google Sheets
Connecting two Google Sheets with the IMPORTRANGE function can be hugely beneficial when you need to collate data across multiple sheets
Oct 3, 20225 min read
2,289
0

Reference Data From Another Sheet
Displaying a result from a function on another sheet within a spreadsheet is not as bad as you might think. We'll unwrap this process here.
Jul 30, 20222 min read
93
0

MAX and MIN Functions
As the name suggests, MAX and MIN functions will find the maximum and minimum values in a numerical dataset, but they can do so much more!
Jul 30, 20222 min read
63
0

AVERAGE Function
The average function gives us a number representing the central or typical value. But how does an average formula actually work?
Jul 30, 20223 min read
63
0

SUM Function
The most fundamental function is arguably the SUM function, we'll break this down and show you some cool shortcuts.
Jul 30, 20225 min read
32
0
bottom of page