top of page

Mastering Excel's PIVOTBY Function – 3 Real-World Examples You Need to See

Are you looking to level up your data summarization game in Excel? Microsoft has rolled out a new dynamic function that’s turning heads: PIVOTBY.



Unlike traditional PivotTables, PIVOTBY is a formula-based approach to summarizing your data, giving you more flexibility and fewer clicks. If you're already using functions like GROUPBY, FILTER, or VSTACK, this new addition is going to fit right into your workflow.


I just released a brand-new YouTube video where I break down three practical ways to use PivotBy in Excel:




✅ Here’s What You’ll Learn:

  1. Simple List SummarizationCreate quick summaries of sales, inventory, or any list without a PivotTable.

  2. Filtered PivotBy ResultsCombine FILTER with PivotBy to dynamically control what gets summarized based on a user-defined input.

  3. Multi-Sheet Summarization with VSTACKEver wanted to summarize data spread across multiple worksheets? Now you can with VSTACK and PivotBy – no Power Query needed.


Why PivotBy Is a Game-Changer

  • No need for PivotTables – everything happens in-cell.

  • Easily dynamic – update your criteria or input ranges on the fly.

  • Better performance for modern Excel workbooks with structured data.


Whether you're building dashboards, reports, or ad-hoc summaries, PivotBy offers a powerful, modern way to work with your data.


If you're an Excel enthusiast or trainer, this is one feature you don't want to miss.


DOWNLOAD EXERCISE FILE


 
 
 

© 2019 by Office Newb, LLC.

bottom of page