🚀 5 Formulas to Master Google Sheets: 1️⃣ FILTER 2️⃣ QUERY 3️⃣ ARRAYFORMULA 4️⃣ IMPORTRANGE 5️⃣ TEXTJOIN Once you learn these, your reports will build themselves. #googlesheets #googlesheetstutorial #DataAnalysis #Productivity

The SPLIT() function is such a useful function – simply give it text and tell it what to use as separator and you can split single-cell text into multiple cells. CORTEXX open.spotify.com/artist/4fOVG4v… #googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars

Returning 1 row per unique ID (the Rep in this case), the count of each, and the sum of amounts, all in a single formula. GROUP BY is used to only return 1 of each ID. CORTEXX open.spotify.com/artist/4fOVG4v… #googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguidADe

youtu.be/G4D3VGhJjac Google Sheets Basics A-Z: Introduction to Spreadsheets (Tutorial for Beginners) #GoogleSheets #SpreadsheetBasics #GoogleSheetsTutorial #IntroductionToSpreadsheets #LearnGoogleSheets #GoogleWorkspace #Formulas

Which arrays should you pass to MAP()? Only those that should update on each iteration! If a range is supposed to be static (ie. the lookup_range of XLOOKUP), don't pass it CORTEXX open.spotify.com/artist/4fOVG4v… #googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide

The [index] of VLOOKUP() is which column of the range to return. If the index is greater than the number of columns, it throws an Out of Bounds error Music by CORTEXX open.spotify.com/artist/4fOVG4v… #googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars