Dec 21, 20228 minPivot TablesHow to Create Pivot Tables in Google SheetsPivot Tables are an efficient and powerful way to analyse large amounts of data and make meaningful insights with minimal effort
Oct 3, 20225 minWebIMPORT RANGE Function in Google SheetsConnecting two Google Sheets with the IMPORTRANGE function can be hugely beneficial when you need to collate data across multiple sheets
Jul 30, 20222 minEssentialsReference Data From Another SheetDisplaying 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 minMathsMAX and MIN FunctionsAs 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, 20223 minMathsAVERAGE FunctionThe average function gives us a number representing the central or typical value. But how does an average formula actually work?
Jul 30, 20225 minMathsSUM FunctionThe most fundamental function is arguably the SUM function, we'll break this down and show you some cool shortcuts.