Microsoft Excel - All About Pivot Tables
4.4 (45 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.
1,659 students enrolled

Microsoft Excel - All About Pivot Tables

Learn Microsoft Excel's most powerful feature and reduce your working time to minutes from hours.
4.4 (45 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.
1,659 students enrolled
Created by Prashant Lele
Last updated 3/2018
English
English [Auto-generated]
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
  • 3.5 hours on-demand video
  • 4 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
  • Know the use of all the tools / options available inside Pivot Tables
  • Prepare and Maintain proper source data
  • Avoid common mistakes in building of Pivot Tables.
  • Build dynamic dashboards with accompanying charts
  • Identify and rectify erros in existing Pivot Tables.
Requirements
  • Intermidiate Knowledge of MS Excel
  • Basic Analytical Skills like Preparing Data, Sorting, Filtering, etc.
  • Basic Knowledge of writting formulas in MS Excel
  • Have MS Excel 2013 or above installed on your PC
  • Udemy Student Account
Description

WHAT IS A PIVOT TABLE ?

A Pivot Table is a tool which is used to store the summary of a large data set in a condensed manner. Just like any table, the Pivot Table consists of rows, columns, data fields, and pages. These components can be moved around and it helps the user to expand, isolate, sum, and group the particular data in real time. Pivot Table enables the user to view the differences in a very big set of information. It is very helpful in organizing a large amount of data in Microsoft Excel.

Easy to Use

An important advantage of pivot tables is that it is easy to use. You can easily summarize data by dragging the columns to different sections of the table. The columns can also be re-arranged as you wish with the click of a mouse.

Fast Data Analysis

With the help of Pivot Tables, you can handle large quantities of data in one single go. Pivot Tables allow you to take a large amount of data and work on it in such a way that you need to view only a few data fields. This helps in the easy analysis of large amount of data.

Easy Data Summarization.

Another important benefit of pivot tables is that it helps to summarize data in a quick and easy manner. Pivot table helps in making a concise summary out of thousands of rows and columns of unorganized data. With the help of pivot tables you can summarize large amounts of information into a small space. The data can be summarized in a simple format which is easily understandable. Users can arrange rows and columns of the data according to their needs and they can label it and sort it in any way they want to.

Find Trends & Patterns in Transactional Data

Pivot tables help you to create customized tables from large data groups. Manipulating data in this manner will help to find recurring patterns in the data, if any. This in turn will help in accurate data forecast.

Quick Report Creation

One of the important features of excel pivot tables is that it helps to create reports in an efficient way. This saves you the long and strenuous hours that you need to spend for creating reports manually.  Apart from this, the table also helps you provide links to external sources if any, in the report created.

Helps in Decision Making

A pivot table can be considered to be a valuable Excel reporting tool as it allows users to easily analyze the data and arrive at quick decisions. This serves as a huge advantage in the industrial world, where it is crucial to make precise and quick decisions.

If you want to master this one of the most powerful features of Excel, if you want to be ahead of your colleagues, if you want to reduce your working time on MIS reports, if you want to create amazing reports and dashboards from your transactional raw data, then this course is for you. See our promo video for full coverage of the course.


Who this course is for:
  • Who use Excel on Daily Basis
  • Who think Pivot Tables are difficult to understand
  • Who want to learn better tools to prepare reports & dashboards
  • Who want to get on top of the Pivot Table Feature of MS Excel
  • Who want to make use of most powerful utility of Excel - "A Pivot Table"
Course content
Expand all 25 lectures 03:44:25
+ Welcome
1 lecture 03:50

Please take this test to check your current knowledge of Pivot Tables. Once we are through with the course, you can come back and take this test again to see the improvement.

Pre-Training Knowledge Check
9 questions
+ Pivot Tables Fundamentals
5 lectures 18:48
Importance & Usage of Pivot Tables
01:08
Prerequisites of Pivot Tables
05:53
Practice Activity
01:40
+ Building the pivot table
5 lectures 49:42
Building your first pivot table
08:05
Pivot tables terminology
03:06
Layouts of pivot tables
04:38
Summarise values as . . .
06:39
Show values as . . .
27:14
+ Grouping & Filtering
4 lectures 32:57
Cross Tabulation
07:00
Pivot Table Filters
04:57
Slicers & Timelines
12:19
Grouping & Sorting
08:41
+ Pivot Table Calculations
4 lectures 41:16
Pivot Table Cache
15:46
Calculated Fields
06:32
Calculated Items
08:21
GETPIVOTDATA Function
10:37
+ Formating & Presentation
6 lectures 01:17:52
Pivot Table Formating
16:25
Pivot Charts
07:14
Moving & Coping Pivot Tables
04:36
Special Tips & Tricks
12:30
Creating Interactive Dashboard Part 1
01:32
Creating Interactive Dashboard Part 2
35:35