Excel 2016 Pivot Tables: Create Basic Pivot Tables in Excel

Name: Excel 2016 Pivot Tables: Create Basic Pivot Tables in Excel
Rating: 4.6 (5116 reviews)

Pivot Tables in Excel 2016. Learn to create basic Pivot Tables in Excel 2016 with real-life examples.

Created byKawser Ahmed

Last updated 6/2016

English

English [Auto],

What you'll 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

Course content

3 sections • 15 lectures • 1h 7m total length

Welcome to the Course on Excel 2016 Pivot Tables2:11
Master how to create and update basic pivot table reports in Excel 2016, use slicers, prepare data sources, and save time with practical, real-life examples.
Life Before Excel Pivot Tables8:43
Explore life before Excel pivot tables, building region and product level sales reports from a 93,000-row dataset using unique lists, advanced filters, and sum criteria.
Life After Excel Pivot Tables2:26
Master pivot tables in Excel 2016 to create quick reports, summarizing total sales by region using the pivot table fields, with the Canada example.
Download Course Resources from Here0:14

Why Should You Use Excel Pivot Tables?3:01
Learn how pivot tables transform large data sets into meaningful insights, enabling quick categorization, flexible views, and targeted filters like year 2008.
When Should You Use a Pivot Table?4:04
Learn when to use Excel pivot tables to analyze large data sets, reveal relationships and groupings across products, regions, and years, and quickly generate unique value lists and time-based reports.
Anatomy of an Excel Pivot Table4:43
Explore the anatomy of an Excel pivot table by examining the four areas: rows, columns, values, and filters, with practical examples of product sales, regions, and customization.

Preparing Your Data For Excel Pivot Tables4:47
Prepare your data by ensuring a properly structured table with column headings, no blank rows or columns, and correct data types to create accurate pivot tables in Excel 2016.
Summary of Preparing the Data Source for a Pivot Table2:06
Learn the essential rules for preparing a data source for an Excel pivot table, including meaningful column headings, table format, avoiding blanks, and storing dates and numbers properly.
Case Study: Cleaning Up Data for Pivot Table Analysis4:18
Prepare a clean data source for Excel pivot tables by creating missing headers such as product name, region, market, and month, and organize sales data for analysis.
Creating a Basic Pivot Table - Part 16:15
Learn to create a basic pivot table from a data source in Excel 2016, insert it on a new worksheet, and configure fields, layout, and data areas.
Creating a Basic Pivot Table - Part 29:02
Create a basic pivot table by adding fields to rows, columns, and values, then rearrange and filter with slicers by region, state or province, or product category.
Filtering Pivot Tables with Slicers4:17
Master filtering pivot tables with slicers in Excel 2016, adding slicers for account manager and state or province, using multi-select and report connections to sync multiple tables.
Updating Pivot Table Data Sources8:00
Learn how to refresh and update pivot table data sources as your source data grows, including when sources are tables vs. ranges, and enable automatic refresh on open.
Deferring Layout Update, Starting Over with One Click and Relocating Pivot Table3:34
Learn three productivity techniques for Excel 2016 pivot tables: deferring layout updates to pause automatic updates, starting over with one click, and relocating a pivot table to a new location.

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:

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!

Who this course is for:

Data Analysts
Reporting Professionals
Basically for All Excel Users

Excel 2016 Pivot Tables: Create Basic Pivot Tables in Excel

What you'll learn

Explore related topics

Course content

Welcome to the Course!4 lectures • 14min

Excel Pivot Table Fundamentals3 lectures • 12min

Creating a Basic Excel Pivot Table8 lectures • 42min

Requirements

Description

Who this course is for: