The Complete Microsoft Excel Pivot Tables and Pivot Charts
4.7 /5- Offered byUDEMY
The Complete Microsoft Excel Pivot Tables and Pivot Charts at UDEMY Overview
Duration | 3 hours |
Total fee | ₹1,999 |
Mode of learning | Online |
Credential | Certificate |
The Complete Microsoft Excel Pivot Tables and Pivot Charts at UDEMY Highlights
- Certificate of completion
- 2.5 hours on-demand video
- 6 downloadable resources and 1 article
- Full lifetime access
- Access on mobile and TV
The Complete Microsoft Excel Pivot Tables and Pivot Charts at UDEMY Course details
- For Sales manager
- For Students and Individual
- For Accountants and Auditor
- For Financial analyst
- For Information clerk
- Learner 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?
- Great course with interactive dashboard, pivot charts, pivot table and exercises to help student understand the course
- Learner will learn various data analysis techniques using MS Excel
- 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 Complete Microsoft Excel Pivot Tables and Pivot Charts at UDEMY Curriculum
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
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
BONUS SECTION
BONUS LECTURE
The Complete Microsoft Excel Pivot Tables and Pivot Charts at UDEMY Faculty details
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?