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

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

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

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

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

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

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.

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!

The average function gives us a number representing the central or typical value. But how does an average formula actually work?

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

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

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.