Complete Introduction to Excel Pivot Tables [2022 Edition]

Focused View

Ian Littlejohn

3:59:30

114 View

1 - Introduction

1 - Introduction to the Course.mp4

01:54

2 - About the Course.mp4

01:56

3 - Data.xlsx

3 - Download the course data files.html

4 - Correctly Setup Data.mp4

07:37

2 - Create Pivot Tables

5 - Introduction to Pivot Tables.mp4

00:34

6 - Creating Pivot Tables.mp4

08:45

7 - Working with Multiple Dimensions.mp4

03:43

8 - Working with Multiple Measures.mp4

04:14

9 - Practical Activity Pivot Tables.html

10 - Complete Practical Activities Pivot Tables.mp4

05:24

3 - Methods of Aggregation and Grouping

11 - Introduction to Methods of Aggregation and Grouping.mp4

01:10

12 - Methods of Aggregation.mp4

04:40

13 - Combining Methods of Aggregation.mp4

04:24

14 - Grouping Data.mp4

06:00

15 - Formatting Pivot Tables.mp4

16 - Comparison Graphs.mp4

07:41

17 - Practical Activity Methods of Aggregation.html

18 - Practical Activity Completed Methods of Aggregation.mp4

04:48

4 - Trend and Date Analysis

19 - Introduction to Trend Analysis.mp4

01:05

20 - Grouping Date Fields for Trend Analysis.mp4

05:29

21 - Creating Fields for Trend Analysis.mp4

05:26

22 - Creating Fields for Trend Analysis Part 2.mp4

06:11

23 - Trend Charts.mp4

08:28

24 - Practical Activity Trend Analysis.html

25 - Completed Practical Activity Trend Analysis.mp4

06:06

5 - Filtering and Top 10 Analysis

26 - Introduction to Filtering and Top 10 Analysis.mp4

01:27

27 - Filtering Pivot Tables.mp4

08:00

28 - Top 10 Analysis.mp4

03:04

29 - Report Filters.mp4

04:22

30 - Using Slicers to Filter Data.mp4

08:44

31 - Using Slicers to Filter Multiple Pivot Tables.mp4

06:06

32 - Practical Activity Filtering.html

33 - Completed Activity Filtering.mp4

05:15

6 - Analyzing Data and Calculations

34 - Introduction to Analyzing Data and Calculations.mp4

01:04

35 - Contribution Analysis.mp4

06:13

36 - Contribution Analysis Part 2.mp4

05:40

37 - Pie Charts and Contribution Analysis.mp4

08:01

38 - Difference From and Running Total Calculations.mp4

05:51

39 - Practical Activity Contribution Analysis.html

40 - Completed Practical Activity Analyzing Data.mp4

10:26

7 - Frequency Analysis

41 - Introduction to Frequency Analysis.mp4

00:57

42 - Download the Training Data File.html

42 - EmployeeMaster.xlsx

43 - Frequency Analysis.mp4

07:22

44 - Frequency Analysis and Charts.mp4

03:09

45 - Practical Activity Frequency Analysis.html

46 - Practical Activity Completed Frequency Analysis.mp4

05:27

8 - Conditional Fomatting

47 - Introduction to Conditional Formatting.mp4

01:06

48 - Conditional Formatting using Rules.mp4

06:05

49 - Conditional Formatting using Top 10 Analysis.mp4

03:45

50 - Conditional Formatting using Icons Data Bars and Colour Scales.mp4

08:49

51 - Practical Activity Conditional Formatting.html

52 - Completed Practical Activity Conditional Formatting.mp4

04:35

9 - Interactive Dashboards

53 - Introduction to Interactive Dashboards.mp4

00:38

54 - Practical Activity Human Resource Dashboard.html

55 - Interactive Human Resource Dashboard Part 1.mp4

09:46

56 - Interactive Human Resource Dashboard Part 2.mp4

04:37

57 - Practical Activity Finance Dashboard.html

58 - Interactive Finance Dashboard.mp4

07:27

59 - Interactive Finance Dashboard Part 2.mp4

05:21

10 - Course Conclusion

60 - Course Conclusion.mp4

00:38

Description

Learn to analyze & summarize data in seconds using Excel's most powerful data feature - Pivot Tables & Pivot Charts!

What You'll Learn?

Enjoy CLEAR, CONCISE and LOGICAL step by step instructions from a best selling Excel and Power BI Udemy Instructor
LIFETIME access to course materials and practice activities with a 100% MONEY-BACK guarantee
Learn to use the most POWERFUL tool in Microsoft Excel to easily summarize and create reports from your data
In SECONDS create aggregated and summarized tables of data from VAST quantities of spreadsheet data
At the click of a mouse, create percentages, running totals, difference from and ranking calculations with no formulas!
Learn to use filters and slicers to display INTERACTIVE views of data with no complex coding or VBA
Get COMPREHENSIVE understanding of trends within data with a few clicks of the mouse
Learn to ANALYZE Human Resource data using grouping and frequency analysis

Who is this for?

Excel users who want to learn how to create professional reports

Excel users who want to summarize and aggregate data

Excel users who want to learn new methods and techniques to analyze data

What You Need to Know?

Excel 2016 or above

You should be able to work with data in Excel and do basic reporting

More details

Description
Looking for a course that will get you up and running with Excel Pivot Tables without wasting your time?Â Looking for a course that makes sense and builds your knowledge up in a logical fashion?Â That's exactly what this course delivers.Â Get the crucial foundation you need to become a Pivot Table expert.Â
This course has been updated for 2022 in full HD video quality, so you will learn on the latest Excel interface.
WHATÂ STUDENTSÂ AREÂ SAYING:
"Excellent course, goes over all the options available for working with big sets of data. Being familiar with pivot tables is a must in order to really grasp the formulas required to make this powerful feature a tool ."
"Great course, great teacher...It was above expectations. I really like those little notes how we can do same thing on different ways. Recommend it strongly."
"I just passed my Excel 70-779 test to complete my BI Solutions MCSA . Thank you Ian...watched all your videos on here for both tests."
"Super great course! Gave me all the basics to get started using Power Pivot right away!"
Life time access to course materials and practice activities.
ABOUTÂ THEÂ TRAINER
Ian Littlejohn has been a top-rated trainer on the Udemy platform for over 5 years and has more than 10 years' experience in training & management consulting. He specialises in Data Analysis, covering Excel, Power BI, Google Data Studio and Amazon Quicksight.
Ian has over 150,000 students and with an average course rating of over 4.5. He has a reputation for delivering excellent, logically structured courses which are easy to follow and get the point across without wasting learners' time.
ABOUT THEÂ COURSE
Skills in data analysis, reporting and the creation of dashboardsÂ are HIGHLYÂ valued in today's business environment.Â Excel is now recognized as the most commonly used data analysis tool in the world for the development of reports, data analysis and dashboards.
In this course you will learn the INCREDIBLEÂ power of Pivot Tables to analyze and summarize data in seconds.Â Pivot Tables are without doubt the most powerful feature in Microsoft Excel.Â
In this class you will cover:
Introduction and Course Content
Creating Pivot Tables
Methods of Aggregation and Grouping
Trend Analysis
Filtering and Slicing Pivot Tables
Show Value As Calculations
Frequency Analysis
Conditional Formatting
Interactive Dashboards
Excel and Power BI
We look forward to having you on our course as we learn and explore the incredible power of Excel Pivot Tables and Pivot Charts.
Please note that this course is the third course in a series of three courses for the ExcelÂ Master ClassÂ series.Â Search for my instructor profile to purchase these other courses.
Course 1 - Power Query - Prepare and Transform Data
Course 2 - Power Pivot - Data Modeling and DAXÂ Formulas
Course 3 - Pivot Tables and Pivot Charts
Who this course is for:
Excel users who want to learn how to create professional reports
Excel users who want to summarize and aggregate data
Excel users who want to learn new methods and techniques to analyze data

User Reviews

Rating

average 0

Total votes0

Focused display

Ian is a trainer that specializes in Microsoft Power BI, Excel Pivot Tables, Power Pivot, Power Query, Google Data Studio and AWS QuickSight. Ian is an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of business intelligence tools to easily turn data into insight and intelligence.Ian has been training learners on these powerful technologies for over 10 years making it easy for business users to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data. Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel and Google Data Studio users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools. Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents.

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.