#GoogleSheetsTips
LightNews LightNews
sebas-ggarcia.bsky.social
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
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.
qubyts.sebasgarcia.net
August 21, 2025 at 5:45 AM
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
onecooltip.bsky.social
🧮Master the UNIQUE Function in Google Sheets

www.onecooltip.com/2025/03/mast...

@GoogleWorkspace #GoogleSheets #GoogleSheetsTips #DataAnalysis #SpreadsheetHacks, #ProductivityTools #DataCleaning #GoogleWorkspace
#TechTips #TechGuide #OneCoolTip @OneCoolTip
Master the UNIQUE Function in Google Sheets
A technology blog about making life better through daily tech tips. Google, Microsoft, iPhone, Android, ChatGPT, AI, Bing, software, hardware, iOS
www.onecooltip.com
March 3, 2025 at 4:29 PM
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
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
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/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/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
spencerssheets.bsky.social
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
Google Sheets: Choose a Value based on Count
YouTube video by Spencer Teaches Sheets
youtube.com
August 7, 2025 at 6:12 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/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
Google Sheets: Override Formula Output with Manual Data
YouTube video by Spencer Teaches Sheets
youtube.com
August 2, 2025 at 7:50 PM
spencerssheets.bsky.social
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
Google Sheets: Highlight Rows with No Checked Boxes
YouTube video by Spencer Teaches Sheets
youtube.com
August 1, 2025 at 5:21 AM
spencerssheets.bsky.social
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
Google Sheets: Multiply Checkboxes by a Value Row-by-Row
YouTube video by Spencer Teaches Sheets
youtube.com
July 31, 2025 at 7:13 AM
spencerssheets.bsky.social
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
Google Sheets: Multidimensional Sort
YouTube video by Spencer Teaches Sheets
youtube.com
July 24, 2025 at 5:59 AM
spencerssheets.bsky.social
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
Google Sheets: Use the Filter Tool to Sort
YouTube video by Spencer Teaches Sheets
youtube.com
July 21, 2025 at 9:22 PM
spencerssheets.bsky.social
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
Google Sheets: Use ARRAYFORMULA to Perform a Simple Calculation Down a Column
YouTube video by Spencer Teaches Sheets
youtube.com
July 20, 2025 at 6:21 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/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
Google Sheets: Use HSTACK to Fill 2 Columns at Once from Different Formulas
YouTube video by Spencer Teaches Sheets
youtube.com
July 10, 2025 at 5:41 AM
spencerssheets.bsky.social
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
Google Sheets Basics: Automatically Recognizing Contiguous Data
YouTube video by Spencer Teaches Sheets
youtube.com
July 9, 2025 at 5:53 AM
spencerssheets.bsky.social
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
Google Sheets: Use =IF(ISBLANK()) to Test if a Cell Contains Data
YouTube video by Spencer Teaches Sheets
youtube.com
July 2, 2025 at 6:13 AM
spencerssheets.bsky.social
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
Google Sheets: Use =IF(LEN()) to test if a cell contains data
YouTube video by Spencer Teaches Sheets
youtube.com
June 29, 2025 at 5:56 AM