Formula & Tutorial Archive

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

Remove duplicates and extract distinct values in Google Sheets with the UNIQUE function. Real examples, sorting, and error fixes.

Sort Excel tables by cell color, font color, icons, or a custom list without separating rows from their records.

Calculate and display bimodal and multimodal distributions in Excel using the dynamic array MODE.MULT function.

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.

Understand the Google Sheets 20 million cell limit, beta availability, file sizing, and performance trade-offs.

Count unique distinct values based on single or multiple conditions in Google Sheets using the native COUNTUNIQUEIFS function.

Fetch live REST API data into Google Sheets using custom Apps Script functions, JSON parsing, and scheduled refresh triggers.

Reference dynamic tab names, ranges, and multi-sheet summaries in Google Sheets using the powerful INDIRECT function.

Generate dynamic number sequences, custom date ranges, and 2D matrix grids in Google Sheets using the SEQUENCE function.

Rotate tables, flip matrix dimensions, and combine TRANSPOSE with QUERY in Google Sheets for dynamic data reshaping.

Use Excel Goal Seek to work backward from a target result, then verify the one input it changes.

Use linear interpolation in Excel to estimate missing values between known points without confusing it with forecasting.

Use Excel slicers to filter PivotTables and tables, connect compatible reports, and build clearer dashboards.

Create clearer Excel histograms by choosing bin width, overflow, and underflow settings for real data.

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 Evaluate Formula to step through nested calculations, find the first wrong value, and fix it safely.

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

Monitor important Excel formulas and values with Watch Window while navigating large, multi-sheet workbooks.

Build Google Sheets FILTER formulas with blank criteria, AND or OR logic, dropdowns, and no-match handling.

Import Excel tables and pivot tables into Google Sheets, then verify relationships, formulas, and converted data.

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

Use Excel Agent Mode for workbook tasks with safer prompts, review steps, and practical Copilot limits.

Learn how Excel formula completion suggests formulas as you type, how to review them, and how to validate results.

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

Show Google Sheets durations over 24 hours with elapsed-time formats, numeric conversions, and reliable formulas.

Unpivot columns in Excel Power Query, preserve identifiers, clean blanks, and build refreshable analysis tables.

Use the Excel STOCKHISTORY function to pull daily, weekly, or monthly prices into a chart-ready table.

Trace Excel precedents and dependents to find inputs, downstream impact, and safer formula audits.

Build dependent dropdown lists in Excel with INDIRECT or dynamic arrays, from two-level choices to three-level cascades.

Go beyond Excel GROUPBY totals with LAMBDA recipes for distinct counts, multi-metric summaries, lists, and ratios.

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

Scrape websites into Google Sheets with IMPORTHTML, IMPORTXML and IMPORTDATA. Learn XPath, limits and error fixes.

Use Python in Excel xl references to read workbook data, return analysis, and avoid common availability limits.

Speed up slow Excel workbooks with Check Performance. Find and remove bloated formatting that drags down your files.

Use Google Sheets date functions for age, deadlines, month ends, and business-day calculations across locales.

Google Sheets checkboxes store TRUE/FALSE values you can count, format and filter to build interactive to-do lists.

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

Learn Excel custom number format codes: four-section structure, colors, conditions, and thousands scaling with examples.

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

Excel tables auto-expand and give you readable structured references for formulas that update as your data grows.

Use SHEET and SHEETS in Google Sheets to get tab numbers and count sheets. New 2026 functions explained.

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

Import CSV and text files into Excel with IMPORTTEXT and IMPORTCSV formulas, one-cell data import without Power Query.

Learn two ways to sum visible filtered rows in Google Sheets while excluding rows that match custom criteria.

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

Excel July 2026 update: Copilot model choice (GPT-5.6, Claude Opus 5), inline citations, brand kit skills, and AutoSave-off support.

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.

Google Sheets July 2026: combo charts with secondary axis and multi-X scatter charts, step by step.

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.

Master ARRAYFORMULA in Google Sheets. Combine with FILTER, SPLIT, IF across columns — avoid common mistakes.

Clean messy data in Excel. Master Remove Duplicates, Flash Fill, Text to Columns, TRIM, and Find & Replace for analysis-ready data.

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.

Create interactive dashboards in Google Sheets with Canvas. Build kanban boards, heat maps, and data views without code.

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.

Use the Google Sheets AI function =AI() for text, summarization, sentiment, categorization via natural language.

Learn to use AI for Excel formulas. Prompt templates for VLOOKUP, REGEX, nested IF — and how to validate AI output.

Open UTF-8 CSV files in Excel without garbled characters. Fix encoding issues with Power Query, Import Wizard, and BOM.

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

Learn conditional formatting in Excel. Highlight cells, color scales, data bars, and custom rules step by step.

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

Create dropdown lists and validate data in Excel. Step-by-step guide to data validation rules and error alerts.

Deep dive into Excel GROUPBY and PIVOTBY functions. Learn advanced usage, performance tips, and when to use them.

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

50+ Excel keyboard shortcuts for Windows and Mac. Organized by navigation, formulas, formatting, and editing.

Excel and Google Sheets have key formula differences. Learn which functions work in both and how to avoid errors.

Learn FILTER function in Google Sheets. Extract data matching your conditions with simple step-by-step examples.

Google added new functions and AI features to Sheets in 2026. See what changed, from new formulas to Gemini integration.

Learn Google Sheets IMPORT functions. IMPORTRANGE, IMPORTHTML, IMPORTXML, and IMPORTDATA for external data.

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

Learn IF, nested IF, and IFS in Excel. Know when to use each for decision-making formulas with examples.

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

Learn Pivot Tables in Excel. Step-by-step beginner guide to summarize, filter, and analyze data in minutes.

Learn Google Sheets QUERY with SQL syntax. Guide for Excel users switching to Sheets — SELECT, WHERE, GROUP BY.

Learn SPLIT and text functions in Google Sheets. Split text, extract characters, and format data with examples.

Compare SUMIF, SUMIFS, and SUMPRODUCT in Excel. Learn differences and when to use each function with examples.

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.