Pivot Chart | Microsoft Excel Tutorial | LECTURE # 13 | Learning with M dot Zee

In this tutorial, I'll teach you how to create and manage Pivot Chart.

Please like the video, subscribe to my channel, and press the Bell Icon to get in touch with new tutorial videos. Don't forget to share with your friends as well.

Through my Channel "Learning with M dot Zee" your go-to destination for mastering Microsoft Office and boosting your productivity.

Microsoft Word Tutoring
Leave a Comment if you have questions, suggestions, or queries.

#tutorial
#computerbasics
#learningwithmdotzee
#learningcomputer
#learningmsoffice
#learning
#tutoring
#microsoft
# word #excel
#tutorialvideo
#tutoring
#review
#printing
#beginners
#beginner
#layout
#sumformula
#sumfunction
#sum
#numbering
#numbertable
#table
#tableinexcel
#cellstyles
#cell #style #styles
#pivot #pivot_table #pivottable
#pivotchart

Transcript

00:00In the name of Allah, As-Salaam-Alaikum

00:03Learning with Em-Dorzima, Khusham-Deed

00:05In this lecture, I will teach you Pivot Chart

00:09Pivot Chart and Simple Chart are flexible

00:14and Simple Chart is a constant

00:18Simple Chart is fixed data

00:21but Pivot Chart is summarized data

00:25There are many variables that you can modify

00:30Let's go to computer screen and learn Pivot Chart

00:40Here we go to computer screen

00:43This is our table

00:46Pivot Chart

00:48Pivot Chart

00:50Pivot Chart

00:52There are two options

00:54We can select table or range

00:56We have already selected

00:58The other option is New Worksheet

01:00We want to select chart

01:02We want to select existing

01:03We want to select existing

01:04We want to select this option

01:07We want to select chart

01:09We want to select here

01:10Okay

01:11Blank Chart

01:12Open

01:13We want to show data

01:14We want to select region

01:16We want to access

01:18We want to select sales

01:21Some values

01:22Central

01:23North

01:24South

01:25This is near

01:26Sal

01:2715000

01:2820100

01:29This is

01:30near range

01:31We are set

01:32It's near region

01:33And here

01:34We can select region

01:36By region

01:37We can select regions

01:38Or here

01:39As we can select names

01:40From categories

01:41To determine

01:42What we source

01:43What we are

01:44Table

01:45We can select

01:46North

01:47South

01:48Clear

01:49How we can select

01:50That is why it's a good deal.

01:53And, with this cost of good sold development,

01:55I will add this value as well as well.

01:57It's a good deal.

01:58So, cost of good sold,

02:01We will give our sales,

02:02and we can get the sales.

02:07We can accept the of cash,

02:08but the cost of good sold.

02:12We will have sales.

02:16It's a good sales price.

02:18this is sales and cost of goods here we have margin clearly

02:23we have to know how much margin available is available and filter

02:27if we have date we have to apply date we have to change our date

02:33or here we can change our date 27th

02:40ok this is just the kashif data which is 5000 plus sales

02:47and the cost of goods sold.

02:51In addition, you can change the elements from the chart.

02:57You can click and activate the options.

03:02The second option is chart styles.

03:05If you want style, you can keep your requirements.

03:10You can use style.

03:12There are options in Microsoft Excel.

03:16If you like color, you will see the options.

03:20In the option, you can select the scheme.

03:23You can start with the left.

03:25We have the values in sales and cost of goods sold.

03:31You can select two options.

03:33You can choose blue and orange,

03:35and you can select the option.

03:36You can select the scheme.

03:38I hope that you will understand.

03:43If you understand any confusion in the comment box, please share it in the comments.

03:48We'll see you in the next lecture.

03:51Allah Hafiz.

Pivot Chart | Microsoft Excel Tutorial | LECTURE # 13 | Learning with M dot Zee

Category

Transcript

Be the first to comment

Recommended