Spreadsheet Wise | Tutorials

Dec 21, 20228 min read

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

Oct 23, 20227 min read

How To Apply Conditional Formatting Across An Entire Row In Google Sheets

Conditional formatting in Google Sheets can be a great time saver to highlight cells or text based on conditional logic automatically.

Oct 3, 20225 min read

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

Sep 8, 20226 min read

IF Function and Multiple IF Statements in Google Sheets

The IF function in Google Sheets is the next logical step up from the basic functions such as the SUM or AVERAGE functions.

Aug 18, 20224 min read

How to Create a Drop-down list in Google Sheets

Creating a drop-down list in Google Sheets is super easy to make with Data Validation and even easier to use. Find out how.

Aug 15, 20223 min read

How to Bulk Translate with Google Sheets

With Google Translate, you can translate anything, but did you know that you you can also achieve this using a Google Sheets Function?

Aug 13, 20225 min read

INDEX Function in Google Sheets

The INDEX function in Google Sheets, when used in conjunction with other functions can easily compete and excel compared to VLOOKUP.

Aug 10, 20224 min read

Create a Progress Bar in Google Sheets

Visualising your progress can be a real motivator to getting stuff done. Sparklines and repeat functions can help with that.

Jul 30, 20224 min read

VLOOKUP Function in Google Sheets

The VLOOKUP is one of those well-known functions everyone’s heard of, yet it’s still somewhat of an enigma.

Jul 30, 20222 min read

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.