New Function in EXCEL - PIVOTBY | Alternative of PivotTable
Welcome back to our channel! In today's video, we're diving into the powerful new PIVOTBY function in Excel. This function allows you to group data by both rows and columns, making it a fantastic tool for summarizing and analyzing large datasets.
🔍 What You'll Learn:
The basics of the PIVOTBY function and how it differs from the GROUPBY function
Step-by-step instructions on how to use the PIVOTBY function
How to convert dates into years using the TEXT function within PIVOTBY
Using optional arguments like Column Total Depth and Col Sort Order
👉 Related Video:
If you haven't seen our video on the GROUPBY function, make sure to check it out here .
It covers the foundational concepts that will enhance your understanding of PIVOTBY.
Don't forget to hit that Subscribe button and turn on notifications so you never miss out on our short and impactful Excel tricks that will take your skills from good to great!
👉 Related Video:
If you haven't seen our video on the GROUPBY function, make sure to check it out here • New Excel Function - GROUPBY (every E... .
It covers the foundational concepts that will enhance your understanding of PIVOTBY.
5 Data Validation Tricks (with examples):
• 5 Data Validation Tricks (with examples)
🔔 Don’t forget to:
Like the video if you found it helpful.
Subscribe to The Excel Experience for more quick Excel tips.
Hit the bell icon to get notified when we upload new content.
Comment below which trick you're excited to use!
Have Questions or Feedback?
Leave a comment below! I love hearing from you and am here to help.
Also Follow me on
Tiktok: / the_excel_experience
Instagram: / the_excel_experience
Threads: https://www.threads.net/@the_excel_ex...
#excelshorts #exceltips #exceltutorial #excelfunction #excelnewfunction #dropdownlist #dropdown #datavalidation #spreadsheettricks #exceltricks #groupby #pivottables #pivottable #PIVOTBY