Master Excel Pivot Tables - Excel 365 and Excel 2019

Focused View

Tom Meservy

1:30:57

52 View

01 - Course Overview and Files

001 Introduction.mp4

00:55

002 Course Files.mp4

01:00

002 JonCo-Sales.xlsx

002 Pivot-Tables-Examples.xlsx

02 - Pivot Table Basics

001 Creating a pivot table.mp4

07:08

002 Formatting Data.mp4

01:01

003 Summing values.mp4

00:43

004 Changing Items.mp4

00:44

03 - Value Field Settings - Summarize Values By

001 Overview and Summarize by Count.mp4

02:20

002 Nested Fields.mp4

01:09

003 Nested Fields and Drill Down.mp4

01:44

004 Summarize by Average.mp4

01:22

005 Summarize by Min and Max.mp4

01:48

006 Other Ways to Summarize.mp4

00:59

04 - Selecting, Moving, and Clearing Pivot Tables

001 Selecting, Moving, and Clearing.mp4

01:37

05 - Pivot Table Design

001 Design Overview.mp4

01:47

002 Subtotals and Grand Totals.mp4

01:03

003 Report Layout and Blank Rows.mp4

01:38

06 - Value Field Settings - Show Values As

001 Overview.mp4

01:04

002 % of Another Number.mp4

04:22

003 % of.mp4

01:20

004 % of Parent Total.mp4

01:27

005 Difference From and Rank Order.mp4

02:23

006 Running Totals.mp4

01:55

007 Index.mp4

01:58

008 Practice - % of Another Number - Problem 1.mp4

01:21

009 Practice - % of Another Number - Problem 2.mp4

00:23

010 Practice - % of Another Number - Problem 3.mp4

00:52

011 Practice - % of Another Number - Problem 4.mp4

01:01

012 Practice - Difference From.mp4

00:46

013 Practice - Misc 1.mp4

00:54

014 Practice - Misc 2.mp4

00:32

07 - Filtering

001 Filtering Basics.mp4

01:34

002 Multiple Filters.mp4

00:34

003 Slicers.mp4

01:21

004 Slicer Options.mp4

03:12

005 Timeline.mp4

01:53

006 Timeline Options.mp4

01:14

007 Report Filter Pages.mp4

02:12

08 - Grouping

001 Manual Grouping.mp4

04:40

002 Automatic Grouping.mp4

02:24

003 Automatic Grouping with Ranges.mp4

04:25

09 - Calculated Fields & Items

001 Calculated Fields.mp4

03:20

002 Calculated Items.mp4

04:57

10 - Other Pivot Table Concepts

001 Referencing Pivot Table Cells.mp4

03:06

002 Sparklines.mp4

02:04

003 Pivot Charts.mp4

03:28

004 Refreshing Pivot Table Data.mp4

02:23

11 - Homework Practice Problems

001 Master-Pivot-Tables-Course-Homework-Practice-Problems.xlsx

001 Overview and File.mp4

00:54

Description

Master Microsoft Excel Pivot Tables in an afternoon! Excel 365, Excel 2019, and Excel 2016 Pivot Tables.

What You'll Learn?

Create complex Pivot Tables to answer valuable questions and provide useful insights
Understand how to effectively use Excel Pivot Tables

Who is this for?

Those with some experience with Excel that want to be able to quickly analyze complex data sets to provide useful information

What You Need to Know?

A recent copy of Excel. Course created with Excel 2016 but Excel 2013 or Excel 2010 will work as well.

More details

Description
Do you want to help your company or organization make better decisions? Do you want to advance your career because you bring real value to the organization? Do you want to save hundreds of hours a year in creating reports and charts? Are you ready to make an impact because you understand the patterns and trends in your companyâ€™s data? Do you want to master Excel Pivot Tables? This course is for you!

Master Excel Pivot Tables in this Comprehensive Course

This comprehensive course contains concise illustrations yet detailed topic coverage that will benefit both Beginners and Advanced Users of Excel. In just an hour and a half, you will learn to effectively use Excel Pivot Tables including how to:

Create and Format Pivot Tables
Select, Move, and Clear Pivot Tables
Design Pivot Tables
Value Field Settings â€“ Summarize Values By
Value Field Settings â€“ Show Values As
Filter Data
Manually and Automatically Group Data
Create Calculated Fields and Items
Explore Other Useful Pivot Table Concepts

Learn Pivot Tables by Doing

Learn one of the most powerful features of Excel that will allow you to dig deep into your companyâ€™s data and answer complex questions with only a few mouse clicks. Learn to analyze vast amounts of data, create useful reports, and impress top management or prospective employers.

Most that say they know Excel Pivot Tables really only have a grasp on the basics. Within the first 10 minutes of this course, you will likely surpass their knowledge and by the end of the course you will master even some of the most complex aspects of Pivot Tables.

Throughout the course, you can follow along with the numerous concise examples that illustrate the power and features of Pivot Tables using the included worksheets. Further, â€œhomeworkâ€ examples are provided to allow you to apply these same concepts to another data set so that you can know that you have mastered the concepts.

Create pivot tables from data in an existing worksheet and answer basic questions from the data.
Summarize pivot table values by sum, count, average, max, min, and other types of calculations.
Select different parts of the pivot table, move it within and between worksheets, and clear or reset the contents of the pivot table.
Adjust the design aspects of the pivot table including totals, layout, and visual aspects of the pivot table.
Adjust pivot table calculations to show the results as a percentage of a total, difference from another field, or other value calculation.
Filter data out of the pivot table using various techniques including field filters, table filters, slicers, and timelines.
Automatically and manually group results within your pivot table using a variety of approaches.
Create and utilize new pivot table fields that are calculated using existing data in the pivot table and new items that consist of formulas that refer to other rows.
Appropriately reference pivot table data.
Create pivot charts and understand the relationship between pivot charts and pivot tables.
And More.

We are professional instructors who have helped thousands of students Master Excel Pivot Tables and become even more effective at work. We invite you to join us on a short journey to advance your career.
Who this course is for:
Those with some experience with Excel that want to be able to quickly analyze complex data sets to provide useful information

User Reviews

Rating

average 0

Total votes0

Focused display

I'm a professor of Information Systems. I enjoy extracting business value out of technology. Over the years I have been a software developer, database administrator, systems administrator, systems analyst, and more. I've done training/consulting with Fortune 100 companies and the DOD. I’m the founder of Tech Mountain Consulting that provides world-class training, software development, and consulting. I love the outdoors. I've roasted marshmallows over a volcano!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.