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
12 formula guides
Google Sheets
=GOOGLE(...)Google Sheets COUNTUNIQUEIFS: Count Unique by Criteria
Count unique distinct values based on single or multiple conditions in Google Sheets using the native COUNTUNIQUEIFS function.
Explore ↗
Google Sheets
=GOOGLE(...)Google Sheets Import JSON API: Fetch Live Web Data
Fetch live REST API data into Google Sheets using custom Apps Script functions, JSON parsing, and scheduled refresh triggers.
Explore ↗
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
=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
=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
=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 ↗
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
=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 ↗