Cross-Tabs: Rows × Columns with UNIQUE, TRANSPOSE and One SUMIFS Grid
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- Row Labels: What a PivotTable Does, Rebuilt with UNIQUE and SORTFree
- Values: SUMIFS over the Spilled Labels (H2#) Pro
- Cross-Tabs: Rows × Columns with UNIQUE, TRANSPOSE and One SUMIFS Grid Pro
- Show Values As: % of Grand Total, % of Row and % of Column Pro
- Count, Average, Max and Distinct Count: COUNTIFS, AVERAGEIFS, MAXIFS Pro
- Report Filters: Criteria Cells, (All) and a Drill-Down List Pro
- Grouping Dates by Month and Quarter: EOMONTH and Text Keys Pro
- Capstone: A Subtotal Report, a Summary that Ignores It, and a Chart Pro