Ultimate Pivot Table Mastery For Excel 2016
4.5 (40 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.
592 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Ultimate Pivot Table Mastery For Excel 2016 to your Wishlist.

Add to Wishlist

Ultimate Pivot Table Mastery For Excel 2016

Master pivot tables with practical examples, real world datasets, assignments, additional bonuses, and more!!
4.5 (40 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.
592 students enrolled
Created by Shafiq Marediya
Last updated 7/2017
English
Current price: $10 Original price: $115 Discount: 91% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 2 Articles
  • 14 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
What Will I Learn?
  • Manipulate data in Excel
  • Use tables as a data source
  • Change the appearance of pivot tables
  • Change the layout of pivot tables
  • Calculate percentages, difference from, and running totals
  • Proficiently use calculated fields
  • Effectively sort and filter data
  • Create slicers using pivot table data
  • Crate Sparkline charts and infograhics using pivot table data
  • Build interactive dashboards with multiple pivot tables
  • Build tables and reports efficiently and effectively
View Curriculum
Requirements
  • You should know how to use simple formatting in Microsoft Excel
Description

Become an advanced pivot table master!

This course covers one of the most used functions in Microsoft Excel. We look at how we can use pivot tables to analyze and summarize data in different ways to gain insight using a real world retail dataset. This course starts off at a very basic level and dives deep into all the capabilities of using a pivot table on a Mac computer. All the lessons are applicable to a windows machine as well.

In each easy to follow video, you will uncover new concepts, techniques, and other powerful features of excel. You will be able to follow along each step of the way, and at the end of each module, you will use another superstore data set to analyze customer payment data.

In this course, we will cover the following:

  • What is a pivot table
  • How to create your own pivot tables
  • Using Excel tables as a data source
  • Summarize data using average and count
  • Formatting pivot tables
  • Creating percentages, difference from, and running totals
  • Sorting and filtering pivot tables using the slicer tool
  • Creating interactive visualizations with sparklines
  • Building infographics with Excel's new plugin
  • Creating interactive dashboards backed with multiple pivot tables
Who is the target audience?
  • Anyone that wants to know how to analyze data using Pivot Tables on Mac
Students Who Viewed This Course Also Viewed
Curriculum For This Course
24 Lectures
01:22:54
+
Introduction To Pivot Tables
6 Lectures 20:05




Bonus Resources
00:10

Taking A Moment
00:16

You are asked by Superstore Shoppers to find out how they can improve their business. They have given you with an excel sheet with over 8,000 rows of data for 3 years. You'll work on this same dataset throughout this course so make sure you really understand the details of it. Good luck!
Assignment 1: Creating Your Own Pivot Table
1 question
+
Customizations and Calculations
5 Lectures 19:33
Introduction to Customizations and Calculations
00:46

Summarizing Data Using Average and Count
04:07

Formatting Pivot Tables
02:57

Creating percentages, difference from, and running totals
08:00

Calculated Fields
03:43

After initial research, you found some interesting insight. Now it's time to dive right in and perform some calculations.
Assignment 2: Customizations and Calculations
1 question
+
Sorting, Filtering, and Using Slicers
4 Lectures 15:57
Introduction to Sorting, Filtering, And Using Slicers
00:50

Sorting Pivot Tables
03:02

Filtering Pivot Tables
05:10

Slicers & Pivot Tables
06:55

With your new found knowledge of slicers, you'll need to organize the data so the owner can see the priority level for each region and product category.
Assignment 3: Sorting, FIltering, and Using Slicers
1 question
+
Data Visualizations
3 Lectures 07:31
Introduction To Data Visualization
00:42

Sparklines & Pivot Tables
03:34

People Graph Infographics
03:15

It's time to help the store owner and his board members look at some of the data visually by creating sparklines and an infographic styled people graph.
Assignment 4: Data Visualization
1 question
+
Creating Data Driven Dashboards
6 Lectures 19:48
Introduction To Dashboards
01:15

Creating Summary Blocks
04:58

Creating An Interactive Line Chart With Pivot Tables
01:32

Creating An Interactive Sparkline Chart
03:41

Adding Additional Data To Pivot Line Chart
03:32

Adding Slicers To Dashboards
04:50
About the Instructor
Shafiq Marediya
4.2 Average rating
188 Reviews
1,553 Students
3 Courses
Instructor and Founder of Learn Analytics.io

Hi, my name is Shafiq Marediya! I am the founder of Learn Analytics, where I teach students to become professional data scientist and data analyst. Professionally, I have worked with data in industries like retail, healthcare, non-profit, finance, and technology. Over my years of studying data, I have covered topics like big data, data warehousing, data analysis with SQL, Excel, Python, and R, and visualizations with Tableau.

Many of the topics I cover in my courses are topics I learned on my own, without formal education. My courses are designed for beginners that have no prior knowledge on the topic. I clearly communicate each topic in a way that anyone can pick it up and start learning today by using the step-by-step approach I used when I was in your shoes. I am passionate about data and want to share my enthusiasm and knowledge with you! 

I hope you enjoy my courses!