Free Excel Tutorial – Excel Pivot Tables course Part 2/3
Learn how to filter data and insert charts in Pivot Tables with one click. Discover the power of calculations and explore advanced features like Power Query and Power Pivot. This course is suitable for both beginners and advanced Excel users. No prerequisites required. Start mastering Pivot Tables today!
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. This is a continuation of the first part of the course about Pivot Tables in Excel. You’ll learn how to filter data in Pivot Tables. You will also learn the most interesting option for filtering, which are slicers. Next, you will learn how to insert charts in Pivot Tables with one click, that is, Pivot Charts. Another topic is calculations in a Pivot Table, which can be implemented in many ways. These include Show Values As and Calculated Field.
With the second part of the course, you will enter an intermediate level of using PivotTables. I recorded the course in Excel 365, but you will find Pivot Tables in Excel for many years.
Getting to know Pivot Tables is, in my opinion, the foundation of working in Excel, which you will later use in many other tools. I mean Power Query, Power Pivot (i.e., super pivot tables) and Power BI – an application for designing dashboards. Each of these tools has relationships with a Pivot Table.
I believe that Pivot Tables are the biggest revolution in Excel, so it is worth getting to know them thoroughly in 3 parts of my course. I hope you enjoy all of them.
Your next steps can be taken at udemy with my course: Power Query, Power Pivot, Data Viz & Power BI – 4in1 POWER or on my platform Excel BI Academy .com.
Best regards
Bartosz Czapiewski
Excel BI Academy
Who this course is for:
- The course is aimed at both beginners and advanced users of Excel.
- I hope everyone will find something interesting in it.
- There are no prerequisites for the course as the pivot table is a standalone functionality.
- Few formulas appear in the course, and all options are discussed in detail.
- Usually, a pivot table is taken by users who have a basic understanding of Excel and formulas.
User Reviews
Be the first to review “Free Excel Tutorial – Excel Pivot Tables course Part 2/3”
You must be logged in to post a review.
There are no reviews yet.