The Complete Microsoft Excel Pivot Tables and Pivot Charts
4.2 (182 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
24,573 students enrolled

The Complete Microsoft Excel Pivot Tables and Pivot Charts

Data analysis with Excel Pivot Table,Reporting with Pivot table, Excel Dashboard, Power Pivot, Excel Basic Statistic
4.2 (182 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
24,573 students enrolled
Last updated 4/2020
English
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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?
Requirements
  • No prior Excel knowledge is needed
  • Installed Microsoft Excel
Description
  • 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.


Who this course is for:
  • Sales manager
  • Students
  • Individual
  • Accountants
  • Auditor
  • Financial analyst
  • Information clerk
Course content
Expand all 23 lectures 02:27:28
+ CHAPTER -03 CREATE PIVOT TABLE AND FORMAT VALUES IN EXCEL
2 lectures 15:29
CREATE THE PIVOT TABLE IN EXCEL
11:38
FORMAT VALUES IN PIVOT TABLE
03:51
+ CHAPTER-05 REPORT FILTER AND REFRESH PIVOT TABLE IN EXCEL
2 lectures 08:25
REPORT FILTER PIVOT TABLE IN EXCEL
04:32
REFRESH PIVOT TABLE IN EXCEL
03:53
+ CHAPTER-06 CREATE DYNAMIC DASHBOARD & PIVOT CHARTS FROM PIVOT TABLE
6 lectures 44:29
CREATE COLUMN CHART -CLUSTERED COLUMN
06:13
CREATE PIE CHART - DOUGHNUT CHART
07:19
CREATE COLUMN CHART - 3D COLUMN CHART
08:22
CREATE LINE CHART- LINE WITH MARKERS CHART
08:51
INSERT SLICER
07:29
+ CHAPTER -07 MANAGING PIVOT TABLES
6 lectures 10:28
CONNECTING TO AN EXTERNAL DATA SOURCE
02:02
CREATING A RECOMMENDED PIVOT TABLE
01:22
COPY AND MOVE PIVOT TABLES
01:53
DELETE THE PIVOT TABLES
01:04
CLEARING & REAPPLYING PIVOT TABLES
01:59
COPY THE VALUES ONLY FROM PIVOT TABLE
02:08
+ CHAPTER-08 COMPLETE PIVOT TABLES AND PIVOT CHARTS EXERCISES WITH ANSWERS
3 lectures 46:03
CHAPTER-08 COMPLETE EXERCISES QUESTIONS ONE TO SEVEN
20:52
CHAPTER-08 COMPLETE EXERCISES QUESTIONS EIGHT TO FOURTEEN
12:48
CHAPTER-08 COMPLETE EXERCISES QUESTIONS FIFTEEN TO SEVENTEEN
12:23