Write advanced formulas using VLOOKUP, COUNTIFS, COUNT, and IF functions
Apply quick and advanced filtering techniques to isolate and analyze data
Perform calculations on filtered data using SUBTOTAL and other functions
Create and customize PivotTables to summarize large datasets
Group, sort, and filter PivotTable data using slicers and report filters
Format data as tables and use formulas within PivotTables for enhanced analysis
