Power Pivot in Microsoft Excel 2016
2.6 (81 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.
15,275 students enrolled

Power Pivot in Microsoft Excel 2016

You will be learning about all the techniques of Power Pivot of excel and what are its usages & benefits.
2.6 (81 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.
15,275 students enrolled
Last updated 2/2019
English
English [Auto-generated]
Current price: $71.99 Original price: $119.99 Discount: 40% off
23 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.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
  • Knowing excel is must in this world and this course will help you to work with data more effectively
  • This course will help you to learn from the scratch level about excel its basic & advanced functions.
Requirements
  • A PC with Microsoft Excel 2016
  • A computer with internet to view training material
  • Basic knowledge on Excel
Description

This course will help you to learn from the scratch level about excel its basic & advanced functions. In this course of Power Pivot in Excel you will be learning how to import millions of rows of data from multiple data sources into a single excel workbook. Knowing excel is must in this world and this course will help you to work with data more effectively. You will be learning in-detail about all the techniques of Power Pivot of excel and what are its usages & benefits. This course will help you to know how power pivot will help to analyze the comprehensive data to make timely business decisions.

Who this course is for:
  • Students, MBA’s, BBA’s, Graduates & Post- graduates.
  • Working Professionals from any business domain.
  • Entrepreneurs, Prospective Finance Analyst, Market Analyst, Research Analyst, Investment Banker
Course content
Expand all 21 lectures 03:20:18
+ Formatting and Pivot Chart Example
4 lectures 45:10
Data Formatting
11:53
Pivot Chart Example 1
12:26
Pivot Chart Example 2
11:41
Pivot Chart Example 3
09:10
+ Pivot Table Example
2 lectures 23:28
Creating Pivot Table
12:06
Adding Min and Max Value
11:22
+ Pivot Table and Pie Chart Example
9 lectures 01:26:43
Pivot Table and Pie Chart
11:53
Pivot Table and Pie Chart Continues
10:09
Insert Function and Formula
10:44
Pivot Table Field
06:30
Pivot Table Analysis
10:47
Creating One to One Relationship
10:15
One to One Relationship Continues
08:54
Loan Applicants Analysis
11:26
Loan Applicants Analysis Continues
06:05
+ Inserting slicer
4 lectures 29:38
Inserting slicer
10:27
More on Inserting slicer
04:06
Insert Loan Status
07:53
Add Literacy and Province
07:12