Excel Pivot Tables Course Part 3/3

Excel Pivot Tables Course Part 3/3

Hi, my name is Bartosz and I'm the author of this course that can be found on udemy and on the Excel BI Academy .com platform. 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.

Your next steps can be taken at udemy with my course: Power Query, Power Pivot, Data Viz & Power BI - 4in1 POWER or at my platform Excel BI Academy.

Best regards

Bartosz Czapiewski

Excel BI Academy

Advanced tricks with pivot tables

Url: View Details

What you will learn

• How to use advanced pivot charts
• What are the tips & tricks for the advanced
• How to deal with most common problems with pivot tables

Rating: 4.34

Level: Beginner Level

Duration: 2 hours

Instructor: Bartosz Czapiewski