In this Excel video tutorial, we gonna see how to use the new Excel function, the PIVOTBY Function and How to use it with Practical Examples step by step from scratch. The Excel Pivotby formula can be an alternative to pivot tables.

As far as I know, at the moment, this new Excel function is only available in Excel 365 and Excel Online.

With this formula, can we replace pivot tables and can help us make analyzes, save time with Excel and automate tasks and automate processes? Let's find it out.

Pivot tables in Excel are one of the most used tools in Excel and one of the most important tools in Excel, but with this new formula that Excel has launched we can start using it instead of using the pivot table.

Don't we need to use Pivot Tables in Excel anymore? The answer is, it depends. Because, currently pivot tables have more features than the groupby or pivotby, but those two new functions can already help us a lot to make analyzes in Excel.

Maybe not all versions of Excel already have this update, but if the version of Excel you use on your personal computer, at home, doesn't yet have this new update, you can still learn it. Perhaps, the company where you work at already has new versions of Excel and you can now apply this knowledge in practice and on a daily basis to help you solve problems.

00:00 - Understanding PIVOTBY
00:57 - The first thing we need
01:57 - The Arguments/Options we have
02:23 - 1st Example
04:00 - 2nd Example
04:56 - 3rd Example
07:16 - Adding an Interactive Chart
08:46 - 4th Example: Filter Array

#JopaExcel #Dashboard #Excel