Excel Pivot Tables with Excel 2016: From Basic to PowerPivot
3.4 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
72 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Pivot Tables with Excel 2016: From Basic to PowerPivot to your Wishlist.

Add to Wishlist

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.
3.4 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
72 students enrolled
Created by Kawser Ahmed
Last updated 6/2017
English
Current price: $12 Original price: $95 Discount: 87% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 1 Article
  • 25 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I 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.
View Curriculum
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 is the target audience?
  • 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
Compare to Other Pivot Tables Courses
Curriculum For This Course
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:19
Overview of the section
00:25

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
About the Instructor
Kawser Ahmed
4.4 Average rating
1,586 Reviews
41,576 Students
11 Courses
Founder ExcelDemy.com | Data Analyst

Love to see you here!

I am Kawser Ahmed, father of two beautiful angels (Marissa and Arissa), a full-time data analysis blogger (using Excel & other tools), corporate Excel trainer, & entrepreneur.

I love to make courses in the combination of both theory and practice.

Monthly 30,000 Excel users visit my Excel blog ExcelDemy (follow the website link in the profile).

I love to learn and teach (teaching from my eighteen)!

Visit my blog!

You will find plenty of useful posts, articles, video tutorials, and important Excel resources.

What I love most is: add some value to people around me, believe me!

Here are some of my working areas:

  • 1. Corporate Budgeting, Planning & Forecasting
  • 2. Mission-critical financial processes
  • 3. Month-end close processes
  • 4. Big Data Analysis using Excel
  • 5. Company Reports (Sales, Marketing, Administrative)
  • 6. Large Projects using Excel VBA
  • 7. Dashboard Design using Excel
  • 8. And Basic Accounting


I am always around you to help and support! 

Just knock me!