#googlesheetstutorial
LightNews LightNews
easysheets.bsky.social
Tutorial: Turn dates into days automatically in Google Sheets

youtube.com/shorts/dZ8eG...

#googlesheets #spreadsheets #tutorial #googlesheetstutorial #googlesheetstips
How to Turn Dates into Days Automatically #googlesheetstutorial #googlesheets #googlesheetstips
YouTube video by easysheets
youtube.com
April 21, 2026 at 12:53 PM
easysheets.bsky.social
Tired of manually sorting tables in Google Sheets?

You can auto-sort your data so it stays organized instantly 👇

No more dragging or re-sorting every time you update your sheet.

#googlesheets #spreadsheet #tutorial #googlesheetstutorial

Full quick tutorial:
youtube.com/shorts/01-43...
How to Auto Sort a Table in Google Sheets #googlesheets #googlesheetstutorial #googlesheetstips
YouTube video by easysheets
youtube.com
April 23, 2026 at 11:58 AM
spencerssheets.bsky.social
youtube.com/shorts/vfdoJ...

Generate Column Letters
-

Use ARRAYFORMULA(REGEXREPLACE(ADDRESS(SEQUENCE())) to generate sequential letters with a formula

Music courtesy of CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Generate Column Letters With a Formula
YouTube video by Spencer Teaches Sheets
youtube.com
May 10, 2025 at 5:41 AM
spencerssheets.bsky.social
youtu.be/xBO_Z5IXSCc

Google Sheets Troubleshooting: Extend Existing DATEDIF() Formula Down a Column

Music courtesy of CORTEXX
open.spotify.com/artist/4fOVG...

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets Troubleshooting: Extend Existing DATEDIF() Formula Down a Column
YouTube video by Spencer Teaches Sheets
youtu.be
September 3, 2025 at 6:11 AM
spencerssheets.bsky.social
Make formulas more visually appealing and easier to read. Ctrl+Enter for a line break and multiple spaces to indent can help tremendously!

Music courtesy of CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
April 12, 2025 at 7:15 AM
spencerssheets.bsky.social
youtube.com/shorts/IQVds...

SEQUENCE() is such a simple function, yet can do so much. Here are some basics

Music courtesy of CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
SEQUENCE() Basics
YouTube video by Spencer Teaches Sheets
youtube.com
March 16, 2025 at 4:49 AM
spencerssheets.bsky.social
youtube.com/shorts/VcvJv...

You can easily return multiple columns using the XLOOKUP() function

Music courtesy of CORTEXX
open.spotify.com/artist/4fOVG...

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars
Return multiple columns with XLOOKUP()
YouTube video by Spencer Teaches Sheets
youtube.com
January 27, 2025 at 7:30 PM
spencerssheets.bsky.social
youtube.com/shorts/TLRJX...

Use the ARRAY_CONSTRAIN() function to prevent a formula from spilling further than intended

Music courtesy of CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars
ARRAY_CONSTRAIN() Function
YouTube video by Spencer Teaches Sheets
youtube.com
April 23, 2025 at 5:44 AM
spencerssheets.bsky.social
youtube.com/shorts/i9BrV...

Multiple Criteria in XLOOKUP()
-----

To use multiple criteria in XLOOKUP(), construct the search_key and lookup_range

Music courtesy of CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Multiple Criteria in XLOOKUP()
YouTube video by Spencer Teaches Sheets
youtube.com
May 7, 2025 at 3:42 AM
easysheets.bsky.social
Stop tracking expenses manually.

Track spending by category automatically using SUMIF 👇

Category:
=unique(filter(B6:B12, B6:B12<>""))

Amount:
=SUMIF($B$6:$B$12,B15,$C$6:$C$12) No more manual totals.

Full quick tutorial 👇
youtube.com/shorts/pj9rD...
How to use SUMIF #googlesheetstutorial #googlesheets #sumif #googlesheetstips
YouTube video by easysheets
youtube.com
April 19, 2026 at 5:58 PM
spencerssheets.bsky.social
youtube.com/shorts/lt506...

With the SPLIT() function simply give it text and what to use as separator and you can split single-cell text into multiple cells.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars
Google Sheets Basics: SPLIT() function
YouTube video by Spencer Teaches Sheets
youtube.com
August 20, 2025 at 4:45 AM
spencerssheets.bsky.social
youtube.com/shorts/nQqO7...

While there is a technical definition for a number being Even, Sheets provides the easy functions ISEVEN() and ISODD().

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Check if a Number is Even or Odd
YouTube video by Spencer Teaches Sheets
youtube.com
August 5, 2025 at 6:45 AM
spencerssheets.bsky.social
youtube.com/shorts/0hvr5...

Covert ranges to tables to make data easier to look at and gain other productivity benefits

Music courtesy of CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars
Convert Range to Table
YouTube video by Spencer Teaches Sheets
youtube.com
February 28, 2025 at 8:40 AM
spencerssheets.bsky.social
youtube.com/shorts/sLT1q...

Using alternating colors can make large data sets easier to look at and work with

Music courtesy of CORTEXX
open.spotify.com/artist/4fOVG...

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars
Alternating Colors / Color Banding
YouTube video by Spencer Teaches Sheets
youtube.com
February 27, 2025 at 7:44 AM
spencerssheets.bsky.social
youtube.com/shorts/lUr3p...

CHAR() returns a character from a number. CHAR(10) gives a newline, so JOIN(CHAR(10)) joins text with newlines between.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars
Google Sheets: Join Text with Newlines
YouTube video by Spencer Teaches Sheets
youtube.com
May 29, 2025 at 5:44 AM
spencerssheets.bsky.social
youtube.com/shorts/A_-ZZ...

MODE() returns the MCV from a list of numbers but not text. One way to get the MCV from text is INDEX(SORT(COUNTIF()))

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars
Most Common Value
YouTube video by Spencer Teaches Sheets
youtube.com
May 2, 2025 at 5:31 AM
spencerssheets.bsky.social
youtube.com/shorts/5kJ-h...

Return 1 row per unique ID (the Rep in this case), the count of each, and the sum of service amounts, all in a single QUERY formula.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: COUNT and SUM in QUERY
YouTube video by Spencer Teaches Sheets
youtube.com
July 13, 2025 at 6:11 AM
spencerssheets.bsky.social
youtube.com/shorts/6FTpd...

Use $ to lock row and/or column references so they don't adjust when a formula is copied or dragged

Music courtesy of CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars
Google Sheets Basics: Absolute vs Relative Range References
YouTube video by Spencer Teaches Sheets
youtube.com
March 26, 2025 at 4:33 AM
spencerssheets.bsky.social
youtube.com/shorts/7M-2r...

MODE() returns the MCV (most common value) from a list of numbers, but not text. One way to get the text MCV is FILTER(COUNTIF())

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars
Most Common Value in Text List - FILTER() Function
YouTube video by Spencer Teaches Sheets
youtube.com
May 3, 2025 at 6:09 AM
spencerssheets.bsky.social
youtube.com/shorts/gFQck...

Columns are vertical by letters
Rows are horizontal by number
Reference cells by Column letter then Row number like A1

Music courtesy of CORTEXX
open.spotify.com/artist/4fOVG...

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars
Google Sheets Basics: Rows, Columns, Cell References
YouTube video by Spencer Teaches Sheets
youtube.com
February 23, 2025 at 6:23 AM
spencerssheets.bsky.social
The Freeze submenu in the View menu has an option to freeze up to the current Row or Column to keep everything until then visible as you scroll around a sheet.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars
August 21, 2025 at 11:48 PM
spencerssheets.bsky.social
The Freeze submenu in the View menu has default options to freeze 1 or 2 rows and columns, making it very easy to keep a row or a column visible as you scroll around.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
August 21, 2025 at 11:46 PM
spencerssheets.bsky.social
youtube.com/shorts/wYz_n...

Data / Cleanup / Remove Duplicates can be used as a trick to remove blanks from a column, so long as there is no actual data repeated

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Remove Blanks with the DATA menu
YouTube video by Spencer Teaches Sheets
youtube.com
August 19, 2025 at 4:52 AM
spencerssheets.bsky.social
youtube.com/shorts/PrEzl...

Allow user input without seeing the formulas using 3 files: An input, formulas, and middle with IMPORTRANGE between them

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Hide Formulas with IMPORTRANGE
YouTube video by Spencer Teaches Sheets
youtube.com
August 13, 2025 at 5:06 PM
spencerssheets.bsky.social
youtube.com/shorts/PsK4B...

When you copy and paste a cell over a range each cell gets the exact value. To increment the value on each cell simply drag the fill handle!

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Automatically Increment using Fill Handle
YouTube video by Spencer Teaches Sheets
youtube.com
August 7, 2025 at 10:14 PM