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
4 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 ↗
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 ↗