Master Pivot Tables - Introduction and Masterclass
4.9 (6 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.
55 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Master Pivot Tables - Introduction and Masterclass to your Wishlist.

Add to Wishlist

Master Pivot Tables - Introduction and Masterclass

Create data analysis in Excel using Pivot Tables with just a few clicks, together with summary Pivot Charts. Exam 70-779
4.9 (6 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.
55 students enrolled
Created by Phillip Burton
Last updated 5/2017
English
Current price: $10 Original price: $45 Discount: 78% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • 8 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create Pivot Tables with a just a few clicks, simply and quickly.
  • Maintain and expand Pivot Tables.
  • Update data sources, and maintain formatting during refreshes.
  • Create Pivot Charts in a few simple clicks.
  • Know and use about the more advanced features, and create advanced Pivot Tables.
  • Find out how much powerful it is, and how quickly it can improve your data analysis.
View Curriculum
Requirements
  • You should be able to open and save Microsoft spreadsheets. You should also be able to enter data.
  • That's it! We'll create our first Pivot Table in just a couple of minutes - that's all.
Description

Review:

"The knowledge of the teacher is impressive, and he knows how to teach. The speed of the course is just right. And going thru the exercises after each one is great. I only have one word for the teacher and the way he's presenting the course WOW!!!" -- Daniel Sandberg

This course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES.

It sounds difficult, but in fact can be done in just a few clicks. We'll do our first one in a couple of minutes - that's all it takes. We'll also add a chart as well in that time.

After only these first few minutes, you will be streets ahead of anyone who doesn't know anything about Pivot Tables - it is really that important.

After this introduction, we'll go into some detail into how to set up your Pivot Table - the initial data, and the various options that are available to you. We will go into advanced options that most people don't even know about, but which are very useful.

By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you'll be able to help others with their data analysis.

It will assist with the Visualize Data section of the Microsoft exam 70-779 "Analysing and Visualizing Data with Microsoft Excel".

Who is the target audience?
  • This is for you if you have ever heard of the "Pivot Table", but didn't know what it is or how to use it.
  • This is also for you if you use PivotTables, and want to go deeper. Much deeper. :-)
  • We'll also go into the more advanced functions, and create charts as well, quickly and easily.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
80 Lectures
05:53:27
+
Introduction
3 Lectures 07:45

Before we start, let's have a quick look around Udemy, and find out how you can get in touch with me.

Introduction to Udemy
02:13

+
Creating our first PivotTable and PivotChart
6 Lectures 23:47

Our first PivotChart
02:35

PivotTable Menus
05:35

PivotChart Menus and An Introduction to Practice Activity 1
03:13

Practice Activity Number 1
00:08

Answer to Practice Activity 1
04:29
+
Expanding our PivotTable
9 Lectures 33:33
Source data requirements
04:30

Adding additional values
05:01

Recommended PivotTables
03:30

Moving PivotTable
03:21

Refresh PivotTable - why it doesn't auto-update
06:21

Extracting data
05:03

Sorting
03:31

Let's practice what you have learned.

Practice Activity Number 2
00:25

Answer to Practice Activity 2
01:51
+
Going deeper in our PivotTable
14 Lectures 57:15
Adding additional row fields
02:28

Different layouts – Compact, Outline and Tabular
06:38

Blank Rows
03:05

Group Records
04:43

Showing or hiding additional detail - the +/- buttons
04:17

Adding columns
05:05

Adding page fields
02:50

Adding filters
09:35

Changing source
03:55

Using a table source
04:07

Final options
03:43


Practice Activity Number 3
00:31

+
Modify field selections
9 Lectures 44:57
Change aggregate (COUNT, MIN, MAX)
08:26

Repeat All
05:35

Using Conditional Formatting to hide Repeat All
03:43

Grand Totals
04:54

Adding subtotals
09:07

Show items with no data
05:38

Other field settings
05:01

Let's see what you've just learned.

Practice Activity Number 4
00:15

Answers to Practice Activity 4
02:18
+
PivotTable Options
7 Lectures 36:06
Layout
09:13

Totals & Filters, and Alt Text
04:40


Print
04:52

Data
11:24

Let's see if you can find my favorite options :-)

Practice Activity Number 5
00:14

Answers to Practice Activity 5
02:09
+
Slicers (Excel 2010 and later)
6 Lectures 22:59
Create slicers
03:08

Identifying impossible options, and selecting more than one option at once.
04:59

Join to multiple PivotTables
05:45

Options
04:57

Let's see what you have learnt about slicers.

Practice Activity Number 6
00:35

Answer to Practice Activity 6
03:35
+
Dates and Timeline
5 Lectures 20:28
Aggregates
04:13

Group by time period
05:39

Timelines
06:16

Practice Activity Number 7
00:30

Answer to Practice Activity 7
03:50
+
Formatting
10 Lectures 58:13
Formatting number values
03:58

Custom Formatting - number formatting
11:45

Custom Formatting - dates and text
09:06

Custom Formatting - sections and colors
08:26

Conditional Formatting - Highlighting cells
05:32

Conditional Formatting - Data Bars and Color Sets
06:32

Formatting printing
04:48

Styles
04:09

Practice Activity Number 8
00:16

Answer to Practice Activity 8
03:41
+
Advanced calculations
7 Lectures 37:14
Percentage of total
07:59

Percentage of total - Advanced
06:02

Cumulative totals
05:20

Index
04:49

Difference from
03:11

Calculated fields
04:10

Calculated Items
05:43
2 More Sections
About the Instructor
Phillip Burton
4.4 Average rating
3,224 Reviews
45,474 Students
25 Courses
Best Selling Instructor - over 45,000 students so far

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.

He enjoys investigating data, which allows me to maintain up to date and pro-active systems to help control and monitor day-to-day activities. As part of the above, he also developed and maintained a Correspondence Database in Microsoft Access and SQL Server, for viewing job-related correspondence (110,000 pdfs in one job) by multiple consultants and solicitors.

He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.

He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.

His interests are working with data, including Microsoft Excel, Access and SQL Server.