Pivot Table in MS Excel (Part 2) | Microsoft Excel Tutorial | LECTURE # 12 | Learning with M dot Zee - video Dailymotion

Learning with M dot Zee

In this tutorial, I'll teach you with examples to create Pivot Table to gather data for your requirement. Pivot table is very flexible so you can customize it as you want.  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

Transcript

00:00bismillahirrahmanirrahim

00:02السلام علیکم

00:03learning with amdorzy

00:04میں خوشحامدید

00:04آج کے اس لیکچر میں

00:06ہم پیورٹ ٹیبل کی کچھ

00:08اگزیمپلز کو سیکھیں گے

00:09جس کی مدد سے

00:10ہم یہ جان سکیں گے

00:11کہ پیورٹ ٹیبل کو

00:12افیکٹیوی کس طریقے سے

00:14استعمال کیا جا سکتا ہے

00:15ساتھ یہ پیورٹ ٹیبل فیلڈ میں

00:16جو ایک option

00:17filter کی تھی

00:18اس کو بھی ہم

00:18apply کر کے دیکھیں گے

00:20کہ اس کو ہم

00:21اپنے ڈیٹا میں

00:22We can use it on the computer screen.

00:24Let's go to computer screen.

00:26We can learn how to use our data

00:28with the pivot table

00:30to easily

00:32reports and data

00:34generate

00:36which can be very effective.

00:44We are going to computer screen.

00:46This is the data

00:48which we have used last lecture

00:50which we can use.

00:52We can use this data

00:54with the pivot table

00:56to summarize.

00:58First, insert pivot table

01:00range selects

01:02existing worksheet

01:04and this place

01:06OK.

01:08We want to make

01:10the data

01:12region-wise

01:14row

01:16region-wise

01:18we have

01:20sales

01:22and

01:24we have

01:26numbers

01:28and

01:30here

01:32number

01:34and

01:35use

01:36thousand

01:38here.

01:40We have

01:42region-wise

01:43central

01:44we have

01:4617,700

01:47north

01:4821

01:49south

01:5014,000

01:51plus.

01:52we have

01:54we have

01:56we have

01:58to

02:00select

02:02we have

02:04to

02:06we have

02:08to

02:10we have

02:12to

02:14to

02:16see

02:17the

02:18number

02:19we have

02:20to

02:21see

02:22how

02:23we

02:24can

02:25see

02:26how

02:27we

02:28can

02:29see

02:30how

02:31we

02:32can

02:33see

02:34how

02:35change

02:36because

02:37this

02:38is

02:39difficult

02:40because

02:41this

02:42is

02:43difficult

02:44here

02:45we have

02:46here

02:47to

02:48design

02:49tab

02:50report

02:51layout

02:52compact

02:53by default

02:54outline

02:55form

02:56here

02:57region

02:58name

02:59tabular

03:00form

03:01tabular

03:02form

03:03here

03:04central

03:05total

03:06here

03:07here

03:08here

03:09here

03:10and

03:11left

03:12side

03:13here

03:15here

03:16subtotal

03:17at

03:18bottom

03:19of

03:20group

03:21show

03:22all

03:23subtotal

03:24at

03:25top

03:26of

03:27group

03:28tabular

03:29form

03:31here

03:32we

03:33outline

03:34form

03:35here

03:36show

03:37here

03:38if

03:39bottom

03:40will

03:41top

03:42will

03:43be

03:44top

03:45here

03:46here

03:47here

03:48here

03:49here

03:50we

03:51want

03:52to

03:53cost

03:54of

03:55good

03:56sold

03:57and

03:58maximum

03:59data

04:00here

04:02cost

04:03of

04:04good

04:05sold

04:06here

04:07cost

04:08of

04:09good

04:10sold

04:11here

04:12maximum

04:14and

04:15minimum

04:16minimum

04:17of

04:18sale

04:19sale

04:20sale

04:21sale

04:22some

04:23of

04:24sale

04:25to

04:26click

04:27value

04:28here

04:29sum

04:30to

04:31count

04:32to

04:33count

04:34of

04:35sale

04:36to

04:37sum

04:38of

04:39sale

04:40count

04:41of

04:42sale

04:43now

04:44we

04:45do

04:46again

04:47sale

04:48to

04:49sell

04:50some

04:51of

04:52sale

04:53to

04:54fill

04:55here

04:56we

04:57have

04:58average

04:59of

05:00sale

05:01to

05:02sell

05:03here

05:05we

05:06have

05:07sum

05:08of

05:09sale

05:10to

05:11fill

05:12setting

05:13this

05:14maximum

05:15max

05:16of

05:17sale

05:18okay

05:19one

05:20one

05:21more

05:22sale

05:23we

05:24do

05:25some

05:26of

05:27sale

05:28to

05:29here

05:30minimum

05:31this

05:32off

05:33okay

05:34now

05:35here

05:36data

05:37is

05:38central

05:39total

05:404

05:41count

05:42average

05:43sale

05:44minimum

05:45sale

05:46of

05:47good

05:48sold

05:49here

05:50this

05:52central

05:53has

05:54two

05:55north

05:56total

05:57total

05:58and

05:59south

06:00in

06:01the

06:02total

06:03total

06:04total

06:05total

06:06total

06:07total

06:08total

06:09total

06:10total

06:11total

06:12total

06:13total

06:14total

06:15two

06:16difficult

06:17bandit

06:18rose

06:19and

06:20columns

06:21we

06:22can

06:23just

06:24group

06:25center

06:26north

06:27highlight

06:28this

06:29we

06:30have

06:31added

06:32columns

06:33here

06:34we

06:35have

06:36to

06:37center

06:38line

06:39to

06:40center

06:41line

06:42after

06:43each

06:44item

06:45center

06:46after

06:47each

06:48item

06:49center

06:50after

06:51each

06:52item

06:53center

06:54after

06:55center

06:56and

06:57center

06:58and

06:59south

07:00down

07:01after

07:02each

07:03center

07:04after

07:05center

07:06after

07:07center

07:08and

07:09south

07:10after

07:11now

07:12we

07:13have

07:14the

07:15center

07:16group

07:17two

07:18joints

07:19were

07:20separate

07:21total

07:22total

07:23and

07:24total

07:25total

07:26bottom

07:27we

07:28can

07:29make it

07:30confusing

07:31because

07:32blank

07:33rows

07:34add

07:35central

07:36total

07:37total

07:38total

07:39total

07:40total

07:41total

07:42total

07:43total

07:44total

07:45total

07:46total

07:47total

07:48total

07:49total

07:50total

07:51total

07:52column

07:53set

07:54total

07:55all

07:56in

07:57the

07:58section

07:59and

08:00the

08:01section

08:02is

08:03the

08:05section

08:06that

08:07we

08:08had

08:09a

08:10different

08:11section

08:12of

08:13the

08:14section

08:15of

08:16the

08:17section

08:18date column

08:20date wise we want to remove data

08:24date we add here

08:26central date

08:28then we will add one column

08:30we will add date

08:32we will add date

08:34we will drag

08:36and filter

08:38date

08:40we will add date

08:4227 data

08:44north

08:46date

08:48date

08:50multiple dates

08:52select multiple items

08:54select multiple items

08:56select filter

08:58this option

09:00select

09:02now

09:04if we give

09:06any data

09:08we will add

09:10and

09:12If you have any kind of confusion, you can share it with me.

09:16Here is our lecture today.

09:18I hope you will understand that the pivot table is a good way to understand.

09:22In the next lecture, Inshallah, my pivot chart will be very flexible.

09:28You can see the chart in the future.

09:32In the next lecture, you can see the pivot chart in the future.

09:36You can see the pivot chart in the future.

09:40Inshallah, the next lecture will be the pivot chart in the future.

09:43We will see you in the next lecture.

09:44I hope you will see you in the next lecture.

Pivot Table in MS Excel (Part 2) | Microsoft Excel Tutorial | LECTURE # 12 | Learning with M dot Zee

Category

Transcript

Recommended