Microsoft Excel Pivot Table and Analysis Beginner to Pro
- Description
- Curriculum
- FAQ
- Reviews
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
-
6
First Pivot Table with a Calculation -
7
Different Calculations from the Same Field
-
8
Using Rows and Columns in Pivot Tables for the Same Field
-
9
Using Rows and Columns for 2 different fields
-
10
Managing Labels of a Complex Pivot Table
-
11
Sorting Values in Pivot Table
-
12
Label Filtering in Pivot Tables
-
13
Values Filtering in Pivot Tables
-
14
Report Level Filters in Pivot Tabels
-
15
Formatting Values in Pivot Table
-
16
Managing Date Information in Pivot Tables
-
17
Moving and Managing Pivot Tables
-
18
Pivot Table Basics Quiz
-
30
Practice file for this section -
31
Introduction to Advanced Pivot Tables
-
32
Understanding Distribution and Converting Insights into Actionable Ones
-
33
Calculating % of Grand Total and its Significance
-
34
How % of ROW Total works
-
35
Calculating - % of Row Total on a Dataset
-
36
Visualizing Complex Pivot Data
-
37
Calculating % of Column Total
-
38
Changing the Calculations to % of Column Total
-
39
Visualizing the Distribution Charts
-
40
Calculating % of Custom Field
-
41
Calculating % of Parent Row Total
-
42
Calculating Difference From in %
-
43
Running Total and Assignment Walkthrough
-
44
Practice file with answers - Download
