Excel 2016 Pivot Tables: Create Basic Pivot Tables in Excel
4.4 (654 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.
12,740 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 Pivot Tables: Create Basic Pivot Tables in Excel to your Wishlist.

Add to Wishlist

Excel 2016 Pivot Tables: Create Basic Pivot Tables in Excel

Pivot Tables in Excel 2016. Learn to create basic Pivot Tables in Excel 2016 with real-life examples.
4.4 (654 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.
12,740 students enrolled
Created by Kawser Ahmed
Last updated 6/2016
English
English [Auto-generated]
Price: Free
Includes:
  • 1 hour on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Know the Importance of Excel Pivot Tables
  • Know the Spheres where Excel Pivot Tables Best Serve
  • Create and Update a Basic Excel Pivot Table
  • Know about Slicer in Excel
  • Customize an Excel Pivot Table
View Curriculum
Requirements
  • Office 2016 Installed in the Computer
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 “Excel 2016 Pivot Table” course where you will learn how to create basic pivot tables.

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 and read my Excel and data analysis related articles and tutorials.

At the end of this course:

  1. You will be able to create and update basic pivot table reports using Excel 2016,
  2. You will be able to realize, why and when you can best use of Excel Pivot Table tool,
  3. You will be get used to with the features of an Excel Pivot Table Report
  4. And you will be able to handle the limitations and compatibility issues related Pivot tables.

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

  1. I will show you the exact cases when you can use the Excel Pivot Table
  2. Then I will show you the anatomy of a pivot table report with a real life example.
  3. Then you will see the step by step by process of preparing a data source for Excel Pivot table
  4. Then you will learn how to create and update a basic pivot table report
  5. Then you will be introduced with the Slicer tool in Excel
  6. And at the end of the course, I will show you total three techniques that you can use to will save your time when you’re working with Excel Pivot tables.

I have designed this course for new comers in Excel pivot table feature. But if you are an intermediate level user and want to be get used to with Excel 2016 Pivot table feature, 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?
  • Data Analysts
  • Reporting Professionals
  • Basically for All Excel Users
Compare to Other Excel Courses
Curriculum For This Course
15 Lectures
01:07:42
+
Welcome to the Course!
4 Lectures 13:36
Welcome to the Course on Excel 2016 Pivot Tables
02:11

Life Before Excel Pivot Tables
08:43

Life After Excel Pivot Tables
02:26

Download Course Resources from Here
00:16
+
Excel Pivot Table Fundamentals
3 Lectures 11:48
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
+
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
About the Instructor
Kawser Ahmed
4.4 Average rating
1,578 Reviews
41,452 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!