#ExcelTips #PivotTables #ExcelFunctions

Why Pivot Tables Have Real Limitations

Name: Why Pivot Tables Have Real Limitations
Uploaded: 2026-09-17T21:23:39
Duration: 4 min 1 s
Description: Pivot tables are powerful, but they come with real constraints: rigid structures and incompatibility with newer chart types like treemaps. Discover how Microsoft's GROUPBY and PIVOTBY functions give you the flexibility pivot tables won't. Watch to see how these newer tools stack up against the classic approach.

4:01 · A clip from K2's Excel Tips - Today's Best Features, taught by Tommy Stephens

Pivot tables are powerful, but they come with real constraints: rigid structures and incompatibility with newer chart types like treemaps. Discover how Microsoft's GROUPBY and PIVOTBY functions give you the flexibility pivot tables won't. Watch to see how these newer tools stack up against the classic approach. From the course “K2's Excel Tips - Today's Best Features” (2 CPE credits, Computer Software and Applications, Intermediate): https://www.cpetoday.com/course/k2s-excel-tips-todays-best-features-25c-exltips Taught by Tommy Stephens — Partner, K2 Enterprises. More from Tommy Stephens: https://www.cpetoday.com/instructor/tommy-stephens CPE Today offers live webinars, Live Replays and self-study for CPAs and accounting professionals. NASBA-sponsored (ID 167619) and an IRS-approved CE provider. https://www.cpetoday.com/ #ExcelTips #PivotTables #ExcelFunctions

More from this course

2:19 How to Document Assumptions in Excel Collaborations

2:31 Build a Dashboard with 34 Auto-Generated Charts (No Copilot Subscription)

3:23 Why You Shouldn't Learn VBA Anymore