Spreadsheet Wise | Tutorials

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

COUNT and COUNTA Functions

The COUNT function allows you to count a range of cells that contain numeric values. COUNTA goes one step further.

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.

Jul 30, 20222 min read

Data Limits in Google Sheets

Google Sheets does have a limitation on the number of cells per spreadsheet but does it matter?

Jul 30, 20222 min read

Deleting, Hiding & Resizing Rows and Columns

You're guaranteed to want to delete, hide and resize columns and rows, so let's see how it's done.

Jul 30, 20223 min read

Inserting new columns and rows

Adding new rows and columns is essential but there are a few ways to approach it.