Practical Excel 2016 Pivot Tables and Pivot Charts
4.2 (96 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.
745 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Practical Excel 2016 Pivot Tables and Pivot Charts to your Wishlist.

Add to Wishlist

Practical Excel 2016 Pivot Tables and Pivot Charts

Become indispensable at work! Become a power user and earn a huge raise by working Pivot magic in Excel.
4.2 (96 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.
745 students enrolled
Created by Optima Train
Last updated 2/2016
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • An understanding of how pivot tables allow you to break down numerical data by categories, something other Excel tools can do, but not nearly so quickly or easily
  • How to build pivot tables by clicking and dragging
  • An understanding of the advantages of using Excel tables as a basis for pivot tables
  • How to base pivot tables from an external source or an Excel data model
  • How to build pivot charts, which are automatically synchronized with the corresponding pivot tables
  • How to sort and filter in pivot tables
  • Methods for grouping categories, especially dates, with many categories in pivot tables
  • An understanding of the role of pivot caches for extremely fast pivot table calculation
  • How conditional formatting in pivot tables provides even more insightful reports
  • How to create calculated items and calculated fields for pivot tables
  • How to use pivot tables for finding unique values, creating histograms, and classification (learning which variables are related to a Yes/No variable)
View Curriculum
Requirements
  • Microsoft Office 2016
Description

This course provides an in-depth coverage of pivot tables and pivot charts in Excel 2016. These are two of the most powerful, if not the most powerful, data analysis tools in Excel's arsenal, and they should definitely be mastered by anyone who aspires to becoming an Excel “power user." As this course will illustrate with many examples, the tools are surprisingly easy to learn and use—once you know they exist. To learn Excel Pivot Tables & Pivot Charts quickly and effectively, download the companion exercise files so you can follow along with the instructor by performing the same actions he is showing you on the videos.

***** THE MOST RELEVANT CONTENT TO GET YOU UP TO SPEED *****

***** CLEAR AND CRISP VIDEO RESOLUTION *****

***** COURSE UPDATED: February 2016 *****

“The Optima Train two part series on Pivot Tables is pure gold! The material is so amazingly thorough and clear that anyone watching the videos and doing the exercises provided will without a doubt become a true expert at working with Pivot Tables and likely become a hero at work by applying and sharing this new-found knowledge. There is nothing like it on the market." - Phil, FORMER TREASURY OPERATIONS MANAGER - EXXONMOBIL

“When I first looked up this site I was a bit skeptical, but I soon realized how amazing these courses are. They have helped me excel in all my business classes. The PowerPivot course now makes business analytics easy and at my fingertips." - Wilson Xu, STUDENT

90% of Excel users do not use Pivot Tables but those that do save hours of time and become valuable assets in their companies. The hours of time you'll save translates to real money in your pocket of earning potential! Imagine the power you will have as a knowledge worker in your company that people go to when they need help. Upper management will notice your sharp analysis and will not be able to do without you. Pivot Tables has been called the best thing since sliced bread. Once you start using it you'll never stop. Pivot Tables and Pivot Charts are not difficult to learn and it's bewildering that not many people use it – you can take advantage of that short supply of power users in the workforce by becoming a power user yourself and an indispensable resource to your work place. Simplify your work and personal life by learning this extremely useful tool.

This is the most comprehensive Excel Pivot Tables & Pivot Charts course and has 43 short video tutorials. The follow-on course of PowerPivot & Advanced Business Intelligence Tools builds on where this course ends. There is zero fluff and no time wasted in this course. The instructor, Dr. Chris, has decades of experience using Excel in real-world settings solving complex business problems. There is no quicker way to learn Excel than to watch these videos and follow along with the free companion exercise workbooks which are downloadable. If you want to stand out among your colleagues, earn a promotion, further your professional development, save tons of hours every year, and learn Excel Pivot Tables & Pivot Charts in the quickest and simplest manner then this course is for you!

You'll have lifetime online access to watch the videos whenever you like, and there's a Q&A forum right here on Udemy where you can post questions.

Who is the target audience?
  • Any competent Excel users who want to take their Excel data analysis skills to a whole new level
Students Who Viewed This Course Also Viewed
Curriculum For This Course
48 Lectures
03:36:37
+
Introduction to Course
3 Lectures 05:30

How to download Exercise Files and Handouts
00:23

REMINDER: Turn on HD
1 page
+
Why Pivot Tables?
2 Lectures 11:42
+
Creating a Pivot Table
9 Lectures 47:11
Data Structure for Pivot Tables
04:29

Creating a Pivot Table
06:05

Pivot Charts
05:18

Pivot Table Layouts
05:11

Excel Tables
06:37

Pivot Tables Based on a Table
03:29

Pivot Tables Based on External Data
04:56

Pivot Tables Based on a Data Model 1
08:25

Pivot Tables Based on a Data Model 2
02:41
+
Basic Pivot Table Tools
15 Lectures 01:10:26
Pivot Table Fields Pane Options
04:21

Placing Fields in a Pivot Table
04:13

Multiple Fields in the Values Area
03:16

Value Field Settings for a Numeric Field
04:30

Displaying Counts in a Pivot Table
06:17

Show Values As Options
05:05

Filtering and Collapsing on Row and Column Fields
05:18

Field Settings for a Categorical Field
04:22

Sorting in Pivot Tables
04:43

Sorting with a Custom List
02:44

More Filters for Row and Column Fields
06:14

Slicers for Filtering
06:48

Styles for Pivot Tables and Charts
03:33

Grouping by Category
04:53

More on Grouping by Date
04:09
+
Other Pivot Table Tools
15 Lectures 01:06:01
Pivot Cache
05:28

Converting a Pivot Table to Static Values
01:51

Grouping by Selection
04:38

Showing Report Filter Pages
02:51

Displaying Cells with No Data
02:31

PivotTable Options Dialog Box
03:02

Selecting, Copying, Moving, Clearing, Deleting a Pivot Table
03:20

Refreshing a Pivot Table
04:33

Avoiding Pivot Cache Sharing
02:41

Conditional Formatting in Pivot Tables
06:12

Calculated Fields
07:23

Calculated Items
05:31

Formulas Referencing Pivot Table Cells
02:51

Using GetPivotData for Custom Reports
07:43

Efficiency Tips for Pivot Tables
05:26
+
Selected Uses of Pivot Tables
3 Lectures 11:54
Finding Unique Values with a Pivot Table
03:56

Creating a Histogram with a Pivot Table
02:55

Using Pivot Tables for Classification
05:03
+
Conclusion to Course
1 Lecture 02:54
About the Instructor
Optima Train
4.3 Average rating
579 Reviews
4,741 Students
25 Courses
Practical Training for Today's Knowledge Worker

Optima Train is a US-based training company using cutting-edge adult learning methodology to make our customers more effective in the workplace.

Optima Train has the most comprehensive coverage of content created by experts with deep knowledge of how applications are used in the workplace.

We are intricately linked to our customers. While most training companies have a tool-centric approach that leads to relatively low knowledge retention, Optima Train has a results-oriented approach.