Excel
=EXCEL(...)Excel GROUPBY LAMBDA: Custom Aggregation Recipes
Go beyond Excel GROUPBY totals with LAMBDA recipes for distinct counts, multi-metric summaries, lists, and ratios.
Explore ↗
#advanced
6 formula guides
Excel
=CONVERT(...)Convert Numbers to Words in Excel Without VBA
Convert numbers to words in Excel without VBA using LAMBDA. Build a reusable NUMBERTOWORDS formula with currency.
Explore ↗
Excel
=EXCEL(...)Excel MAKEARRAY Function: Generate Arrays with LAMBDA
Generate custom arrays with Excel MAKEARRAY and LAMBDA. Build multiplication tables, random grids, and dummy data.
Explore ↗
Excel
=EXCEL(...)Excel LET Function: Simplify Complex Formulas, Boost Performance
Simplify Excel formulas with the LET function. Define variables, reduce repetition, and boost speed with real examples.
Explore ↗
Excel
=EXCEL(...)Excel LAMBDA Function: Build Custom Formulas Without VBA
Create custom Excel functions with LAMBDA — no VBA needed. Step-by-step guide with real examples and helper functions.
Explore ↗
Google Sheets
=GOOGLE(...)Google Sheets AI Function: How to Use =AI() in Your Spreadsheets
Use the Google Sheets AI function =AI() for text, summarization, sentiment, categorization via natural language.
Explore ↗