Udemy

Platform

English

Language

Microsoft

Category

The Complete Microsoft Excel Pivot Tables and Pivot Charts

Excel Charts, Excel Analytics, Excel Pivot Table , Excel Pivot Charts, Excel Dashboard, Excel Data Analysis & Reporting

4.46 (472 reviews)

Students

2.5 hours

Content

Jan 2021

Last Update
Regular Price

EXCLUSIVE SKILLSHARE OFFER
Exclusive  SkillShare  Offer
Unlimited access to 30 000 Premium SkillShare courses
30-DAY FREE TRIAL

What you will learn

What Is Pivot Table and Pivot Charts and Key Benefit of Pivot Table?

How to Normalize the Data for Pivot Table?

How to Convert Normal Data to Table?

How to Create the Pivot Table in Excel?

How to Format Values in Pivot Table?

How to Expand and Collapse Pivot Table in Excel?

How to Report Filter Pivot Table in Excel?

How to Refresh Pivot Table in Excel?

How to Create Bar Chart by Using Pivot Table?

How to Create Column Chart by Using Pivot Table?

How to Create Pie Chart by Using Pivot Table?

How to Create 3D Column Chart by Using Pivot Table?

How to Create Line Chart by Using Pivot Table?

How to Insert Slicer?

How to Connect to an External Data Source in Excel?

How to Create a Recommended Pivot Table?

How to Copy and Move Pivot Tables?

How to Delete the Pivot Table?

How to Clearing & Reapplying Pivot Table?

How to Copy the Values Only from Pivot Table?


Description

Recent Student's Reviews

***It Is Very Helpful And Easy To Understand. I Have No Doubts Regarding Pivot Tables And Its Formatting After Going Through It. Thank You For The Wonderful Teaching And Technical Support. - Deepak Kumar Kanaujia***


***Very Detailed Illustration And The Instructor Knows Well How To Use His Tools. Happy To Attend This Course And I Believe I Am Gonna Use It A Lot In My Work. - Mohamed Eltantawi***


***Wonderful Course. I've Been Using Excel For Many Years. But, What I've Learned In This Course Is A Paradigm Shift. - Yousuf Saif Al Hinai***


***Wow! Its Amazing Pivot Tables Course. I've Lots Of Gap On This Topic. Now, I've Clear Concept. - Md. Anisur Rahmen***


Nine Reasons why you should choose this The Complete Microsoft Excel Pivot Tables and Pivot Charts Course


  1. Best Rated Course on Udemy

  2. You will learn various data analysis techniques using MS Excel

  3. Latest updated and Doubts Are Solved in this course

  4. Carefully designed curriculum By Proficient In Microsoft Excel Expert

  5. you can complete this course In Short time

  6. Pivot table & Pivot charts related examples and case studies Provided

  7. 06 Examples And  practice exercises Are Able to Download in The Recourse Section

  8. Your queries will be responded by the Instructor With In Short time

  9. A Verifiable Certificate will Be Provided On the Completion


Microsoft Excel's Pivot table and Pivot charts are  The Powerful Tools to Analysis And Manipulating the data . it helps to Analysis the data in different perspective to take importance and Essential decision making in the organization. The pivot tables and pivot chats help to calculate, summarize the data very quickly. Pivot Tables Allow to see comparisons, patterns, and trends by using our data. The Course Contents Eight Chapters & The Details As Below.


What is covered in this course?


CHAPTER -01 INTRODUCTION TO PIVOT TABLES & PIVOT CHARTS

  • Introduction To Pivot Tables & Pivot Charts

CHAPTER -02 FORMAT DATA FOR PIVOT TABLES IN EXCEL

  • Normalize The Data For Pivot Table

  • Convert Normal Data To Table

CHAPTER -03 CREATE PIVOT TABLE AND FORMAT VALUES IN EXCEL

  • Create The Pivot Table In Excel

  • Format Values In Pivot Table

CHAPTER -04 EXPAND AND COLLAPSE PIVOT TABLE IN EXCEL

  • Expand And Collapse Pivot Table In Excel

  • CHAPTER-05 REPORT FILTER AND REFRESH PIVOT TABLE IN EXCEL

  • Report Filter Pivot Table In Excel

  • Refresh Pivot Table In Excel

CHAPTER-06 CREATE DYNAMIC DASHBOARD & PIVOT CHARTS FROM PIVOT TABLES

  • Create Bar Chart -Clustered Bar

  • Create Column Chart -Clustered Column

  • Create Pie Chart - Doughnut Chart

  • Create Column Chart - 3d Column Chart

  • Create Line Chart- Line With Markers Chart

  • Insert Slicer

CHAPTER -07 MANAGING PIVOT TABLES

  • Connecting To An External Data Source

  • Creating A Recommended Pivot Table

  • Copy And Move Pivot Tables

  • Delete The Pivot Tables

  • Clearing & Reapplying Pivot Tables

  • Copy The Values Only From Pivot Table

CHAPTER-08 COMPLETE PIVOT TABLES AND PIVOT CHARTS EXERCISES WITH ANSWERS

  • Complete Exercises Questions One To Seven

  • Complete Exercises Questions Eight To Fourteen

  • Complete Exercises Questions Fifteen To Seventeen

Go ahead and click the enroll button, and I'll see you in Chapter 1!

Cheers

A.M.A.M.Mubeen


Screenshots

The Complete Microsoft Excel Pivot Tables and Pivot Charts
The Complete Microsoft Excel Pivot Tables and Pivot Charts
The Complete Microsoft Excel Pivot Tables and Pivot Charts
The Complete Microsoft Excel Pivot Tables and Pivot Charts

Content

CHAPTER -01 INTRODUCTION TO PIVOT TABLES & PIVOT CHARTS

INTRODUCTION TO PIVOT TABLES & PIVOT CHARTS

CHAPTER -02 FORMAT DATA FOR PIVOT TABLES IN EXCEL

NORMALIZE THE DATA FOR PIVOT TABLE

CONVERT NORMAL DATA TO TABLE

CHAPTER -03 CREATE PIVOT TABLE AND FORMAT VALUES IN EXCEL

CREATE THE PIVOT TABLE IN EXCEL

FORMAT VALUES IN PIVOT TABLE

CHAPTER -04 EXPAND AND COLLAPSE PIVOT TABLE IN EXCEL

EXPAND AND COLLAPSE PIVOT TABLE IN EXCEL

CHAPTER-05 REPORT FILTER AND REFRESH PIVOT TABLE IN EXCEL

REPORT FILTER PIVOT TABLE IN EXCEL

REFRESH PIVOT TABLE IN EXCEL

CHAPTER-06 CREATE DYNAMIC DASHBOARD & PIVOT CHARTS FROM PIVOT TABLE

CREATE BAR CHART -CLUSTERED BAR

CREATE COLUMN CHART -CLUSTERED COLUMN

CREATE PIE CHART - DOUGHNUT CHART

CREATE COLUMN CHART - 3D COLUMN CHART

CREATE LINE CHART- LINE WITH MARKERS CHART

INSERT SLICER

CHAPTER -07 MANAGING PIVOT TABLES

CONNECTING TO AN EXTERNAL DATA SOURCE

CREATING A RECOMMENDED PIVOT TABLE

COPY AND MOVE PIVOT TABLES

DELETE THE PIVOT TABLES

CLEARING & REAPPLYING PIVOT TABLES

COPY THE VALUES ONLY FROM PIVOT TABLE


Reviews

F
Faaiz20 May 2021

The knowledge of the presenter is good. The course delivery could have been better if the pronounciation of the presenter would have been more clear.

D
Devesh24 April 2021

This course is for someone who is very very new to pivot tables, as in this course one is only told about the Pivot table, Pivot chart creations and then finally copying them

M
Muhammad25 November 2020

Instructors knowledge about this topic is astonishing , He provide detailed information about each and every aspects of topic very clearly,Precisely Thanks to Mr Mubeen For offering such as wonderful course.

M
Mohamed6 November 2020

Very detailed illustration and the instructor knows well how to use his tools. Happy to attend this course and I believe I am gonna use it a lot in my work.

A
Audrey24 October 2020

have found a mistake on the slides and can't even pronounce 'pivot' table. I also find his accent hard to understand at times

Y
Yousuf11 October 2020

Wonderful course. I've been using Excel for many years. But, what I've learned in this course is a paradigm shift.

D
Deepti1 September 2020

Too much basic stuff which is not needed and repeating information. The course is too slow Also the instructor could have better english

N
Ngome19 August 2020

Absolutely it is where I can use multiple sorts by using the Plus sign. it will save me time and I will do it properly now. I have a wider understanding of Pivot Tables now even with the use of Charts

S
Swechha14 July 2020

It was a great learning!! I really enjoyed each and every ounce of it. I would really appreciate if a dummy excel sheet could be shared with the students to practice the session and become master in it.

R
Rajesh27 May 2020

100% Recommended course for who are looking for Advanced excel courses, Thankss Udemy for such a great course

D
Deepak8 April 2020

It is very helpful and easy to understand. I have no doubts regarding pivot tables and its formatting after going through it. Thank you for the wonderful teaching and technical support.

M
Manish3 April 2020

Hello....this is Manish Panwar. Before watching this video i have only rough idea about PIVOT but as i completed the session, just understood the multiple use & various functionality of PIVOT to improve analysis of database. Thanks a lot sir. Requesting you to provide more sessions like this.

S
Shivraj2 April 2020

key Shortcuts of Excel which are been taken in making the tables should also be Introduces/repeated in the lesson. ctl+alt+T // ctrl+D // etc...

A
Ashkan31 March 2020

that was so easy ! with nonfunctional examples trainer could set more samples and he could save time in explaining details


Coupons

DateDiscountStatus
3/31/2020100% OFFExpired
4/20/202095% OFFExpired
5/16/202095% OFFExpired
5/21/202095% OFFExpired
6/14/2020100% OFFExpired
6/19/2020100% OFFExpired
7/14/2020100% OFFExpired
7/27/2020100% OFFExpired
8/6/2020100% OFFExpired
8/18/2020100% OFFExpired
8/25/2020100% OFFExpired
9/3/2020100% OFFExpired
9/12/2020100% OFFExpired
9/24/2020100% OFFExpired
10/3/2020100% OFFExpired
10/10/2020100% OFFExpired
10/17/2020100% OFFExpired
11/2/2020100% OFFExpired
11/13/2020100% OFFExpired
11/22/2020100% OFFExpired
12/1/2020100% OFFExpired
12/15/2020100% OFFExpired
12/24/2020100% OFFExpired
1/1/2021100% OFFExpired
1/26/2021100% OFFExpired
1/29/202150% OFFExpired
2/12/2021100% OFFExpired
2/21/2021100% OFFExpired
3/5/2021100% OFFExpired
3/13/2021100% OFFExpired
3/23/2021100% OFFExpired
4/6/2021100% OFFExpired
5/9/2021100% OFFExpired
5/18/2021100% OFFExpired
5/23/2021100% OFFExpired
6/3/2021100% OFFExpired
6/7/2021100% OFFExpired

2905398

Udemy ID

3/24/2020

Course created date

3/31/2020

Course Indexed date
Lee Jia Cheng
Course Submitted by

Twitter
Telegram