Excel Pivot Tables Data Analysis Master Class
4.3 (54 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.
560 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Pivot Tables Data Analysis Master Class to your Wishlist.

Add to Wishlist

Excel Pivot Tables Data Analysis Master Class

Excel at Excel Pivot Tables. Learn to create pivot-table and pivot-chart reports using Excel for data analysis.
4.3 (54 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.
560 students enrolled
Created by Igor Ovchinnikov
Last updated 4/2016
English
Current price: $10 Original price: $85 Discount: 88% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.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?
  • Learn to create pivot table and pivot chart reports in Excel
  • Use Excel pivot tables tools for data manipulatiion and data analysis in Excel
  • Hone your analytical skills using Excel Pivot Tables and Pivot Charts
  • Multiply productivity when working in Excel pivot tables
  • Save time in Excel by using built-in Excel pivot table functionality
  • Master data presentation by using Excel Pivot Tables
View Curriculum
Requirements
  • An open mind and willingness to learn.
  • Access to a computer with Microsoft Excel installed.
Description

Greetings! 

I am super-excited to invite you to “Excel Pivot Tables Data Analysis Master Class”

As an Excel user, you simply must learn how to create Pivot Tables. Seriously, there is no better way to instantly sky-rocket your employability than to master Pivot Tables. 

Nothing comes close. Especially if you have to crunch large data sets and perform data analysis.

In fact, lacking this crucial skill is like leaving a wide-gaping hole in your professional defenses. 

It keeps you exposed to an equivalent of a nasty sucker punch. A disaster waiting to happen: a bleeding nose, a bruised ego, and a brutally murdered professional reputation.

That’s why savvy Excel users quickly discover that they need to learn how to use pivot tables ASAP.

This Pivot Tables on-line training will teach you exactly how to tightly fill that gap, bullet-proof your Excel skill set, and boost your career to new heights.

It teaches you how to create and use pivot tables for maximum benefit.

So you are ready to tackle any sneaky data-analysis situation as a world-class, mega-skilled Excel ninja.

I am introducing to you this super-easy-to-follow Excel Pivot Tables tutorial, where you’ll learn this powerful, but somewhat hidden functionality. 

Now, what shall you expect from this course?

When you enroll, you’ll discover that this is not a regular on-line tutorial course where some starched up instructor keeps selling you their “expertise”. 

No way!

Since my early days as an Excel trainer, I learned what works and what doesn’t in teaching software.

That’s why, in this course, I teach you as a friend. You should expect a casual conversational style, clear explanations, and a pleasant learning experience.

My focus is to help you learn Excel in an easy and comfortable way. 

From the very instant you enroll, I’ll gently lead you step by step through the most essential Pivot Tables techniques.Your learning curve will be astonishingly nice and smooth. 

As you go through the course, I’ll provide answers to your most burning questions. Such as:

  • How do I prepare my dataset for pivot tables analysis?
  • How do I create a pivot table?
  • What is a pivot table and what is it used for?
  • How do I create a pivot chart?
  • How can I create a calculated field
  • How do I create a calculated item?
  • How do I extract data from a pivot table?
  • How do I format a pivot table?
  • How can I create a Pareto Chart using pivot tables?
  • And more…

I will be the needle, you will be the thread. As you follow me along, you’ll be more and more comfortable with Pivot Tables.

Together we are just about to:

1) Learn how to quickly and easily create actionable pivot table reports.

2) Discover how to use pivot tables for data manipulation and data extraction.

3) Quickly fix data in Excel, so you are ready for analysis.

4) Become adept at the art and science of Pivot Table data crunching.

5) Quickly transform your raw data into useful, actionable information reports.

6) Impress your boss and your colleagues with your newly acquired and highly polished skills.

7) Acquire proven strategies, Excel tips and tricks, so you are mega-proficient at any task.

8) Excel at Excel in general, with or without pivot tables.

And (again) much more…

There are several reasons why it’s prudent for you to develop these skills: 

1) Availability, 2) Power and flexibility, 4) Speed.

Let me quickly explain…

1) You want to learn Pivot Tables simply because they are available to you right now.

Think about it. Let’s say, you are already using Excel to create stunning spreadsheets. You may be comfortable with formulas and functions. You know how to do formatting - to make your workbooks look top-notch professional, but you don’t know how to use Pivot Tables. 

Why not? After all they are already there for you benefit. There is nothing extra to install. They are part of Excel.

What would you say to a carpenter, who is using only manual tools and ignores the electrical ones? Would you hire someone who uses a hammer instead of a nail gun - because he never took the step to learn how to use it?

Pivot Tables are available for your benefit to learn immediately - they are already in your tool box. Learn them! Otherwise, you’ll never discover what you are missing.

2) You need to learn Pivot Tables because of their unmatched power and flexibility.

Pivot Tables is a kick-ass, flexible reporting tool. 

If you’ve ever had to run a report from a database, chances are, it struck you as being a bit fixed. It reflects the mindset of whoever created it. It may not be exactly what you want form the start. Of course, if you want, you can create your own report, but it will take time. With Pivot Tables, you can change things on the fly. You can experiment. It takes minutes, or even seconds. You can modify things at (almost) the speed of light. If you know how.

You can quickly format your reports exactly the way you (or your bosses) want. It will dramatically improve your productivity and creativity when working with data. 

In this course, I’ll reveal to you what massive difference it makes. Believe me, it feels like freedom. 

3) It’s crucial for you to learn Pivot Tables to become instantly and infinitely more productive.

When you go though this course, you’ll realize that without Pivot Tables, certain tasks would have taken weeks or even months to accomplish.

It’s amazing. I’ve actually met Excel users who were - oblivious to the existence of Pivot Tables - scrambling for weeks to consolidate data into a report. With Pivot Tables you can crank the same task in a matter of minutes. 

Don’t be them - learn the right way (the Pivot-Tables way). You life will never be the same.

Pivot Tables is your secret weapon. As you learn it, you’ll be astonished and pleased every step of the way. When you have learned it - it’ll help you succeed. 

It’s gonna be great! When you are ready, enroll in this course and let’s begin!

Igor Ovchinnikov

P.S. Important warning! 

After you have perused this course, your skills will be on a much higher level than those of many of your colleagues. Fundamentally, you’ll “leave them all in the dust” - skill-wise. 

You’ll be much faster and more efficient at many Excel tasks then most of them. 

People don’t like that. They will get nervous and threatened. Be careful!

There are two things you can do to soothe their sorrows. 

1) Share this course with them, so they can also get to your level. It will be a very classy gesture on your part. They will appreciate you even more.

2) Be very gentle with them when demonstrating the superior knowledge and power that you accumulated in this course. Try not to destroy their ego. You wouldn’t want them to feel inferior to you, would you? Be nice. 

P.P.S. There are no prerequisites for this course, but it will be easier for you if you already know the most important Excel concepts. If you are a beginner, I highly recommend to take my “Basic Excel Tutorial - Jumpstart Training Course” before you enroll in this course right here.

Who is the target audience?
  • Excel users who need to quickly analyze data.
  • Everyone looking for better ways in Excel.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
58 Lectures
04:31:00
+
First Things First
3 Lectures 10:28


A few thoughts on how you can get the most benefit by taking this course.

Preview 02:47
+
Without Any Further Ado
5 Lectures 34:21

Here we start to learn about the power of Pivot Tables and create the first one.

Preview 10:04

Pivot Tables are vulnerable to the junk in junk out principle. In this lecture we learn about the importance of having a good data and go through some examples. Of course, we keep learning how to create Pivot Tables.

Importance Of Good Data
07:19

Pivot Tables are based on data sources. We learn about adding data to an existing data source and become familiar with various issues of it.

Adding Data To The Data Source
05:03

Here we learn about creating a Pivot Table report based on a so-called Excel Table.

Using Excel Table As A Data Source
09:06

Here we add some data to an existing Excel Table and discover what it means to our existing Pivot Tables.

Adding Data To An Excel Table
02:49
+
Let's Play With Some Of The Tools
3 Lectures 21:50

In this video we go through the Pivot Table Design contextual tab on the ribbon.

Design Contextual Tab Overview
12:34

Here we talk about prevention your pivot table report from updating for the time being.

Defer Layout Update
03:19

Here we take a closer look at the Pivot Table Builder -- that is where the Pivot Table Fields are.

Pivot Table Builder Overview
05:57
+
Grouping Fields
3 Lectures 12:22

Grouping is an extremely powerful part of Pivot Tables. We begin talking about grouping dates.

Grouping Dates
04:34

Here we continue to learn about grouping and take a look at grouping numbers.

Grouping Numbers
03:12

Grouping by selection. This is another awesome possibility that provides lots of flexibility.

Grouping By Selection
04:36
+
Filtering
2 Lectures 07:55

Timeline
04:15
+
Expanding Our Knowledge
8 Lectures 38:55

Here we look at how we can use Pivot Table to quickly count things.

Counting With Pivot Tables
03:46

Pivot Tables is not only about powerful reports, they are also an awesome data extraction tool. Here we learn how to use it.

Pivot Tables As Data Extraction Tool
04:01

After we create our Pivot Table report, it can live happily without the underlying data source. We explore such interesting approach in this video lesson.

Look Ma - No Data Source!
03:43

In this video lesson we take the first look at other ways to show our data in Pivot Tables.

Show As....
03:35

We can do calculations in Pivot Tables too! You learn about calculated fields and create the first one in this lesson.

Calculated Field
04:01

Calculated Item is another type of calculation from which you can benefit in Pivot Tables. An extra tool in your toolbox.

Calculated Item
09:58

When we begin using Pivot Tables, sometimes we do not know exactly what kind of report we want. The new Recommended Pivot Tables feature gives you an easy start. We explore this feature in this lesson.

Recommended Pivot Tables
04:00

A Pivot Chart is a visual presentation of your Pivot Table Report. Here we take our first look at them.

Pivot Charts
05:51
+
Data Analasys: List Of Woman-Owned Retail Businesses Of Seattle
9 Lectures 47:47

We begin working on a real data set. This is the first assignment.

Data Fix: Homework Assignment
01:40

Here I tell you what I think about the data set that we are working with and show you how to fix it.

Data Fix: Solution
14:46

We continue working on our Woman Owned Retail Businesses data set. I give you the further assignment in this video.

Analysis - Homework
02:49

We go through creating the first report based on the Woman Owned Seattle Retail Businesses list.

Count By Congressional District Report
07:01

We quickly nail the Top Ten Zip Codes report.

Top Ten Zip Codes Report
05:44

We re-create the Top 10 Industries report.

Top Ten Industries Report
04:14

Now it is time to create a report where we count all the businesses that have a small-business designation and the ones that do not. Very easy!

Small Businesses Count Report
02:57

Here we prepare an easy report in which we compare how many businesses have a fax number and how many do not.

Fax or No Fax Report
04:39

Here we prepare a quick cross-tab report that counts businesses registered as Woman-Owned by Month and Year.

Count By Month And Year Report
03:57
+
Data Analysis: Per Capita GDP By State
11 Lectures 39:57

In this video lesson we take the first look at one more real-life data set. It contains United States per capita GDP data by state. Is this data set ready for Pivot Tables?

Data Fix: Homework
01:00

Here we fix our data set and prepare it for Pivot Tables.

Data Fix: Solution
05:20

Average-Highest-Lowest Report - Homework
00:57

Average-Highest-Lowest Report - Solution
04:35

Percent Of DC Report - Homework
01:09

Percent Of DC Report - Solution
03:03

USA Overall vs. DC Report - Homework
00:57

USA Overall vs. DC Report - Solution
06:07

Percent Difference From 1997 Report - Homework
01:43

Percent Difference From 1997 Report - Solution
06:57

Additional Thoughts On The Data Set
08:09
+
Data Analysis: USA Car Crash Data
11 Lectures 44:43
Data Set Fix - Homework
00:54

Data Set Fix - Solution
06:24

Additional Thoughts On Car Crash Data
07:43

Accidents & Fatalities Monthly Report - Homework
00:50

Accidents & Fatalities Monthly Report - Solution
09:54

Accidents & Fatalities By Age - Homework
00:52

Accidents & Fatalities By Age - Solution
05:43


By Age And Gender - Solution
05:02


Drug-Related By Gender - Solution
05:32
+
Extra Lectures
1 Lecture 11:01
QQQ Stock Data Set
11:01
1 More Section
About the Instructor
Igor Ovchinnikov
4.5 Average rating
416 Reviews
5,738 Students
10 Courses
Helping you learn fast, so you can do your job well.

Hi, I am Igor Ovchinnikov.

Welcome to my profile page. This is where you normally get to learn about me and read something like this:

“Igor Ovchinnikov is a corporate trainer with over 10 years of experience. He lives in San Francisco and provides excellent training-delivery services to clients all over the Bay Area. He has delivered training for Apple Computers, Stanford University, University of California, Google, Boston Scientific, Altera, Stryker Endoscopy, Air Liquide, BAE Systems, City of San Francisco, Anritsu, Genentech, Novartis, Bayer, Systron Donner, and many others. 

Mr. Ovchinnikov holds an MBA from the Ohio State University.”

Well, frankly, I always have some serious cognitive dissonance whenever I have to write about myself in the third person like this. It’s a bit silly - don’t you agree? So, enough of this out-of-body talk!

First of all, you probably don’t care about me that much. Second, you are probably more interested in why you should buy my courses and what’s in them for you? You may be more interested in how my teaching is different compared to the other great instructors out there?

I have to confess, it is something I've been wondering about too. You know, when someone asks you what you are good at, it’s tough to answer that. Especially, because when you are really good at something, you don’t really perceive it as a big deal. Don’t you agree? Think of something you do really well. Now, do you really work hard on it, or does it come kind of naturally?

So, to answer this question to myself, I recently decided to ask my students. Most of the ones I polled are employees of just one organization where I teach - Stanford University, so the research sample may not be fully scientific. Anyway, I asked a few dozens of my students what they liked best about my teaching style. It was really surprising, that most of them told me that their favorite part was how clear things became after I explained it to them. One of them said literally: “You are a great explainer. It was so confusing before, and now I finally understand it!” 

I think, here’s what I can promise you when you enroll in my courses. I promise you clear explanations, so that things will be no longer confusing.

So, here’s my value proposition to you:

When you enroll in my courses and go through the material, you should expect clear explanations that will help you learn and build your skills fast, so you can succeed at your job. 

If that is the experience that you are interested in, simply enroll in my courses below.