Essentials

Sep 33 min read

Adjusting Date Formats in Google Sheets: A Simple Guide

Date formats in Google Sheets can vary significantly based on geographic location. We'll explore two simple methods to adjust date formats.

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.

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

Jul 30, 20222 min read

Creating a Basic Table

We'll look at the alignment of text and numbers as well as some basic formatting tips.

Jul 30, 20222 min read

Working with Cells in Google Sheets

Now that we know where everything is, it’s time to start adding something to the canvas, AKA, the cells.

Jul 30, 20225 min read

Exploring Sheets

We’re going to look at the options at the bottom of a spreadsheet where you can see names like Sheet1 and Sheet2