Google Sheets | Spreadsheet Wise 3/4

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.

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!

Jul 30, 20223 min read

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, 20225 min read

SUM Function

The most fundamental function is arguably the SUM function, we'll break this down and show you some cool shortcuts.

Jul 30, 20224 min read

Find and Replace

Spreadsheets can search too, plus some other bells and whistles. This can be a real time saver, so it's worth checking out.

Jul 30, 20223 min read

Publish to the Web

It's possible to publish your entire spreadsheet or even a chart within a sheet as a static web page. We'll check out all options here.

Jul 30, 20224 min read

Notes and Comments

Sometimes it’s helpful to add notes or comments to your work to help remind you about certain things, we'll explore both here.