Last updated on Jun 26, 2026, 5:12 PM
| Formula | Problem Where It Works | Example | Use Case | ▶️ YouTube |
|---|---|---|---|---|
| GOOGLEFINANCE Historical | How do I analyze historical stock performance? | =GOOGLEFINANCE("GOOG","close",TODAY()-30,TODAY()) | Historical prices | https://youtu.be/0-KVFAWoX5M?si=ohMjM1Cnc2ER6lOb |
| NETWORKDAYS.INTL | How do I calculate workdays with custom weekends? | =NETWORKDAYS.INTL(A1,B1,"0000011") | Custom workdays | https://www.youtube.com/watch?v=iHbMHlEDv5M |
| WORKDAY.INTL | How do I calculate future business dates with custom weekends? | =WORKDAY.INTL(A1,30,"0000011") | Business dates | https://youtu.be/1BcqNE7nwRA?si=sBFfISyEs-SVmJf1 |
| DATEDIF | How do I calculate age in months between two dates? | =DATEDIF(A1,B1,"YM") | Age/month calculation | https://youtu.be/5LbgjGAxzhw?si=E0gInOqWVRJt0Qfv |
| SPARKLINE | How do I display trend charts inside cells? | =SPARKLINE(B2:M2)' | Mini charts | https://www.youtube.com/watch?v=LAps3XqUB8o |
| FREQUENCY | How do I analyze the distribution of values into groups? | =FREQUENCY(A:A,{10,20,30,40}) | Distribution analysis | https://www.youtube.com/watch?v=YJ-KVogg0-o |
| MMULT | How do I perform matrix multiplication in Google Sheets? | =MMULT(A1:C3,E1:G3) | Matrix multiplication | https://youtu.be/O5GMndAUWSs?si=b2qkQUbD1zajtdg9 |
| TRANSPOSE + QUERY | How do I create pivot-style reports from horizontal data? | =QUERY(TRANSPOSE(A1:Z2),"SELECT *") | Pivot-like reporting | https://www.youtube.com/watch?v=h80wt_uhi4M |
| COUNTIF | How do I count all records matching a specific value? | =COUNTIF(A:A,"Paid") | Count matching values | https://youtu.be/rt8VZB-mytw?si=gbRSMyCF20mY54GH |
| COUNTIFS | How do I count records matching multiple criteria? | =COUNTIFS(A:A,"Paid",B:B,"Yes") | Multiple conditions | https://youtu.be/fmpAMoDiqIU?si=B3RkfBHoMtmQY0AV |
| GOOGLEFINANCE | How do I pull live stock market data into Google Sheets? | =GOOGLEFINANCE("GOOG") | Financial data | https://youtu.be/k1hl8cx8rus?si=a1LG1AihM5y4ivTZ |
| GOOGLETRANSLATE | How do I translate text automatically in Google Sheets? | =GOOGLETRANSLATE(A1,"en","es") | Translate text | https://youtu.be/4c5Qmqgi-xw?si=OobapvnDcqjMauEl |
| IMPORTXML | How do I scrape specific information from a webpage? | =IMPORTXML("https://example.com","//title") | Scrape web data | https://youtu.be/BLa9HKGos8U?si=1B9ul0-S1loGhCpj |
| IMPORTHTML | How do I import tables from a website? | =IMPORTHTML("https://example.com","table",1) | Import tables | https://youtu.be/07Bm03b0Yhs?si=IRYjHLzRg-hlHIVk |
| IMPORTRANGE | How do I pull data from another Google Sheet? | =IMPORTRANGE("URL","Sheet1!A:C") | Import other sheets | https://youtu.be/5S7laJS9meU?si=xzQ96Ktnc6_IjP0e |
| IMAGE | How do I display images directly inside spreadsheet cells? | =IMAGE("https://example.com/image.jpg") | Display image | https://youtu.be/rJGRGL4WmCA?si=jKcjHCuIbAB8QlpT |
| SPARKLINE | How do I create mini charts inside a single cell? | =SPARKLINE(A1:A10) | Mini charts | https://youtu.be/LAps3XqUB8o?si=ITiBnFENiJPhi7Gf |
| XLOOKUP | How do I return a custom message when a lookup fails? | =XLOOKUP(E2,A:A,C:C,"Not Found") | Modern lookup | https://youtu.be/Ib8CZpoTiS0?si=tPs_dzdJYEgsva1g |
| ARRAYFORMULA | How do I calculate an entire column automatically? | =ARRAYFORMULA(B2:B*C2:C) | Entire column calculations | https://youtu.be/92C3V0GjhgA?si=l-E_cDpCy5TZgGon |
| ARRAYFORMULA + VLOOKUP | How do I perform lookups for an entire column at once? | =ARRAYFORMULA(VLOOKUP(E2:E,A:C,3,FALSE)) | Bulk lookups | https://www.youtube.com/watch?v=ptH1WMTlo_Y |
| MAP | How do I apply custom logic to every value in a range? | =MAP(A2:A,LAMBDA(x,x*10)) | Apply custom logic | https://youtu.be/ao_gyD4ubCA?si=NO5BxvIwV_zk6vmC |
| BYROW | How do I calculate totals for every row automatically? | =BYROW(A2:D10,LAMBDA(r,SUM(r))) | Row calculations | https://youtu.be/X6Ezq2NI2-0?si=MRS8uwlnrU3TxX4X |
| BYCOL | How do I calculate averages for every column automatically? | =BYCOL(A2:D10,LAMBDA(c,AVERAGE(c))) | Column calculations | https://youtu.be/6uGXXynoe_Y?si=HFinAV2OKdDMKHG1 |
| REDUCE | How do I accumulate values into a single result? | =REDUCE(0,A1:A10,LAMBDA(a,b,a+b)) | Accumulation | https://youtu.be/fx3zokLjTJY?si=Jw1QS1y0jy7yqlcC |
| SCAN | How do I create running totals automatically? | =SCAN(0,A1:A10,LAMBDA(a,b,a+b)) | Running totals | https://youtu.be/9Pj3_9fadfA?si=YxwH4f3lNIwmtpe4 |
| MAKEARRAY | How do I generate a custom array without manual entry? | =MAKEARRAY(5,5,LAMBDA(r,c,r*c)) | Dynamic arrays | https://youtu.be/1sfJX_j3GFE?si=LoNV8LN6JPvxyapi |
| LET | How do I reuse a calculation within a formula? | =LET(x,SUM(A:A),x*0.1) | Reusable variables | https://youtu.be/Fb8v1uSu0Es?si=PB7sf3jVgdk-xkkB |
| LAMBDA | How do I create my own custom function? | =LAMBDA(x,x*2)(10) | Custom functions | https://youtu.be/7b57QkBT44w?si=mktA-sj1wKEavjT2 |
| CHOOSECOLS | How do I return only selected columns from a dataset? | =CHOOSECOLS(A:F,1,3,5) | Extract columns | https://youtu.be/wVbiqOsBqVM?si=z7Ou9U5tU8-na54G |
| CHOOSEROWS | How do I return only selected rows from a dataset? | =CHOOSEROWS(A:F,2,4,6) | Extract rows | https://youtu.be/_hzXv27mqCA?si=CeeF6SmmJWQHMSGE |
| WRAPROWS | How do I convert a single column into multiple rows? | =WRAPROWS(A1:A20,5) | Reshape data | https://www.youtube.com/watch?v=MiYBgw_FDbQ |
| WRAPCOLS | How do I convert a single column into multiple columns? | =WRAPCOLS(A1:A20,5) | Reshape columns | https://www.youtube.com/watch?v=nspTV_8cru0 |
| HSTACK | How do I combine multiple columns into one table? | =HSTACK(A:A,B:B,C:C) | Merge columns | https://www.youtube.com/watch?v=VBfY-i_byw8 |
| VSTACK | How do I combine data from multiple sheets vertically? | =VSTACK(Sheet1!A:C,Sheet2!A:C) | Combine tables | https://www.youtube.com/watch?v=VBfY-i_byw8 |
| TOCOL | How do I convert a table into a single column? | =TOCOL(A1:D10)' | Convert to one column | https://youtu.be/_-dzsSpqoEs?si=aXYIkVjF0VLPEnCh |
| TOROW | How do I convert a table into a single row? | =TOROW(A1:D10)' | Convert to one row | https://youtu.be/_-dzsSpqoEs?si=aXYIkVjF0VLPEnCh |
| REGEXEXTRACT | How do I extract numbers from text strings? | =REGEXEXTRACT(A1,"[0-9]+") | Extract numbers | https://www.youtube.com/watch?v=w5B43VsJqOs |
| REGEXMATCH | How do I validate email domains in Google Sheets? | =REGEXMATCH(A1,"gmail\.com") | Email validation | https://www.youtube.com/watch?v=Q_gtj9F5DnA |
| REGEXREPLACE | How do I remove non-numeric characters from phone numbers? | =REGEXREPLACE(A1,"[^0-9]","") | Clean phone numbers | https://www.youtube.com/watch?v=Nm1zJlzdrzQ |
| TEXTJOIN + FILTER | How do I create a dynamic comma-separated list? | =TEXTJOIN(", ",TRUE,FILTER(A:A,B:B="Yes")) | Dynamic lists | https://www.youtube.com/watch?v=Nm1zJlzdrzQ |
| IMPORTRANGE + QUERY | How do I build reports from external spreadsheets? | =QUERY(IMPORTRANGE("URL","Sales!A:F"),"SELECT Col1,Col3") | Remote reporting | https://www.youtube.com/watch?v=bW6P2YvLyZg&list=PLv9Pf9aNgemvAMlqvHP9RhXPW98g_eo7d |