Microsoft Excel Pivot Table and Analysis Beginner to Pro

Focused View

Kadhiravan Jayachandiran,KultureHire Education

1:33:29

114 View

1 - Introduction

1 - Introduction to the Course.mp4

01:19

2 - Downloadable Practice Files.html

2 - Pivot-Table-Practice-File-Questions.xlsx

3 - Introduction to Pivot Tables.mp4

03:09

4 - Pivot Table Interface and our First Pivot Table.mp4

02:46

5 - How Pivot Table Works.mp4

02:35

2 - Pivot Table Basics

6 - First Pivot Table with a Calculation.mp4

01:51

7 - Different Calculations from the Same Field.mp4

02:59

8 - Using Rows and Columns in Pivot Tables for the Same Field.mp4

02:17

9 - Using Rows and Columns for 2 different fields.mp4

02:17

10 - Managing Labels of a Complex Pivot Table.mp4

01:32

11 - Sorting Values in Pivot Table.mp4

01:44

12 - Label Filtering in Pivot Tables.mp4

01:13

13 - Values Filtering in Pivot Tables.mp4

01:39

14 - Report Level Filters in Pivot Tabels.mp4

01:41

15 - Formatting Values in Pivot Table.mp4

01:45

16 - Managing Date Information in Pivot Tables.mp4

01:56

17 - Moving and Managing Pivot Tables.mp4

01:16

3 - Intermediate Level Pivot Table Situations

18 - Multi Field Calculations in Pivot Tables.mp4

01:54

19 - Top 3 and Bottom 3 in Pivot Tables.mp4

02:54

20 - Changes in the Data Source.mp4

01:48

21 - Adding New Rows of Data to the Pivot Table Manual Method.mp4

02:27

22 - Column Referencing and the Challenges of Blanks.mp4

02:27

23 - Range Vs Table Source for Pivot Tables.mp4

02:55

4 - Advanced Pivot Tables Features

24 - Grouping Data in Pivots.mp4

04:23

25 - Using Slicers to Filter Reports.mp4

04:19

26 - Using Timelines to Filter Reports.mp4

03:15

27 - Pivot Tables Assignment Question.mp4

00:33

28 - Pivot Tables Assignment Answer.mp4

06:25

29 - Answer File for Pivot Tables So far.html

29 - Pivot-Table-Practice-File-Answers.xlsx

5 - Complex Calculations with Pivot Table

30 - Advanced-Pivot-Table-Practice-File-Questions.xlsx

30 - Practice file for this section.html

31 - Introduction to Advanced Pivot Tables.mp4

00:39

32 - Understanding Distribution and Converting Insights into Actionable Ones.mp4

02:27

33 - Calculating of Grand Total and its Significance.mp4

03:08

34 - How of ROW Total works.mp4

01:47

35 - Calculating of Row Total on a Dataset.mp4

01:47

36 - Visualizing Complex Pivot Data.mp4

03:00

37 - Calculating of Column Total.mp4

01:22

38 - Changing the Calculations to of Column Total.mp4

02:33

39 - Visualizing the Distribution Charts.mp4

02:56

40 - Calculating of Custom Field.mp4

01:54

41 - Calculating of Parent Row Total.mp4

01:51

42 - Calculating Difference From in.mp4

02:06

43 - Running Total and Assignment Walkthrough.mp4

02:40

44 - Advanced-Pivot-Table-Practice-File-Answers.xlsx

44 - Practice file with answers Download.html

6 - Conclusion

45 - Bonus Lecture.html

Description

Create and Analyze Data with Pivot Tables

What You'll Learn?

Fundamentals to Advanced Techniques: Start from basic data analysis and become proficient with Excel Pivot Tables.
Exclusive Insights: Access unique Pivot Table strategies and tools, with insights not found in other courses.
Engaging & Effective Learning: Experience interactive lessons from a top-rated Excel instructor.
Learn how to use Pivot Tables to streamline and absolutely revolutionize your workflow in Excel

Who is this for?

Anyone getting started with Pivot Tables

What You Need to Know?

Basic Excel Knowledge

Microsoft Excel 2010-2019 or Office 365

More details

Description
PIVOT TABLES are the most sought out feature of Excel and is often used at work environment.
In this course you will learn a lot about Pivot Tables.
You'll get to learn about the below scenarios:
Inserting a Pivot table from a simple dataset
Inserting Fields and giving a shape to Pivot Table
Changing Views and understanding Views for different data
Moving Pivot Tables
Inserting and Managing Timelines
Inserting and Managing Slicers
Grouping Data on Excel
Filtering Data on Excel
Pivot Tables has been critical for most of the tasks at work. However it had its disadvantages and is often time consuming if the data is complex.
YourExcelGuy is the first and only platform that provides animation videos for excel skills. We have put together more than 100 videos that demonstrate every excel skill you can imagine - whether it's for absolute beginners or advanced users. Our content includes transformations, graphics, conditional formatting, data tables, pivot tables, dashboards, or VBA macros.
About the Instructor: I'm a Microsoft Certified Excel Expert and a full time Excel coach, I train people on Excel and that's something I really love doing.
Currently I have trained over 50000+ students. With over 4 years of training experience and 11+ years of using Excel every single day I've learnt a lot of tricks in excel
Who this course is for:
Anyone getting started with Pivot Tables

User Reviews

Rating

average 0

Total votes0

Focused display

A Microsoft certified Excel Expert (MO 201) with over 10 years of experience in the Recruitment and Analytics Industry.Having worked for several Multinational companies and startups I understand the importance of Excel in all types of organizations and how it's used differently from one to another.I use Excel every day, every hour of my life both personal and professional, and have been tutoring this tool for over 13 years.

KultureHire Education

Instructor's Courses

KultureHire is a job simulation platform for freshers. We specialize in coaching freshers in an Internship setup and train them to become employable. We have trained over 10000+ professionals in the past 1 year and have helped over 300 people get jobs in the market in India, Africa and Canada

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.