Functions | Spreadsheet Wise

Apr 26 min read

XLOOKUP Function in Google Sheets

The XLOOKUP function in Google Sheets allows you to search in any direction, return multiple results, and gracefully handle missing values.

Nov 25, 20234 min read

How to Use INDEX and MATCH for Flexible Lookups in Google Sheets

INDEX & MATCH are two separate functions in Google Sheets that, when combined, allow you to look up values both vertically and horizontally

Oct 12, 20234 min read

Analysing Percentage Changes with Google Sheets Formulas and Conditional Formatting

Visualise and interpret percentage changes from week to week or month to month in Google Sheets

Mar 26, 20234 min read

How to use the CONCATENATE Function in Google Sheets

The CONCATENATE function in Google Sheets allows you to combine two or more text strings or cells together.

Feb 7, 20233 min read

Relative and Absolute References in Google Sheets

Relative and absolute references are essential tools in Google Sheets to make your work easier and more efficient.

Jan 8, 20234 min read

Use the Sparkline function in Google Sheets to create a mini Progress Bar Chart

The Sparkline function in Google Sheets creates a miniature chart contained within a single cell. This is great for showcasing your data...

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 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

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!