Excel Pivot - Basic to Pro

Excel Pivot - Basic to Pro

Learn data analysis through Pivot

Language: English

Instructors: Mahendra Rana

₹1500

 

Why this course?

Description

Pivot makes your data summarization and anlaysis easy. This course is designed to learn from scratch and make you pro. Stop using formulas for basic calculations and analyze your data more effecitvely.

Course Curriculum

Introduction
Why Pivot Table
Sales Raw Data
From Beginners to Pro
Lets Begin (3:00)
Do more with Pivot (1:00)
Most Common Mistakes Part 1 (5:00)
Auto Refresh and Most Common Mistakes Part 2 (2:00)
Number Format All at Once (1:00)
Using Filters and Column Option (4:00)
Removing Grand totals (2:00)
Extracting Report Details into Separate Table (1:00)
Adding Percentage Summary (1:00)
Displaying Null Rows (2:00)
Top 10 Option and Sorting (2:00)
More Features Part 1 (2:00)
Playing with dates Grouping and Ungrouping (7:00)
More Features Part 2 (4:00)
Bonus Chapter
Learn Slicer (6:00)

How to Use

After successful purchase, this item would be added to your courses.You can access your courses in the following ways :

  • From the computer, you can access your courses after successful login
  • For other devices, you can access your library using this web app through browser of your device.

Reviews