Mastering Pivot Tables To Analyze Business Data in Excel
4.0 (8 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.
48 students enrolled

Mastering Pivot Tables To Analyze Business Data in Excel

How to Use the Power of Excel Pivot Tables to Analyze Business Data Quickly for Better Business Decisions
4.0 (8 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.
48 students enrolled
Created by Vinai Prakash
Last updated 6/2019
English
English [Auto]
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 1 downloadable resource
  • 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
  • Master Pivot Tables for analyzing data and converting it into actionable information
  • Find simple ways to look the the same data in different ways & gather insights
Requirements
  • Basic Knowledgo Excel. Familiar with Excel Version 2007, 2010, 2013, Excel 2016 or Office 365
Description

This course is designed for people familiar with Excel and who want to learn how to analyze data within Excel. We will use the in-built Pivot Table tool, and show how to use the tool, and how to go beyond the basics, to more advanced functionality to analyze data, performing complex calculations, and be able to turn data into actionable information easily.

It is meant for the data warriors to learn the Advanced Excel techniques of Pivot Tables to make sense of huge amount of data in Excel, and be able to create simple management reports which compare data as Percentages, perform year or year, quarter on quarter comparisons etc.

Who this course is for:
  • Beginners to Pivot Tables
  • People who know pivot tables, but want to take their knowledge further and use advanced features of Pivot Tables
Course content
Expand all 9 lectures 01:24:01
+ Course Overview
1 lecture 04:48

A short introduction to the training program, and what you will learn in the step by step lessons of analyzing data with Excel Pivot Tables.

Preview 04:48
+ Pivot Table Basics
3 lectures 34:50

Understand the basics of Pivot Tables. What is a pivot table, how do you create one, and how to navigate your way in your first pivot table. Covers the basics.

Preview 14:57

Apply Simple Formatting to make the Pivot table more readable, and more presentable.

Preview 10:22

Customize the presentation of the pivot - Fill any blanks cells with zeros, change summary calculations... Display Sum, Count, Average etc.

Preview 09:31
+ Enhancing a Pivot Table
3 lectures 26:02

Add Sub Totals for categories, sub categories for easier analysis, and to simplify a large pivot table.

Adding SubTotals in a Pivot Table
06:20

Sort Pivot data in Ascending, Descending, and Manual Sorting in Unique ways, which are neither ascending nor descending.

Preview 06:20

Filter the data to display any unique category, set of dates, or even part of a description. Useful to display data in unique ways.

Filtering Pivot Data in Unique Ways
13:22
+ Analyzing Data With Pivot Tables
2 lectures 18:21

Create new computed items based of existing values. This can add additional benefit and analyze data with new calculations not even present in the original data.

Adding New Calculations with Calculated Fields
08:06

Converting data into Percentage is the first step to analyze any simple or large complex set of data. Everyone understands percentages, and it is one of the easiest ways to impress anyone with useful insights about your data from this simple nugget of information!

Analyze Data with Percentages
10:15