HOT
blank

Excel Pivot Tables Course Part 3/3

Office Productivity

Rating4.6
Free Enroll Now

Excel Pivot Tables Course Part 3/3, available at Free, has an average rating of 4.6, with 33 lectures, based on 69 reviews, and has 4317 subscribers.

You will learn about 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 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 3/3

Summary

Title: Excel Pivot Tables Course Part 3/3

Price: Free

Average Rating: 4.6

Number of Lectures: 33

Number of Published Lectures: 33

Number of Curriculum Items: 33

Number of Published Curriculum Objects: 33

Original Price: Free

Quality Status: approved

Status: Live

What You Will 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

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

Course Curriculum

Chapter 1: 9.Designing a dashboard on a pivot table – Sales vs Plan

Lecture 1: 9.1. Dashboard part 1 – Sales KPI

Lecture 2: 9.2. Dashboard part 2 – Target realization %

Lecture 3: 9.3. Dashboard part 3 – Sales vs Target by years

Lecture 4: 9.4. Dashboard part 4 – Target deviation %

Lecture 5: 9.5. Dashboard part 5 – Filtering and dashboard design

Chapter 2: 10.Slicers and filtering

Lecture 1: 10.1 Text slicer

Lecture 2: 10.2. Date filter From-To

Lecture 3: 10.3. Fiscal year slicer

Lecture 4: 10.4.Year and month slicer

Lecture 5: 10.5. Last day slicer

Lecture 6: 10.6. DIY: Week of the year slicer

Chapter 3: 11.Advanced calculations in a pivot table

Lecture 1: 11.1. Distinct count

Lecture 2: 11.2. Count in the calculated field

Lecture 3: 11.3. Calculated item

Lecture 4: 11.4. Calculated item on dates

Lecture 5: 11.5. GETPIVOTDATA formula

Lecture 6: 11.6. Sales vs Target as GETPIVOTDATA

Lecture 7: 11.7. Changing the aggregation of the subtotal

Lecture 8: 11.8.Product

Lecture 9: 11.9.Standard Deviation and Variance

Lecture 10: 11.10. Count Numbers

Lecture 11: 11.11. DIY: Selecting a measure from the list

Chapter 4: 12. Advanced Pivot Charts

Lecture 1: 12.1.Histogram in a column-line plot

Lecture 2: 12.2.Conditional formatting

Lecture 3: 12.3.Calendar heat map

Lecture 4: 12.4. Cycle plot

Lecture 5: 12.5.Gantt chart

Lecture 6: 12.6. Constant line

Lecture 7: 12.7.TOP 5 vs Others on the pie chart

Lecture 8: 12.8.Cohort analysis

Lecture 9: 12.9.Scatter plot

Lecture 10: 12.10. Filled map

Lecture 11: The New Excel Learning Curve – Summary

Instructors

Rating Distribution

  • 1 stars: 1 votes
  • 2 stars: 1 votes
  • 3 stars: 5 votes
  • 4 stars: 27 votes
  • 5 stars: 35 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