#GoogleSheetsTips
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
onecooltip.bsky.social
🤖 Let ChatGPT Fix Your Spreadsheet Headaches

📊 Spreadsheet stress? ChatGPT can now help inside Excel and Google Sheets.

#ChatGPT #Excel #GoogleSheets #Spreadsheets #ExcelTips #GoogleSheetsTips #Microsoft365 #GoogleWorkspace #DataAnalysis
#TechTips #OneCoolTip

www.onecooltip.com/2026/05/let-...
May 18, 2026 at 7:31 PM
sheetsbyolan.bsky.social
Create a Scorecard Chart in Google Sheets in 60 seconds! #scorecardchart #charts #googlesheetstips
April 18, 2025 at 11:48 AM
sheetsbyolan.bsky.social
Create a Combo Chart in Google Sheets in 60 seconds! #combochart #googlesheetstips #charts
April 17, 2025 at 11:51 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
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
tiller.com
Did you know... you can select a range in your spreadsheet

Quickly

By editing the Name Box

#spreadsheetTips #spreadsheets #GoogleSheets #Excel #MicrosoftExcel #ExcelTips #GoogleSheetsTips
May 25, 2025 at 9:51 PM
bazroberts.bsky.social
Learn how to freeze rows and columns in Google Sheets: bit.ly/BazPost95
#googlesheets #googleworkspace #googlesheetstips
image depicting a character freezing another character who represents rows and columns
November 27, 2024 at 6:11 PM
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
f9finance.bsky.social
2/ Level 1 - Automating Reports
🛠️ Example? A weekly sales report.
⠀⠀➡ Use IMPORTRANGE to pull data across sheets.
⠀⠀➡ QUERY to summarize it dynamically.
⠀⠀➡ Add a dashboard to visualize trends.
💡 Pro Tip? Schedule refreshing with an add-on!

#GoogleSheetsTips
March 29, 2025 at 10:15 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
spreadsheetshub.com
⚡ Think you know Google Sheets?
Most people only use 5% of what it can do — let’s change that.
Stop clicking around — start flying through spreadsheets like a pro 🚀

💾 Save this post for future reference
📤 Share with your team
✅ Use shortcuts = Save hours

#googlesheets #googlesheetstips #keyboard
July 22, 2025 at 10:01 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