Udemy

Excel 2016 Pivot Tables: Create Basic Pivot Tables in Excel

Name: Excel 2016 Pivot Tables: Create Basic Pivot Tables in Excel
Availability: InStock
Rating: 4.5 (5100 reviews)

4.5(5,100)71k students

Korshub's take

A Focused Introduction to Excel Pivot Tables

Taught by Kawser Ahmed, an Excel and data-analytics trainer, this course narrows in on one specific skill: building and updating basic pivot table reports in Excel 2016. It's a deliberately scoped course rather than a full Excel curriculum, aimed at getting the core concept to click quickly.

Who It's For

Newcomers to pivot tables who have never built one before, as well as intermediate Excel users who want to properly understand Excel 2016's pivot table feature rather than using it by trial and error.

Key Takeaways

When and why a pivot table is the right tool for a given dataset
How to prepare a data source correctly before building a pivot table
Creating and updating a basic pivot table report step by step
An introduction to the Slicer tool for filtering pivot table data
Time-saving techniques for working with pivot tables more efficiently

The course stays close to fundamentals, making it a practical entry point before moving on to more advanced pivot table features.

About this course

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:

You will be able to create and update basic pivot table reports using Excel 2016,
You will be able to realize, why and when you can best use of Excel Pivot Table tool,
You will be get used to with the features of an Excel Pivot Table Report
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.

I will show you the exact cases when you can use the Excel Pivot Table
Then I will show you the anatomy of a pivot table report with a real life example.
Then you will see the step by step by process of preparing a data source for Excel Pivot table
Then you will learn how to create and update a basic pivot table report
Then you will be introduced with the Slicer tool in Excel
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!