Google Sheets
Sheets-specific functions: QUERY, ARRAYFORMULA, REGEX, and more.
Filter and Sort Data With QUERY
QUERY runs a SQL-style select over your data — filter deals over 1,000 and sort them largest-first in a single Google Sheets formula.
=QUERY(A1:D20,"select A, D where D > 1000 order by D desc",1)Apply One Formula to a Whole Column With ARRAYFORMULA
One ARRAYFORMULA in the top cell calculates every row below it — no more copying quantity × price down the column by hand.
=ARRAYFORMULA(B2:B10*C2:C10)Flag Rows That Match a Text Pattern With REGEXMATCH
REGEXMATCH returns TRUE when a cell matches a regular expression — flag customers on personal Gmail addresses in one Google Sheets formula.
=REGEXMATCH(A2,"@gmail\.com$")Pull Data From Another Spreadsheet With IMPORTRANGE
IMPORTRANGE streams a live block of data from one Google Sheets file into another — orders flow into your report without copy-pasting.
=IMPORTRANGE("spreadsheet_url","Orders!A1:D20")Show a Trend as a Mini Chart Inside a Cell
SPARKLINE draws a tiny chart inside a single cell — one per row shows every customer's sales trend at a glance, no chart objects needed.
=SPARKLINE(B2:M2)Pull Live Stock Prices Into Your Spreadsheet
GOOGLEFINANCE fetches current and historical market prices straight into cells — a self-updating portfolio or holdings tracker in one formula.
=GOOGLEFINANCE("NASDAQ:AAPL","price")