Excel Pivot Tables Course Part 3/3

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.


Online Tutorials
Show full profile

Online Tutorials

Online Tutorials is a website sharing online courses, and online tutorials for free on a daily basis. You can find the best free online courses and thousands of free online courses with certificates to take your knowledge to the next level with the free courses.

We will be happy to hear your thoughts

Leave a reply

Online College Courses
Logo
Register New Account