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.8 (22 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.
413 students enrolled
$50
Take This Course
  • Lectures 58
  • Contents Video: 4.5 hours
    Other: 1 min
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2014 English

Course Description

From creating your first pivot table in Excel, to becoming a pivot table expert there is a path of learning and experimenting. Microsoft Excel is one the most widely used data analysis tools in business today. Excel pivot tables is undeniably the most powerful part of Excel. If you have ever had a data set to analyze and spent time wondering what you can do with it, then Excel pivot tables is your friend and this Excel course is for you.

When you enroll in and complete this Excel Pivot Tables Data Analysis course, you will know how to:

1) Quickly and easily create and format impressive pivot table and pivot chart reports in Excel.

2) Use Excel pivot tables as a data manipulation and data extraction tool.

3) Learn to fix data in Excel and prepare your Excel data sets for pivot table data analysis.

4) Become proficient with the art of Excel 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, tips, and techniques in Excel.

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

After this course you will not be able to:

1) Understand how you managed to live without Excel pivot tables all this time.

There are no prerequisites for this course, but it will be easier for you if you already know the most important Excel concepts. My course Microsoft Excel Without Pain is advised for those who are new to Excel.

This Excel Pivot Tables course is primarily based on video materials and is a learn-by-doing kind of experience. It is designed to make it easy for you to follow and to re-create all of the presented pivot-table based solutions, so that you get the maximum benefit by the end of this class. We are using pivot tables in Excel 2013 in this class.

This Excel course is one of the Easy Excel With Igor series. The other high quality Excel tutorials include:

"Microsoft Excel Without Pain" that helps you quickly build your foundation skills in Excel;

"Data Manipulation In Excel" allowing you to save up to 90% of time when using Excel for certain data management tasks;

"Excel Conditional Formatting Master Class" where you can learn how to improve your spreadsheets using conditional formatting in Excel;

"Microsoft Excel Charts Master Class" that builds your skills in creating your skills in Excel charts and graphs.

What are the requirements?

  • An open mind and willingness to learn.
  • Access to a computer with Microsoft Excel installed.

What am I going to get from this course?

  • Learn to create pivot table and pivot chart reports in Excel 2013
  • 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

What is the target audience?

  • Excel users who need to quickly analyze data.
  • Everyone looking for better ways in Excel.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: First Things First
Welcome!
Preview
01:44
Navigating Udemy Course Interface
Preview
05:57
02:47

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

Section 2: Without Any Further Ado
10:04

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

07:19

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.

05:03

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.

09:06

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

02:49

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

Section 3: Let's Play With Some Of The Tools
12:34

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

03:19

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

05:57

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

Section 4: Grouping Fields
04:34

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

03:12

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

04:36

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

Section 5: Filtering
Slicing Your Report
Preview
03:40
Timeline
04:15
Section 6: Expanding Our Knowledge
03:46

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

04:01

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

03:43

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.

03:35

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

04:01

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

09:58

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

04:00

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.

05:51

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

Section 7: Data Analasys: List Of Woman-Owned Retail Businesses Of Seattle
01:40

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

14:46

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

02:49

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

07:01

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

05:44

We quickly nail the Top Ten Zip Codes report.

04:14

We re-create the Top 10 Industries report.

02:57

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!

04:39

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

03:57

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

Section 8: Data Analysis: Per Capita GDP By State
01:00

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?

05:20

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

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
Section 9: Data Analysis: USA Car Crash Data
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 - Homework
Preview
00:55
By Age And Gender - Solution
05:02
Drug-Related By Gender - Homework
Preview
00:54
Drug-Related By Gender - Solution
05:32
Section 10: Extra Lectures
QQQ Stock Data Set
11:01
Section 11: Wrapping up!
Thank you
Preview
00:56
Bonus Lecture: Special Offers
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Igor Ovchinnikov, Learn It Your Way!

I love creating on-line courses. It has been my favorite pastime since 2013. I love the independent nature of this activity. There is so much to learn!

Independence is what I value most. I am an independent instructor – a free-lance instructor. My on-line courses are not the only thing that I do. I also teach in a classroom setting. My corporate clients hire me to conduct training for their employees. It is my main job: classroom and face-to-face training – as a free-lance of course. I have been in the training business for over 10 years.

I live in San Francisco and, naturally, most of my clients come from the Silicon Valley and from the Bay Area but not only from here. My corporate clients often ask me to travel to conduct training for them.

I have done training for many organizations for over 10 years. Among the more prominent are: 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. There are too many to list all of them here.

I am also a faculty of the American Management Association and conduct many of their training seminars – both public and private, or on-site. When I am not creating my on-line courses, I teach for one of these, or other fine companies.

I teach a broad range of topics. Such as Software, Project Management, Strategic Planning, Strategic Thinking, Business Creativity, Leadership, Communication, Negotiation, Sales, and Public Speaking. I do hold an M.B.A. from Ohio State University, and am a PMI®-certified Project Management Professional (PMP®).

Ready to start learning?
Take This Course