Formulas & Functions

Master the Excel ROUND function with MROUND, CEILING, and FLOOR. Round decimals, times, and currency accurately with practical examples.

Master recursive LAMBDA functions in Excel to perform looping calculations, text replacements, and math sequences without VBA.

Extract specific text patterns, numbers, email addresses, and codes in Excel using the native REGEXEXTRACT function.

Replace deeply nested IF statements in Excel with the cleaner, faster SWITCH function for exact value branch matching.

Combine text from multiple cells conditionally in Excel using TEXTJOIN, IF, and dynamic array FILTER formulas.

Fix Excel stale values by checking calculation mode, refreshing formulas, and understanding the warning safely.

Fix the Excel #CALC! error caused by empty arrays, nested results, LAMBDA cases, and unsupported calculations.

Use Excel TRANSLATE and DETECTLANGUAGE to process text columns, check limits, and handle failures safely.

Create Google Sheets named functions to reuse complex formulas, document arguments, and reduce helper columns.

Master Google Sheets REGEXEXTRACT, REGEXMATCH, and REGEXREPLACE for practical text cleanup and validation.

Fix the Google Sheets array result not expanded error by finding blocked cells and hidden values.

Use XLOOKUP with multiple criteria in Excel. Compare Boolean, concatenated-key, and helper-column methods.

Understand Excel floating-point errors, equality surprises, currency rounding, and safer formulas for precise results.

Use Excel TRIMRANGE to remove empty edge rows and columns, simplify formulas, and trim full-column references.

Master Excel LAMBDA helper functions: BYROW, BYCOL, MAP, SCAN and REDUCE for running totals and per-row logic.

Master Excel spill ranges and the # operator to build formulas that update automatically as your data grows.

Use SUBTOTAL and AGGREGATE in Excel to sum only visible rows. Compare codes 9 vs 109 to skip hidden rows and errors.

Learn Excel date functions: DATEDIF for age, EDATE and EOMONTH for deadlines, NETWORKDAYS for business days.

Convert numbers to words in Excel without VBA using LAMBDA. Build a reusable NUMBERTOWORDS formula with currency.

Generate custom arrays with Excel MAKEARRAY and LAMBDA. Build multiplication tables, random grids, and dummy data.

Reshape data in Excel with TOCOL, TOROW, WRAPCOLS, WRAPROWS and EXPAND. Flatten grids and wrap lists in one formula.

Slice Excel arrays with TAKE, DROP, CHOOSEROWS, CHOOSECOLS: extract or reorder rows and columns in one dynamic formula.

Track stocks and currencies in Google Sheets with GOOGLEFINANCE. Build a live portfolio tracker — no API keys needed.

Create in-cell mini charts in Google Sheets with SPARKLINE. Line, bar, column, and win/loss — all in one formula.

Combine Excel data with VSTACK and HSTACK. Consolidate sheets, merge arrays, build dynamic reports, no copy-paste.

Simplify Excel formulas with the LET function. Define variables, reduce repetition, and boost speed with real examples.

Learn TEXTSPLIT, TEXTBEFORE, and TEXTAFTER in Excel. Replace LEFT/RIGHT/MID with cleaner text extraction.

Fix common Excel formula errors. Step-by-step guide for #REF!, #VALUE!, #DIV/0!, #N/A, and #SPILL! with real examples.

Master Excel named ranges. Create meaningful cell and range names to simplify formulas, reduce errors, and build more maintainable spreadsheets.

Master FILTER, SORT, UNIQUE & SEQUENCE in Excel. Build reports that auto-update with spill ranges — no VBA required.

Create custom Excel functions with LAMBDA — no VBA needed. Step-by-step guide with real examples and helper functions.

Learn REGEX functions in Excel. Use REGEXTEST, REGEXEXTRACT, and REGEXREPLACE to match text patterns without VBA.

Learn COUNTIF and COUNTIFS in Excel. Count cells by single or multiple conditions with step-by-step examples.

Microsoft added new features to Excel in June 2026. See what changed, from new functions to performance improvements.

Excel's new GROUPBY function creates reports with one formula. Learn how it works and when to use it.

Learn INDEX and MATCH in Excel. Step-by-step guide to left lookups, two-way lookups, and advanced scenarios.

Compare VLOOKUP and XLOOKUP in Excel. Learn key differences, limitations, and when to use each with real examples.

Learn XLOOKUP in Excel with examples. Left lookups, error handling, multiple values, and advanced scenarios.