Excel
=EXCEL(...)Excel MODE.MULT: Find Multiple Modal Values in Data
Calculate and display bimodal and multimodal distributions in Excel using the dynamic array MODE.MULT function.
Explore ↗
Data Analysis
19 formula guides
Excel
=EXCEL(...)Excel Goal Seek: Solve for a Target Value
Use Excel Goal Seek to work backward from a target result, then verify the one input it changes.
Explore ↗
Excel
=LINEAR(...)Linear Interpolation in Excel: Fill Missing Values
Use linear interpolation in Excel to estimate missing values between known points without confusing it with forecasting.
Explore ↗
Excel
=FILTER(...)Excel Slicers: Filter PivotTables and Tables
Use Excel slicers to filter PivotTables and tables, connect compatible reports, and build clearer dashboards.
Explore ↗
Excel
=EXCEL(...)Excel Histogram Bins: Create Better Frequency Charts
Create clearer Excel histograms by choosing bin width, overflow, and underflow settings for real data.
Explore ↗
Google Sheets
=FILTER(...)Google Sheets Slicers: Filter Charts and Pivot Tables
Google Sheets slicers filter charts and pivot tables, combine controls, and why formulas stay unchanged.
Explore ↗
Excel
=QUERY(...)Excel Power Query Unpivot Columns: Step-by-Step
Unpivot columns in Excel Power Query, preserve identifiers, clean blanks, and build refreshable analysis tables.
Explore ↗
Excel
=EXCEL(...)Excel STOCKHISTORY Function: Pull Historical Prices
Use the Excel STOCKHISTORY function to pull daily, weekly, or monthly prices into a chart-ready table.
Explore ↗
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 ↗
Google Sheets
=WEB(...)Web Scraping Google Sheets: IMPORTHTML, IMPORTXML & DATA
Scrape websites into Google Sheets with IMPORTHTML, IMPORTXML and IMPORTDATA. Learn XPath, limits and error fixes.
Explore ↗
Excel
=PYTHON(...)Python in Excel xl Function: References & Limits
Use Python in Excel xl references to read workbook data, return analysis, and avoid common availability limits.
Explore ↗
Excel
=PIVOTTABLE(...)PivotTable #SPILL! Error in Excel: What It Means & How to Fix It
Excel PivotTables now show #SPILL! when results cannot expand. Learn what it means and how to fix it fast.
Explore ↗
Google Sheets
=PIVOT(...)Pivot Tables in Google Sheets: Complete Beginner Guide
Create pivot tables in Google Sheets: rows, columns, values, calculated fields, date grouping and slicers for beginners.
Explore ↗
Excel
=EXCEL(...)Excel Tables: Structured References That Auto-Expand
Excel tables auto-expand and give you readable structured references for formulas that update as your data grows.
Explore ↗
Excel
=EXCEL(...)Excel IMPORTCSV Function: Import CSV with One Formula
Import CSV and text files into Excel with IMPORTTEXT and IMPORTCSV formulas, one-cell data import without Power Query.
Explore ↗
Google Sheets
=COMBO(...)Combo Chart in Google Sheets: Secondary Axis & Multi-X Scatter
Google Sheets July 2026: combo charts with secondary axis and multi-X scatter charts, step by step.
Explore ↗
Excel
=EXCEL(...)Excel Data Cleaning: Duplicates, Flash Fill, Text to Columns
Clean messy data in Excel. Master Remove Duplicates, Flash Fill, Text to Columns, TRIM, and Find & Replace for analysis-ready data.
Explore ↗
Excel
=EXCEL(...)Excel GROUPBY and PIVOTBY: Deep Dive into New Aggregation Functions
Deep dive into Excel GROUPBY and PIVOTBY functions. Learn advanced usage, performance tips, and when to use them.
Explore ↗
Excel
=PIVOT(...)Pivot Table Beginner Guide: Analyze Data in Minutes
Learn Pivot Tables in Excel. Step-by-step beginner guide to summarize, filter, and analyze data in minutes.
Explore ↗