Excel Pivot Tables Course Part 3/3, Advanced tricks with pivot tables.
Hi, this is Bartosz from Excel BI Academy.
I hope you’ve managed to get through the previous 2 courses and are ready for advanced Pivot Table elements – the best Excel analytical engine that has been invented.
In the third part of the course, we will finally build a comprehensive sales dashboard and apply some fantastic tricks. Next, we will learn advanced data filtering techniques that are useful on a daily basis. There are also many difficult calculations at which you have to think a little. You will also find them in this course. Finally, you will learn advanced graphic technologies on pivot tables, thanks to which you can build any chart or a comprehensive dashboard.
Be prepared for many Do-It-Yourself exercises and many tricks that are hard to be found anywhere else.
And this is really my recommendation after many years spent working on reports in Excel: always build dashboards based on pivot tables.
I believe that after passing all 3 courses about pivot tables and my courses on formulas, you will be ready for further adventure with POWER add-ins: Power Query, Power Pivot, Power BI. Pivot table is the heart of all these fantastic tools, that can revolutionize your approach to reports.
Best regards
Bartosz Czapiewski
Excel BI Academy.
