[Free] Excel Pivot Tables Course Part 3/4
You will learn to work with a pivot table and learn about the possibilities of creating dashboards with their use. – Free Course
What you’ll 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
- How to design dashboards with the use of pivot tables
Requirements
- I recorded the course in 2019 in Office 365, but the PivotTable has been working the same for years.
- You can easily follow the course in Excel 2007, 2010, 2013, 2016, 2019 and 365.
- In older versions, you may encounter different nomenclature or missing certain functions (e.g. slicer, timeline, + – icons next to the chart).
Description
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
Author(s): Bartosz Czapiewski
