Excel pivot tables course PART 2/4 – Free Udemy Courses
Take control of the pivot table or pivot
What you’ll learn
Excel pivot tables course PART 2/4 – Free Udemy Courses
- How to efficiently analyze data in Excel
- How to prepare data for work with a pivot table
- How to filter data
- How to create 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, this is Bartosz from Excel BI Academy. This is a continuation of the first part of the course about PivotTables in Excel. You’ll learn how to filter data in PivotTables. You will also learn the most interesting option for filtering, which are slicers. Next, you will learn how to insert charts in PivotTables with one click, that is, PivotCharts. 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 PivotTables in Excel for many years.
Getting to know PivotTables 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 PivotTables 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.
Who this course is for:
- The course is aimed at both beginners and advanced users of Excel.
- I hope everyone will find something interesting about 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.
Add Comment