Learn Pivot Tables in Excel from Scratch

Name: Learn Pivot Tables in Excel from Scratch
Rating: 4.5 (228 reviews)

Pivot from basic to Pro

Created byMahendra Rana

Last updated 12/2020

English

What you'll learn

Use Pivot table like Pro

Course content

4 sections • 18 lectures • 55m total length

Introduction - Why Pivot ?0:57
Learn to extract insights from data with Excel pivot tables to build fast reports. Create pivot tables to compare sales by zone and product type, calculate percentages, and use slicers.
Raw Data for Practice0:10

Lets Begin3:58
Some more with Pivot1:57
Most common mistakes - Part 15:07
Auto Refresh and Most Common Mistakes - Part 22:52
Number format - All at Once1:55
Using FIlters and Column box4:37
Removing grand totals2:12
Extracting report details in to seperate table1:51
Adding Percentage summary1:46
Learn how to add a percentage of grand total column in a pivot table, format numbers, and rename the column heading to show regional sales as a share.
Displaying null rows2:12
Display every category in your pivot table, even with no sales, by showing items with no data and filling empty cells with zeros.
Top 10 option and Sorting2:45
More features part - 12:26
Playing with dates - Grouping and Ungrouping7:41
Master pivot tables in Excel by grouping and ungrouping dates into year, quarter, month, or week, remove grand totals, and analyze sales and growth.
More features - part - 24:35
Master pivot table features in excel, including inserting into a new or existing sheet, using recommended layouts, and adjusting value field settings for average and count calculations.

Requirements

You should have Excel 2013 and above

Description

If you are a beginner or have very basic knowledge of excel and want to upgrade your knowledge that assist in getting some insights from your data to analyse and make decisions, this course is for you.

This course is designed using Excel 2016 and it works well for all the above version as well as 2010+. However, I would recommend to use Excel 2016 or above to learn this course.

Who this course is for:

An Individual who wants to derive meaningful insights from data and make decisions

Learn Pivot Tables in Excel from Scratch

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 1min

Pvot from Begineer to Pro14 lectures • 46min

Bonus1 lecture • 7min

Want to learn more?1 lecture • 1min

Requirements

Description

Who this course is for: