Excel Pivot Tables with Excel 2016: From Basic to PowerPivot
4.5 (29 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.
254 students enrolled

Excel Pivot Tables with Excel 2016: From Basic to PowerPivot

Learn Excel Pivot Tables with Excel 2016 from Scratch to Advanced Level with introduction to Power Pivot & DAX Language.
4.5 (29 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.
254 students enrolled
Created by Kawser Ahmed
Last updated 6/2017
English
English [Auto]
Current price: $65.99 Original price: $94.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 1 article
  • 25 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
  • Create a summary report from 1 million rows of transactional data or more
  • Change your analysis on the fly by simply moving fields from one area of a report to another
  • Give a standalone look to your Excel Pivot Table Report
  • Add new fields or items to your pivot table report
  • Make visualizations of your report through Excel PivotChart
  • Analyze data from Microsoft Access, Text files, SQL Server and other sources
  • And you will be able to handle big data using PowerPivot and DAX language.
Requirements
  • Office 2016 ProPlus version installed in the Computer
  • Internet connections
  • Motivation to finish this course
Description

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated:  Nov 01. 2016

Welcome to my course on Excel Pivot Table with Excel 2016. In this course, you will learn Excel Pivot Tables from Scratch to Advanced Level with introduction to Power Pivot & DAX Language.

I am Kawser Ahmed, your instructor with this course. I am a full time Excel, Excel VBA and Data Analytics blogger. And I am a corporate Excel trainer in my own country. Monthly around 15,000 Excel users come to my Excel blog ExcelDemy dot com and read my Excel and data analysis related articles and tutorials.

At the end of this course, you will be able to:

  1. Create a summary report from 1 million rows of transactional data or more
  2. Change your analysis on the fly by simply moving fields from one area of a report to another
  3. Give a standalone look to your Excel Pivot Table Report
  4. Add new fields or items to your pivot table report
  5. Make visualizations of your report through Excel PivotChart
  6. Analyze data from Microsoft Access, Text files, SQL Server and other sources
  7. And you will be able to handle big data using PowerPivot and DAX language.

Let me give you an idea what exact topics I am going to teach you in this course.

  1. I will start with Pivot Table Fundamentals. Topics covered in this section are:
    1. Why and when you will use Excel Pivot Table,
    2. Anatomy of a pivot table,
    3. And limitations of Pivot Table Reports.
  2. In the Create Basic Pivot Table section, topics covered are:
    1. Prepare a data set for Excel Pivot Table,
    2. Create a basic pivot table from that data,
    3. And slicer tool.
  3. In the Customize a Pivot Table section, I will cover the following topics:
    1. Make common cosmetic and major changes to your Pivot Table Report,
    2. Make layout changes,
    3. Customize the pivot table appearance with Styles and Themes,
    4. Change summary calculations,
    5. Add and remove subtotals,
    6. And how to use Running Total, % Of, and other Rank Options.
  4. In the Grouping, Sorting and Filtering Pivot Data section, I will teach you these topics:
    1. Group pivot fields,
    2. And sort and filter a pivot table.
  5. In the Performing Calculations within Pivot Tables section: I will introduce you with:
    1. Calculated Fields and Items,
    2. Their rules and shortcomings,
    3. And how to manage and maintain pivot table calculations.
  6. In the Analyze Disparate Data Sources with Pivot Tables section, I will show you:
    1. How to use multiple consolidation ranges,
    2. And how to build pivot table using external data sources.
  7. And at the end of the course, I will introduce you with PowerPivot and DAX Language. Using PowerPivot, you can handle millions of rows data in lightning speed.

I have designed this course for regular Excel users who want to boost up their office productivity, especially for professionals who make stunning and dynamic reports every day. 

But if you are already known with Excel Pivot table but want to get used to with Excel 2016 Pivot table features, then this course is also for you. This course will give you a simple but powerful introduction to the most powerful tool in Excel. 

Feel free to take a look at the free previews of this course. I hope this course will change your view about Excel Pivot Table. Enjoy the course and thanks for reading.

Who this course is for:
  • Regular Excel users who want to boost up their office productivity
  • Professionals who make stunning and dynamic reports every day
  • Professionals using old versions of Excel and want to practice Excel Pivot Tables with Excel 2016
Course content
Expand all 31 lectures 02:55:49
+ Excel Pivot Table Fundamentals
4 lectures 17:51
Why Should You Use Excel Pivot Tables?
03:01
When Should You Use a Pivot Table?
04:04
Anatomy of an Excel Pivot Table
04:43
Limitations Of Pivot Tables & Working in Compatibility Mode
06:03
+ Creating a Basic Excel Pivot Table
8 lectures 42:19
Preparing Your Data For Excel Pivot Tables
04:47
Summary of Preparing the Data Source for a Pivot Table
02:06
Case Study: Cleaning Up Data for Pivot Table Analysis
04:18
Creating a Basic Pivot Table - Part 1
06:15
Creating a Basic Pivot Table - Part 2
09:02
Filtering Pivot Tables with Slicers
04:17
Updating Pivot Table Data Sources
08:00
Deferring Layout Update, Starting Over with One Click and Relocating Pivot Table
03:34
+ Customizing an Excel Pivot Table
6 lectures 31:18
Overview of the section
00:24
Making Common Cosmetic Changes to Your Pivot Table Report
07:40
Making Layout Changes of Your Pivot Table Reports
09:16
Customizing the Pivot Table appearance with Styles and Themes
04:22
Changing Pivot Table Summary Calculations
05:30
Adding & Removing Subtotals from a Pivot Table Report
04:06
+ Grouping, Sorting and Filtering Pivot Table Data
3 lectures 19:11
Grouping Fields in Excel Pivot Tables
07:50
Looking at the Pivot Table Field Lists
05:57
Sorting in a Pivot Table
05:24
+ Mashing Up Data with Power Pivot
4 lectures 18:28
Benefits and Drawbacks of Power Pivot
04:27
Installing Power Pivot to the Tab List
02:02
Building a Power Pivot Report - Part 1
07:54
Building a Power Pivot Report - Part 2
04:05
+ Enhancing Pivot Table Reports with Macros
3 lectures 31:56
Creating a Scroll Bar in Excel
10:04
Creating a User Interface with Form Controls Part 1
11:54
Creating a User Interface with Form Controls Part 2
09:58