Google Sheets
=GOOGLE(...)Google Sheets INDIRECT: Build Dynamic Sheet References
Reference dynamic tab names, ranges, and multi-sheet summaries in Google Sheets using the powerful INDIRECT function.
Explore ↗
#dashboards
4 formula guides
Excel
=FILTER(...)Excel Slicers: Filter PivotTables and Tables
Use Excel slicers to filter PivotTables and tables, connect compatible reports, and build clearer dashboards.
Explore ↗
Google Sheets
=FILTER(...)Google Sheets FILTER with Optional Criteria: 3 Patterns
Build Google Sheets FILTER formulas with blank criteria, AND or OR logic, dropdowns, and no-match handling.
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 ↗