HOT
blank

Excel Pivot Tables course Part 2/3

Office Productivity

Rating4.6
Free Enroll Now

Excel Pivot Tables course Part 2/3, available at Free, has an average rating of 4.55, with 21 lectures, based on 141 reviews, and has 5167 subscribers.

You will learn about 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 This course is ideal for individuals who are The course is aimed at both beginners and advanced users of Excel. or I hope everyone will find something interesting in it. or There are no prerequisites for the course as the pivot table is a standalone functionality. or Few formulas appear in the course, and all options are discussed in detail. or Usually, a pivot table is taken by users who have a basic understanding of Excel and formulas. It is particularly useful for The course is aimed at both beginners and advanced users of Excel. or I hope everyone will find something interesting in it. or There are no prerequisites for the course as the pivot table is a standalone functionality. or Few formulas appear in the course, and all options are discussed in detail. or Usually, a pivot table is taken by users who have a basic understanding of Excel and formulas.

Enroll now: Excel Pivot Tables course Part 2/3

Summary

Title: Excel Pivot Tables course Part 2/3

Price: Free

Average Rating: 4.55

Number of Lectures: 21

Number of Published Lectures: 21

Number of Curriculum Items: 21

Number of Published Curriculum Objects: 21

Original Price: Free

Quality Status: approved

Status: Live

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

Who Should Attend

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

Target Audiences

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

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

Course Curriculum

Chapter 1: Filtering a PivotTable

Lecture 1: 5.1. Filters shelf

Lecture 2: 5.2. Rows and columns filter – text, date, number

Lecture 3: 5.3. Value filter and TOP N filter

Lecture 4: 5.4. Generate report filter pages

Lecture 5: 5.5.Slicer

Lecture 6: 5.6.Timeline

Lecture 7: 5.7. DIY: Week slicer

Chapter 2: PivotChart

Lecture 1: 6.1.Column chart

Lecture 2: 6.2. Line chart

Lecture 3: 6.3.Combo chart and other charts

Lecture 4: 6.4. DIY: Combo chart

Chapter 3: Show values ​​as

Lecture 1: 7.1. % of Grand total

Lecture 2: 7.2. % of Row total

Lecture 3: 7.3. % of Parent total

Lecture 4: 7.4. Year-on-Year % change

Lecture 5: 7.5. Running total

Lecture 6: 7.6. DIY: Show values as

Chapter 4: Calculated field

Lecture 1: 8.1.Calculated field – multiplication

Lecture 2: 8.2.Calculated field – division

Lecture 3: 8.3.Rounding and list of formulas

Lecture 4: 8.4. DIY: Calculated field

Instructors

Rating Distribution

  • 1 stars: 2 votes
  • 2 stars: 0 votes
  • 3 stars: 10 votes
  • 4 stars: 57 votes
  • 5 stars: 72 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Chatgpt And Ai Tools Courses to Learn in November 2024

Top 10 Excel Vba Courses to Learn in November 2024

Digital Marketing Foundation Course