Disclosure: when you buy through links on our site, we may earn an affiliate commission.

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.7
4.7/5
(35 reviews)
271 students
Created by

7.7

CourseMarks Score®

4.0

Freshness

9.2

Feedback

9.2

Content

Platform: Udemy
Video: 2h 55m
Language: English
Next start: On Demand

Table of contents

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:
•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.Let me give you an idea what exact topics I am going to teach you in this course.
•I will start with Pivot Table Fundamentals. Topics covered in this section are:•Why and when you will use Excel Pivot Table,•Anatomy of a pivot table,•And limitations of Pivot Table Reports.•In the Create Basic Pivot Table section, topics covered are:•Prepare a data set for Excel Pivot Table,•Create a basic pivot table from that data,•And slicer tool.•In the Customize a Pivot Table section, I will cover the following topics:•Make common cosmetic and major changes to your Pivot Table Report,•Make layout changes,•Customize the pivot table appearance with Styles and Themes,•Change summary calculations,•Add and remove subtotals,•And how to use Running Total, % Of, and other Rank Options.•In the Grouping, Sorting and Filtering Pivot Data section, I will teach you these topics:•Group pivot fields,•And sort and filter a pivot table.•In the Performing Calculations within Pivot Tables section: I will introduce you with:•Calculated Fields and Items,•Their rules and shortcomings,•And how to manage and maintain pivot table calculations.•In the Analyze Disparate Data Sources with Pivot Tables section, I will show you:•How to use multiple consolidation ranges,•And how to build pivot table using external data sources.•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.

You will 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

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
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 100,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 contact me.
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 2h 55m
Language: English
Next start: On Demand

Students are also interested in