Excel
=FILTER(...)Excel Slicers: Filter PivotTables and Tables
Use Excel slicers to filter PivotTables and tables, connect compatible reports, and build clearer dashboards.
Explore ↗
#pivot-tables
7 formula guides
Google Sheets
=IMPORT(...)Import Excel Tables into Google Sheets: What to Check
Import Excel tables and pivot tables into Google Sheets, then verify relationships, formulas, and converted 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
=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
=GROUPBY(...)GROUPBY Function in Excel: The End of Manual Pivot Tables?
Excel's new GROUPBY function creates reports with one formula. Learn how it works and when to use it.
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 ↗