top of page
Sep 3, 20243 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.
960
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.
2,3120
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.
890
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.
180
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.
890
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.
3440
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?
500
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.
260
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.
140
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.
170
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.
260
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
150
bottom of page