#GoogleSheetsTips

@arminham.bsky.social

5 months ago

How AIUploader Converts Simple CSV Data Into Profitable Apps Credit to: arminhamidian The AI Uploader is a cutting-edge program that aims to streamline and transform the process of developing business commercial apps. Customers use AI Uploader to convert sim…

How AIUploader Converts Simple CSV Data Into Profitable Apps – Online Marketing Scoops onlinemarketingscoops.com/2025/07/12/a...

#GoogleSheets #googlesheetstips #googlesheet #AItools #AITools2025 #aitoolsforbusiness #GPT4o #GPT #GPTrading

1 0 0 0

@spencerssheets.bsky.social

6 months ago

Google Sheets Troubleshooting: Extend Existing DATEDIF() Formula Down a Column YouTube video by Spencer Teaches Sheets

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

1 0 0 0

@spencerssheets.bsky.social

6 months ago

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

0 0 0 0

@spencerssheets.bsky.social

6 months ago

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

0 0 0 0

Sebas

@sebas-ggarcia.bsky.social

6 months ago

La función QUERY: 1. Sintaxis y uso básico Aprende la sintaxis y uso básico de la función QUERY en Google Sheets. Filtra, selecciona y organiza datos fácilmente con ejemplos prácticos.

Template con ejercicios básicos de la función QUERY para Google Sheets.
Practica tus habilidades con esta poderosa función.

qubyts.sebasgarcia.net/posts/la-fun...

#GoogleSheets #googlesheets #googlesheetstips #GoogleSheetsTemplate #hojadecálculodegoogle #hojadecalculodegoogle #spreadsheet

0 0 1 0

@spencerssheets.bsky.social

6 months ago

Google Sheets Basics: SPLIT() function YouTube video by Spencer Teaches Sheets

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

1 0 0 0

@spencerssheets.bsky.social

6 months ago

Google Sheets: Remove Blanks with the DATA menu YouTube video by Spencer Teaches Sheets

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

0 0 0 0

@spencerssheets.bsky.social

7 months ago

Google Sheets: Hide Formulas with IMPORTRANGE YouTube video by Spencer Teaches Sheets

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

0 0 0 0

@spencerssheets.bsky.social

7 months ago

Google Sheets: Automatically Increment using Fill Handle YouTube video by Spencer Teaches Sheets

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

0 0 0 0

@spencerssheets.bsky.social

7 months ago

Google Sheets: Choose a Value based on Count YouTube video by Spencer Teaches Sheets

youtube.com/shorts/NXiql...

Use COUNTA() as the input to the CHOOSE() index to easily return a value based on how many items are in a range.

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

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide

0 0 0 0

@spencerssheets.bsky.social

7 months ago

Google Sheets: Check if a Number is Even or Odd YouTube video by Spencer Teaches Sheets

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

1 0 0 0

@spencerssheets.bsky.social

7 months ago

Google Sheets: Override Formula Output with Manual Data YouTube video by Spencer Teaches Sheets

youtube.com/shorts/24YKk...

With a column of data generated by a formula where some of the data is incorrect, outdated, or just wrong use a helper column to override

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide

0 0 0 0

@spencerssheets.bsky.social

7 months ago

Google Sheets: Highlight Rows with No Checked Boxes YouTube video by Spencer Teaches Sheets

youtube.com/shorts/YWeGS...

To highlight entire rows without checked boxes, join all the values in the row and check for the value TRUE in the joined value

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide

0 0 0 0

@spencerssheets.bsky.social

7 months ago

Google Sheets: Multiply Checkboxes by a Value Row-by-Row YouTube video by Spencer Teaches Sheets

youtube.com/shorts/BTVau...

Sometimes it makes sense to multiply all checkboxes in a row by a value. Do this with the BYROW() function surrounding COUNTIF()*val

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide

0 0 0 0

@spencerssheets.bsky.social

7 months ago

Google Sheets: Multidimensional Sort YouTube video by Spencer Teaches Sheets

youtube.com/shorts/wABxs...

You can easily sort a range on 2 columns at once by using the Advanced Sorting Options from the Data menu

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide

0 0 0 0

SpreadsheetsHub

@spreadsheetshub.com

7 months ago

⚡ 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

1 0 0 0

@spencerssheets.bsky.social

7 months ago

Google Sheets: Use the Filter Tool to Sort YouTube video by Spencer Teaches Sheets

youtube.com/shorts/ynGR4...

The Filter Tool on the Toolbar allows you to sort a range by a single column, either ascending or descending.

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

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide

0 0 0 0

@spencerssheets.bsky.social

7 months ago

Google Sheets: Use ARRAYFORMULA to Perform a Simple Calculation Down a Column YouTube video by Spencer Teaches Sheets

youtube.com/shorts/Snipy...

Simple calculations like [range]*-1 can simply be done down a column using the ARRAYFORMULA() function around the calculation.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide

0 0 0 0

@spencerssheets.bsky.social

8 months ago

Google Sheets: COUNT and SUM in QUERY YouTube video by Spencer Teaches Sheets

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

1 0 0 0

@spencerssheets.bsky.social

8 months ago

Google Sheets: Use HSTACK to Fill 2 Columns at Once from Different Formulas YouTube video by Spencer Teaches Sheets

youtube.com/shorts/x8C2l...

HSTACK appends ranges together so MAP(LAMBDA(HSTACK(COUNTIF(),SUMIF()))) outputs 2 columns of formula output from a single formula!

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide

0 0 0 0

@spencerssheets.bsky.social

8 months ago

Google Sheets Basics: Automatically Recognizing Contiguous Data YouTube video by Spencer Teaches Sheets

youtube.com/shorts/UGTay...

Sheets automatically recognizes contiguous data for things such as new formulas and Alternating Colors

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide

0 0 0 0

@spencerssheets.bsky.social

8 months ago

Google Sheets: Use =IF(ISBLANK()) to Test if a Cell Contains Data YouTube video by Spencer Teaches Sheets

youtube.com/shorts/sXd47...

Use ISBLANK() in an IF() function to check if a cell is blank and value_if_false to do whatever you want to do if the cell isn't blank.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide

0 0 0 0

@spencerssheets.bsky.social

8 months ago

Google Sheets: Use =IF(LEN()) to test if a cell contains data YouTube video by Spencer Teaches Sheets

youtube.com/shorts/kOL5x...

=IF() evaluates 0 as FALSE and all other numbers as TRUE, so we can use the number returned from LEN() to do T/F if a cell contains data.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide

0 0 0 0

@spencerssheets.bsky.social

8 months ago

Google Sheets: Only Allow Unique Numbers YouTube video by Spencer Teaches Sheets

youtube.com/shorts/S27y3...

Create a Data Validation rule with a custom =COUNTIF() formula to only allow each number to be used once in a range

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars

0 0 0 0

@spencerssheets.bsky.social

8 months ago

Google Sheets: Return Everything Before a Character YouTube video by Spencer Teaches Sheets

youtube.com/shorts/_cZf1...

=LEFT(A1,FIND(":",A1)-1) returns everything before a given character. This works for any character and SEARCH() as well as FIND().

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars

0 1 0 0

@spencerssheets.bsky.social

8 months ago

Google Sheets: Remove Everything Before a Character YouTube video by Spencer Teaches Sheets

youtube.com/shorts/1bbk5...

Use the construction =RIGHT(A1,LEN(A1)-FIND(":",A1)) to remove everything up to and including a particular character.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars

0 0 0 0

@spencerssheets.bsky.social

9 months ago

Google Sheets: Track Time Overnight YouTube video by Spencer Teaches Sheets

youtube.com/shorts/8RPXM...

Google Sheets: Track Time Overnight

24 hours is equal to the number 1, so just add 1 to the Clock Out time if the out time is earlier than the in time.

CORTEXX
open.spotify.com/artist/4fOVG...

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide

0 0 0 0

@spencerssheets.bsky.social

9 months ago

Google Sheets: Offset Surrounding Cells YouTube video by Spencer Teaches Sheets

youtube.com/shorts/dqCMx...

Use negative offset_rows and _columns along with [height] and [width] to return a rectangular array of values.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars

0 0 0 0

@spencerssheets.bsky.social

9 months ago

A Link to Copy the Spreadsheet YouTube video by Spencer Teaches Sheets

youtube.com/shorts/8Tzwo...

Sometimes you just need to send a link for someone to make a copy of the spreadsheet. To do so, just replace /edit with /copy!

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars

0 0 0 0

@spencerssheets.bsky.social

9 months ago

Google Sheets + Google Apps Script: Get a Cell with sheet.getRange() YouTube video by Spencer Teaches Sheets

youtube.com/shorts/2iUQM...

When referencing a cell using sheet.getRange() the parameters are Row and then Column. So cell B1 is referenced as (1,2) in Apps Script.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide

0 0 0 0

Posts tagged #GoogleSheetsTips