Excel Pivot Tables course Part 2/3

Dashboards with pivot tables

4.69 (127 reviews)
Udemy
platform
English
language
Microsoft
category
4,703
students
2 hours
content
Nov 2022
last update
FREE
regular price

What you will learn

How to create pivot charts

How to build dashboards with pivot tables

How to use slicers

How to format the layout ot the pivot table

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. 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

Content

Filtering a PivotTable

5.1.Shelf filters
5.2.Row and column filter - text, date, number
5.3.Value filter and TOP N filter
5.4.Generate report pages
5.5.Slicer
5.6.Timeline
5.7.Slicer after weeks - independent exercise

PivotChart

6.1.Column chart
6.2.Line graph
6.3.Combo chart and other charts
6.4.Combo chart - independent exercise

Show values ​​as

7.1.% Share of total
7.2.% Share on the line
7.3.% Share of the parent
7.4.% Change compared to the previous year
7.5.Running sum
7.6.Show values ​​as - independent exercise

Calculated field

8.1.Calculated field - multiplication
8.2.Calculated field - division
8.3.Rounding and list of formulas
8.4.IF formula - Individual exercise

Screenshots

Excel Pivot Tables course Part 2/3 - Screenshot_01Excel Pivot Tables course Part 2/3 - Screenshot_02Excel Pivot Tables course Part 2/3 - Screenshot_03Excel Pivot Tables course Part 2/3 - Screenshot_04

Reviews

Nancy
September 27, 2023
Good match, the lesson kept stopping and then I would have to wait a for few seconds before the lesson would start up again.
Cao
July 7, 2023
Really great course with huge, advanced topic for Pivot Tables Enjoy & learn much in short time. Highly recommend
Juraj
January 2, 2023
Very good and enjoyed every part of it. Only one thing is more practice will be great with more exercises but as a free course amazing and thank you very much.
Nelio
September 20, 2022
I'm enjoying. I like the way the presenter details all aspects related to data analysis using Pivot Table

Charts

Price

Excel Pivot Tables course Part 2/3 - Price chart

Rating

Excel Pivot Tables course Part 2/3 - Ratings chart

Enrollment distribution

Excel Pivot Tables course Part 2/3 - Distribution chart

Related Topics

4640602
udemy ID
4/13/2022
course created date
5/27/2022
course indexed date
Bot
course submited by