It’s officially time to retire Pivot Tables now that Excel released the PIVOTBY function. This new dynamic function allows you to create Pivot Tables in seconds by writing a formula and addresses the limitations of using a Pivot Table.
In this tutorial, you will learn how to quickly summarize large data sets using the new PIVOTBY function and all of its arguments. You will learn how to set up the table by selecting the row fields, column fields, an aggregation function, adding or removing headers, adding or removing grand totals or subtotals, and more. Then, you will learn how to analyze the table by sorting and filtering the data!
Lastly, you’ll learn the advantages of using the PIVOTBY function over a Pivot Table. You’ll even learn how to summarize text values!
Are you team PIVOTBY or PIVOT TABLES? Let me know your thoughts in the comments below.
RESOURCES
Download the workbook and follow along: https://exceldictionary.com/pages/yo...
SHOP EXCEL DICTIONARY
COURSES: https://exceldictionary.com/collecti...
GUIDES: https://exceldictionary.com/collecti...
MERCH: https://exceldictionary.com/collecti...
TEMPLATES: https://exceldictionary.com/collecti...
NEWSLETTER
Unlock the full potential of Excel and PowerPoint with expert tips delivered to your inbox each week: https://www.exceldictionary.com/subs...
SUBSCRIBE
Subscribe to never miss a video: / exceldictionary
TIMESTAMPS
‘0:00 Intro
‘0:28 PIVOTBY function overview
‘0:59 How to use the PIVOTBY function
‘2:00 How to add multiple row fields
‘2:18 How to modify table headers with the Field Headers argument
‘2:50 How to manage totals with the Total Depth arguments
‘3:53 How to sort the table using the Sort Order arguments
‘4:44 How to filter the table using the Filter Array argument
‘5:15 How to sort the table using the Sort Order arguments
‘5:15 PIVOTBY vs. PIVOT TABLES
‘6:10 How to filter out row values of 0
‘6:24 How summarize text values using PIVOTBY
‘7:13 Wrap up
#excel #exceltips