Excel Pivot Table Tutorial: From Beginner to Advanced in Hindi!

0:00 Executives of any company alist business and list went till here If you ask the analyst also that A lot of people learn it the wrong way Therefore, they should know the detailed information of the peer table. and they do not have the power of the peer table If you don't know then in today's video I will bring it for you within an hour This is the full power of PO table, yes A to Z You will get to learn about PO table It's not going to be a one, two, three hour movie

0:47 is going to happen then I want that brother if You can apply for MS Executive, MS Analyst or Business Analyst or Data Analyst If you are thinking of becoming a master then brother, inside Excel You can learn this PO table in detail You have to sit on the PO table in the interview You may be asked questions, you may need to read the table You may have to use too much because Take the smallest company or the largest one If you take the company then it is used individually so you The table is bound to be used, so its Grab the knowledge now and along with it In particular video, whatever I I am going to use the practice file Making it available for practice as well I am going to cover industry relevant material You can also watch the master class of this pew table If you are going to complete it then why wait By the way, I have brought this PO table for you Let's start the master class of

1:39 Friends this is Mr. Sharma and he has a Its a simple question brother I am from PO table Why should I use PO Table? What is needed to explain this to them I showed a data and on top of this data I asked him some questions, the questions were something like this the way that I took out from this data He was asked to name five such countries. Tell me who has more sales or five Name the countries whose sales are very high is it less or all category wise i.e. Name the top five subcategories or Which region has more product sales I have to tell them this or else the category Which product has sold the most? So brother Sharmaji after seeing this data, He got confused, his fuse blew, brother, this How can I tell you about this data? he told me so I

2:25 That said, if you use pure table If you are single then these sites will tell you Yes friends, it is possible inside the data Because the data you have is that data every day And if it is in column format then you can use it Convert it into a particular visualization You can do this with the help of Excel PO table What basically happens in a PO table I'm going to explain this to you In the video, first of all a picture of a table We can know a small definition without Using Formula We Can Get the Surprise Record of our data if you have an interview If I ask you then give them this simple definition brother can you tell me that without any formula Create a summarized report on any data You can now surprise with the help of a py table We have to learn the reports but without the py table What are we going to learn inside these 13 The chapters we are going to learn in which Peer TablePure Chart Slicer Timeline

3:11 Grouping, ungrouping or regrouping of tables Settings show values ​​as calculated Fields Filter Dynamic Pave Table Get Pave Preview table data or multiple sheets We will tell you all the things about how to make a table in one place You are going to learn with this big video Inside friends and in the description I have You have also given the time stamp of these chapters You can also jump directly to that chapter now what does a pew table do Basically whatever data you have, basically That is very confusing right over Well done to understand ordinary humour Right then any ordinary person like Sharma ji I gave them the data daily and in columns That is difficult for them to understand it is difficult for them to understand that data If it is difficult to extract insight, then do it daily and We can use two dimensions over the column data. Reports we can create of PO table Together we can visualize it in charts with the help of

3:58 You can access more data with the help of PO table which can be presented by slicing The reports we have to present By applying slice filter we can present So all these things are pure table stuff If we can do it with help then why don't we drink? Let's learn in table detail then let's go to excel sheet I have kept it open for you here To show, first of all understanding Dashboard on any data I already have to make it on top of the dashboard Created a video which you can pin, comment or i You will find the dashboard in the button if If you want to learn in detail then but the dashboard If you want to build on any data then you The first steps to follow are understanding If you want to understand off data first then this data Understand that you have columns from A to I There is data till last two columns in it You see numeric data in Sales End profit: How much sales does your company have? How much revenue has been generated and

4:44 There is also profit, now how is this revenue generated Hey brother how much revenue has been generated region wise In which regions are you seeing this? City wise and state wise are visible too There is a country and there is also a customer's name, there is an order What is the date on which the customer placed the order? I did it and I also gave you the order ID If you are getting it then approximately how much debt control is this I press the down arrow ok 64 rose here You can see it here and it is something like this The kind of data you are seeing right now There is no issue now on this data for 64 days I have taken your example here There might be thousands of roses in it Data can be spread, a lot of data May be I have used data of only one January So basically you can see the order date According to this, I will also tell you about big data in future I will tell you how to do that on top of that We create the dashboard, first the data is yours What should I do first in front of me like this? to create the PO table on top of it Control A needs to select the entire data

5:31 write and one thing before creating PO table Remember the note or else what can you say Also remember the disclaimer that brother there is no Columns should not be merged meaning two columns shouldn't have a heading like this This is not tolerated in the PO table If every column is equal then it is not acceptable should be individualized it should be separated heading this is a different heading this is a different heading If it is given separately then the headings are separate There should be a merge before creating the peer table Peer table does not apply to columns or rows It is very important to remember that There should be an individual column for each data for ok great means you have here If the title is merged in the top center then that Do not select the title of the pure table So, that means you inserted one here. And I wrote a title here and here It was also made merge and center title which If it is also there then you should take it in pure form

6:17 No, it's not necessary for you right now I did not take the title, I only took the data ok i undone it control a lot First select the data in the first steps I will tell you step by step, don't worry control A right press and then you have to click insert I also know the shortcut key for this I will tell you later that you have to go to the insert You can see the insert tab on the top, click on the right After clicking OK in the insert tab Here you will find PO on the left side Table recommendable and table like this options I will meet you here when you have the old one If it is a version then this is a recommendable option If you do not get the old version then insert it You won't find this in the tab but you will find it in the py table You will definitely get the right 2013 or 10 version If you use it then it is not recommendable here remains ok insert in we po table click here I am focusing on me or keep it I'm clicking on this After clicking on OK Pure Table, your

7:03 A dialog box appears in front of you, this dialog look carefully at the box it is coming here here choose the data that you want to analyse we already have chosen the data right now we I have already selected the data a12 i 64 This is our data, pure table sheet I have named this sheet as Pure Table It is kept so that pure table name comes there Look, this is the name of the sheet Mera Pure If there is a table, then this data has arrived here Meaning it has been selected, select the data On which you want to make a pure table You have to select the data here now There is another option here, use external Data source: You can go here and save the data You can also import it externally here are from some other source such as your SQL There is data on the server etc etc from there too It is linked externally for now There is data in excel, we can check it here

7:48 I will keep it, I will come down, see choose version here You want a pure table report to be Where to place the Pye Table Report Here you have two options, Where to put the data in the new worksheet have to keep Agistify so I want brother to put the table here if it comes I will put my cursor here where Remember that it is blank on the right side of the table There should be a space on the side Agistify Your source data is called source data. which goes to your Agistify

8:37 Insert your pure table into the worksheet It depends on where you are kept if you think that bro no new worksheets I should take it because there are a lot of All the data is Agistify Don't worry, I will show you the worksheet as well I in location in Agistify and then you can go to a Let's take position right here at the top don't take it, leave a few rows down Take it because filters etc. have been applied above we have to do it, we can give heading also If you want it upstairs then later here I inserted it like this I inserted what I had Agistify

9:22 A task of pure table fields on the side The pen comes, it can be called a task pen Look, this is the complete task pen I have already arrived here but if you have gone out I clicked here on the blank space Remember this will not be visible on the task You have to click on this box here Only then will you be able to perform this task of pure table fields. It is very important to remember that the pen will be visible All students sir we have pure table for you We had a pure table feed list coming to us It is not coming near me, I have taken the drink table hey brother put cursor in it cursor in it Keep it, only then it will appear, put the right cursor in it You have a PO table feed list if you have I accidentally closed it here too, don't I even closed my hair, now look here It is not coming even if the cursor is on it he is not coming so what should we do then Here is the instruction to turn on The Pyre Table Feed List to Work With the Pyre Table for working in brother pure table At least turn on the pure table field

10:09 Analyze the pie table to know what to do A tab will appear above, this tab will appear only then Look carefully, this tab is coming up See, I am also focusing on Pure Table Analyze this only then this pure table will come Analyze option when you place your cursor on it If your cursor is outside then it is not coming The design tab is also not coming here Place your cursor and see that these two new tabs appear on your screen. Let's get closer to the right pure table, analyze and the design is like this so what should i do now Analyze the Py table by placing the cursor over it When I go, remember this is in the new version The name is Pure Table Analyze, in this you will If you have an older version, check it here that brother the version in that is empty pure table Sometimes it comes but the name is not analyzed or sometimes only the name Annalise comes It is not a pure table, you have to remember this much and Analyze and Design are two such taps. right now click here and click

10:55 after going to analyze table then See the feed list here on the right side You are getting the option in feed list turn it on turn it on it comes right First turn it on and off, I told you some things which you should know from basic That is why I have tried to tell you everything here. I've tried to look at it because I I will not directly fast forward every I will tell you one thing, one step at a time Where do mistakes happen? It happens now see here what to do now So what is coming here in the pie table finish let's take a look here, look above You see the column names Order id is order date right this is the field means Columns Fields or Columns We call this so these are all the columns that are here These were in the pay data, see, as many as the data There are headings for all of them, all of them are pure tables. You can see it in the pay list here on the right side and below you will find the option

11:41 the drag is feeding between areas below There are four filters Columns Rows and Values ​​Now these four options will come down here What happens sometimes I'll tell you It shows a small setting here I go to pay settings and sometimes it Field section and area section side by side If the side is like this then you will get some There is no need to be confused with filters Daily columns values ​​come here and feed The list is here, this is the view no that is different so you can use this first one as default Let's keep the view here, if the view changes has someone done it or has there been any change There is no need for confusion friends, I I told you brother that the view from here is Change is happening right now what do you have to do Basically now let me come to the peer table Here I want to create a table in which I You have to show country wise sales first What I did was to change the Country column to Country I can see this column here

12:27 Bring the Maui pointer above the country column The country column is visible here Bring the mouse pointer over it and move the mouse left Press and hold the left mouse button and drag and drop it in the rose See why I dropped in Rose Because I wanted a country record This way the country should be displayed here if I could drag the country back and I'll drop it like this: click and drag put the end drop back up so from here It went out if I put the country in columns If I keep it then I can see the horizontal report This way I will be able to come to the country and its data will be visible below it If I pull the data, it is here Importance of rows and columns means you need to know the importance of columns If you want to show it in then you can keep it in column If you want to show it everyday then drag it like this Drag and Drop Wherever You Go Drag and Drop Click and hold the left mouse button Dragging means left clicking and holding button and drag and drop on the right

13:14 after that i want country wise sales We don't need profit, we need sales first I have put the Sales column here what do I do Drag and drop the Sales column I have four things in my values Filters Column Rows and Values ​​Values I will give you those calculation numbers Mostly I have to take the rights here, so I I have taken this sales but here pay some off The total sales is coming automatically telling me to zoom it in And I'll show you brother I I got the country wise total I did not apply the formula, how much do I have The records of the countries are there, it can be seen there I have you covered with seven countries The record is Australia, Belgium, Denmark France Germany India and Spain and here How much sales have been made in which countries I can see it here in front of me What is the amount of sales on the front right? That basically total amount comes here and what have I done for it

14:00 I did just one thing, I saved the country Drag and drop cells here What is drag and drop here? I did not apply any formula, right? You can easily generate the report here. And you can also find out the top five countries in this If you can, you will say top five countries We will see how to remove it later don't worry so first of all i just went to country I dropped you here now I'm in the country Look at it carefully together in two dimensions We have to make a two dimension report, we made it from this If I can then I will cover the country as well as the region so I don't want to see it either so I will put the reason here look at the reason you see the drag end I will drop it in the columns wow right Interesting look here Central North And South now which country is this Austria According to the people coming in, here In which January is Denmark country coming? and in which month is India country coming

14:46 For example, take this now is this is not created This north is coming in the created Jan You can see it is coming in public Again, these are the four countries in Central India. I mean and these are countries in the North and this There are two countries in South Africa, so which country is it? Which countries are coming and its How much sales are you getting zone wise You are also getting the total of sales and Country wise total also Country wise total Here it is coming on the right side and more zones wise it is coming at the bottom here right meaning region wise right so now if I I drag and drop it here and I put the country here so now What is happening, see the total of the right country Which will appear like this in the country column region has come into role and country and I have kept the reason with me, I have kept the reason

15:31 I kept the country on top, I kept it below, I did this Now, there are as many countries in the central zone Central region or zone, you can say all of them together Denmark is coming here in the North and India and Spain are here in the South Zone So you can keep it like this and you can keep it here You can minimize instead of exp This is the expense, it has been minimized by you Want to expand these? See it now Coming from all three zones but I am from Central I want to see the countries of the zone, I can see Buy click on this little plus button By clicking the plus button here I I can see these, they are quite interesting isn't it friends, you can get this quickly here Dashboards are one of the small dashboards I'm working on right now I am showing you a small report. You will get it quickly and do it For this you have to apply the sum formula Statisticians would have to use certain formulas Only then do these reports come right Some Ips have to do the right big formula

16:16 If you have to install it long and wide then install this There is absolutely no need here, because this I am giving you a quick report here K right so you basically got the idea What things will you do in Peer Table? I told you this is a start You should know that brother in PO table country region or If you want to calculate sales wise total then how? have to take out So friends let's go basic pure table We have seen how to make it Lots of advanced stuff in pure table we have to learn but here in the insert Another option you get beside the pure table It is recommended if your Excel has If you don't have this option then understand that you are old you are using this version right it is a simple thing What is Recommendable in Pay Insert Here Why is this option given here, what will happen So I will first select the data It is necessary to select the data using Control A

17:02 I did it, selected it, and then I'm going to I am here to recommend what I am focusing on I am showing you, I am clicking, click what is it doing automatically after doing this Here are some tips I recommend to you Here you will find some drag and drop options there is no need, he is saying So that I can show you zone wise here This is Central, North and South Jan wise Counting profit is telling about the profit We don't have to do the counting anyway But count profit how many central zones I am in North Jan and Si is in South Jan Then here's this one which is saying the same thing See the sum of sales by region after that sum of profit by region all these things here Pay you are getting profit and sales both of them so which payo table do you want to buy Suppose I take this as an example I'll click here and okay if you I think my friend doesn't want to take any of this If I want blank then you can go to blank also which you can also do with

17:48 But here there is blank pure table option if it is in this then go here and I I recommend it, see this in the new sheet This is being inserted here automatically new It is happening in the sheet, in the assify sheet No, insert a sheet here in a new sheet it is like you see here like PO table When you insert it, your data will be here And I can see this sheet here, giving in which Central North and South The total of the zone has come automatically and right If you look at the feed list on the side region and here it is showing some off Sales done automatically drag and drop You don't need to drag and drop If it is right then you can create the PO table yourself. If you want then what will you do in insert You will go to the pure table, how will you go Here first you need to select the table and you have to do the range which is already selected after that it is needed in new worksheet or

18:36 Agistify Just click OK and a new sheet will be inserted. You will see here that a new sheet has been inserted. sheet two is going on and inside it it is coming here hey po table three right here already I inserted PO table then its number When three comes what will I do here? The fields shown here are PO Table Field I have already heard about it I explained to you right, if you don't see this then I repeat once again that this is what The feed list doesn't look like this In this way, there is no need to be confused Here you are given the option of setting and You can change the feed section by going here You can keep it as you want Sometimes you don't even get the option below If so, go ahead and check it out here Bha check it out bro yes this one is it selected properly or not and this If it is closed by mistake then which one will you get You will have to go to the Pure Table Analyze tab

19:21 I'm going to repeat at the poor table put cursor in too many people cursor out and say that I have analize The tab is not coming up sir it will come up only when You will place your cursor in it and click on the Analyze Table tab. Go in and remember the version must be new too Yes, keep it in some versions just analyze name is like 2016 empty here p analysis The name appears but the table analysis does not appear And in this you have to turn on the fee list of the table After that you have to submit the reports here But you can prepare it from here So we have learned this pure table basics Now let's learn pure charts, how to do it I want to make second chapters [music] I am here in the second chapter of your Welcome to Create Pid Chart So first of all I'm gonna do the control A button After that I will go to insert I recommend this table here

20:08 ok i want a chart so i can go to right I will come on the extreme right side pure Chart option is available here, see now You can also say that brother sir I already created pure table like I did not make it on sheet two or sheet two I made a pure table of this in sheet one I want a chart so you can do that too I will tell you, don't worry, what are we doing right now We are doing this table with pure chart Specially for Option with a Pew Chart How to create a Pew Table Plus Chart If you look here, we have this in insert See the chart to choose the option I click here, as soon as I click This option is coming in front of you - Create Pot Chart Now what is this pot chart Basically an empty chart will not be created here How will I make a table and a chart? Let me show you, first look up here Select a table and range already selected like you have to do the same in all the steps new

20:55 or that Agistify because there is also a pay chart If we need it then I will get a new worksheet ok here you can see it here Right now Pure Table Four is coming and this why four because 1 2 3 already inserted and on the right side you will find a chart as well You will get a table as well as a chart Right now here what kind of country do I want? If I want to display a wise chart then I Where can I drag and drop the country You can place rows or columns here as per your requirement right so I dragged it over here So here all the countries are in different rows It is visible and I am showing the sales wise chart Brother, I want to see which country's sale If it is more then I will see reflection in the chart Look, I will know immediately about India and Germany If it is there then this is the benefit of the chart, right? The visualization from the chart is absolutely proper When you present something to someone If you want, you can see it through the chart at that time. If you present it quickly then it will be easy

21:41 If it makes sense then we can create charts in the dashboard We are going to make the same chart in the future I am telling you here first how to add If we had to add something, we just did it here Added things and the chart is displayed here It is done and now I don't want this to happen There is a country and besides that I am also region wise If I want then keep the region locked in the legion put the region together ok so here You will see that I have dragged and dropped it given and you can see it here now The color has changed in Central North End There are three zones, the Legion colours of the three people have arrived Here you can see it right color wise. Which colour is it and how do you want it So put this region here, put the country here put it on you can switch it like this You will see the legend for your country here The color is coming here now, it is visible Each country is having its own separate pillar color is coming right column is coming basically and if you keep both of them in one place

22:27 If yes, then it will come here in some way like this but it is very difficult to get it report because they come one under the other and you have to apply the filter here again You will have to see each report one by one Better than this you can separate it like this If it is there and you don't want the reason then remove it If you can remove it, then this chart is created here And when you insert a chart, you get Here you get another option which is Design basically means design option What design do you want inside the chart? Do you want to keep this chart like this or else You want me to look at this chart, brother. If you format it well then there is a lot of it here You can get all the designs, see here If you are getting the design of the chart then You just hover the mouse pointer over the design This is available in the option and the other one is this that I do not want to present this in this column I want to present it in some other way For example, you don't have a country

23:14 You have put this region here and country I have removed only three things here. if it is there then I am not in the column I found it If I want to present it in a chart then you You can also do this in the Design tab already above Design tab is selected, change chart in it You get the type option and by taking it Here you want to convert it to pie. look there are so many different charts In whichever you want to present okay now do it a little more Let's design, select this design Let's do the right percentage percentage wise has come here now the region here You can see it here I don't want it, I want it on top Or if I want to keep it at the bottom then What I will do for this is to go to the already designed tab Here you can see this option there is add chart 11 there is option in legend You have to keep it on top brother I want to keep it on the left, where should I keep it at the bottom

24:00 You want to put it on top I want to keep it, see if it comes to the top or not Then if you want it at the bottom then at the bottom keep it or else i don't want to keep it If I don't know this then how will I know this region which one is it so I'm going to put it on top of that If I bring the mouse pointer then I will see here It can be seen that this is the central region This is the south region, this point should also be visible but I am displaying it here only If I want to do it then this level is visible I will click on this one with percentage I will click here and do one thing Close this PO chart field here. I will give it to you because I am here on another task If he comes, what will I do for him now? Let me tell you here, above this level I have to right click, right click, OK After that you have to go to format here The data levels are visible, remember that I right clicked on the level The percentage level that you are seeing You have to right click on that level I have to go to format data labels then

24:47 After here you will see a label on the right side Getting options that are labeled in Options What value do you want to keep from sales? series name category name so if you any sale If you want to get the value from then check this one You can see this in value from sales you can go and select the cell but that It is not necessary that we are here right now, we are here right now But if you enter the category name directly If I put the series name then it will be whatever its name is its name is total right total Percentage is coming out so here is the category We put the name in the category name See what is happening in South North Central In this way you will get the report here Right, if you want you can post it here as well Can display percentage display If you don't want to do it then you can remove the percentage If you want to display it then you can keep it A lot of changes can be made here which are format data levels and You can also format the chart

25:33 Right click on Format Chart What is the fill color of the chart in the area There should be a border in the background all these things shouldn't stay here On the right side it is given, from here you can see the chart You can also format it like a normal chart There are options like background color should it remain solid or not You can decide from here so overall We have come to the idea here that we need to How to make a chart basically The peed chart is of the table itself The table will come here and the chart will come But if you have already created the table like it is in this then I want its chart what will you do you can place cursor on this table We will keep the pure table analyze tool here You can see it, click on it And here you also get pure chart option If it goes then drink it from here also like this You can take the chart and see if it is the same Get it from here or you can read chart option first

26:19 take it from it's up to you do you think that friend, if you want to take it later, then take it later You can take it in and all the options are available in it too you can do it here as you think If you don't want this thing then you can delete it You can do it also, see it is simple there place to go and remove the blank means design go in then go here and remove it By going to design here you will spend so much time If you are going then click here After clicking, delete it and this is If I want to hide this button from here then I I will right click on it and select Hide All Fields Buttons on chart, look it is showing hide all Field buttons on chart let's hide this chart It became a little bigger, then it was called percentage If you want to convert then you can do it from here also or you can right click and see if You did not take the design from here in this If the percentage is showing then right click Click on Add Data Level Here directly what happens at the data level

27:05 it will show the values ​​first then these Select the values, right click Format Data Levels Format Data here Go to levels and the value here Remove that and do the percentage, see this right Here you can see the category name if yes then add category name also then these things It is available here, you have to keep the value So keep the value, you have to keep the percentage You want to keep the category of things which you want to keep here You can display it here if you want So this is how it becomes a pie chart Friends, I have created pure table and pure chart I have just explained the very basics to you We have covered these things gradually We are moving towards advance and here We have to learn advance [music] Friends, in this chapter we are going to learn slicer

27:50 We are going to learn all the settings of the slicer Basically, what do you have in mind when you slice it? You will have a doubt, I will show you the filter There is an easy way to do this using the Slicer now How do we do filtering in pure table I'm going to tell you this right now, and then How do we filter by applying slicer We will do that as well, so let's do one quickly Let's create a pure table, need it in insert you already know the steps brother pure If you want to create a table then click on pure table And take a new worksheet, do it already. I have all the data selected right now. what am I doing here i am taking data yes, let's go state wise, okay I have said state I have dragged and dropped you here A lot of statuses are visible here Now here I am taking along with the state I am dragging and dropping the sales here. I am doing it right here you will get the state It is happening and here you are getting some off Sales Right OK Now What I Wanted to Do

28:38 Now what do I do with what I have A simple report has come, Pure Table A Bihar and Maharashtra are two of them The status report is displayed here If I want to do it then I will click on this drop down here You can see the arrow, right? This is basically a filter There is an arrow that says you used a filter It will happen in Excel, I will click here and Then I'll go here to Select All I will uncheck and go to Baha or Maharashtra I will check it one by one and I will do it ok Is our method of applying the filter right? From here we will apply filter in pure table And from here we will clear it again. But what is happening that I am here You have to go to the drop down and then here Go to Value Filters here You have to go below and check and uncheck the filters or you have to go through the value filter I will have to go and put a condition but something like this It would be better if you show me your status here brother Click on the state I mentioned above report should come or else here apart from the state

29:24 But I take country here I suppose I remove the state and take the country If there is country here then country is above here It should be visible and the country I click on Report here according to that country If you can see it right then how can you do this For this Ekal has already given you an option inside the pebble which is the peat table analyzer Inside you will find the Insert Slicer here Try this: Insert Slicer Right Insert I'll also focus the slicer here. click on insert slicer but it Option you must remember that in pay table You will keep tabs on taxes, not analyzes Neither will it come nor will you get the insert slicer here You can find the Insert Slicer here now He is asking that brother according to whose accord Here you have to slice the data i.e. I want to filter country wise So I took country ok wow great

30:12 The country has come right now I have Austria I want to see the country's record I want to see Belgium, Denmark I want to see France, Germany India Spain Right All Records Here Whoever I want to see, I can see it here I am able to manage two countries together I want to see India here and If you want to see France, I'll come here. I will keep clicking on multi select. It is visible on multi select if I If I keep a check then I will click on India first I will do it now Denmark is also selected India and France I clicked this Denmark is also selected so I am here What should I do for this? Press the control button here. I will press and click on Denmark then This Denmark D will be selected control After pressing the button, whatever you click on it will be D It will be selected and you can see it here Now I'm going to click and this Multiple are getting selected as soon as I I am selecting the same countries here Multi is getting added very fast here

30:57 I have kept it selected, I have unchecked it So if I unchecked this it means It was just on here, now look at it on France If I clicked, I would see France. If I clicked on India then I saw India but Like I check India already The check is France Austria right so this is an easy The method of filter is here in brother filter. go to then select that uncheck uncheck don't sit here doing this clear filter and Like you don't need a multi selector here. then you want to see a single country so single country's good let's go this slicer I want to delete it in a minute I will click on this delete now I will click on this Pure adds something to the table yes, I guess I want to add it here I also have to add zones and this filter that I have used I have done it, I can remove it from here Go to Filters if applied from Slicer

31:43 So it doesn't matter, it will be removed from here Now it is coming here zone wise also and like this It is also coming, you can see the records ok north central south zone and countries come This is the total. Now I will add two slicers here. I want to do it zone wise as well and this too is it possible is it possible po table Go to Analyze Go to Insert Slicer You have to insert the slicer with country name first It is here now I have to add another slicer then Click here to pay on this Pay Table GO Insert Slicer into PyTable Analyze go in and select a slicer if you need one or If you need two or three slicers at the same time, just go Do not click on country here directly keep a check on what you do What do you need? Region wise slicer is required then Whatever I need country wise and state wise I will click here and click OK here. I will remember this so here I have mentioned the reason I took it and I took this, I took both of them, now whatever is there

32:30 naa region wise slicer hai this is me I want to keep it but region wise slicer i want to put on top so now We will also learn how to set up the slicer. You might want to look at the region by slicer here. If I were to sit here, it would be a very large place if it looks like this then I'll put it up here in the slicer See Slicer, a tab is coming Slicer Only if it is selected will that tab be visible in it Columns Two Three is increasing attention, see this See what you did, so what happened? Guys please check what happened here But I am increasing its size like this and this Vertical has become right now you feel that friend I know that this is the region This is the title that you can see above I have more space than this here Too much space is going to take up space, I have so much space if not then what will i do about it If I don't need it then what am I I will do it, the title above is clear, right?

33:16 There is no need for filters etc. so I It's simple, I'll go to the slicer settings here There is a slicer setting option available It is visible here in the left corner There is slicer setting inside slicer it has I will go and what do I have to do here title is that i don't want it so display it I will remove the header from here. I removed the display header and did OK now. Look, you can sit this properly here. If you want then you can make a small size of this row increase it a little bit adjust it and here but this one will sit on top now here you Click on Central Click on South Look at this, the same zone will come and you will be in the country If you want you can also click country wise can I and how can I have it here right now I don't have a clear filter, even the three of me I want to select it so I press the shift button I will press and click here to see

34:02 I clicked on central I two one I want to select with you so I I will press control, central and south I will click on South, Central and South and I want to select all three together. I will click on central first then I will press the shift button and click on end All will be selected at once right Here you can also show country wise And like this on both sides here the filter here You are getting two filters i.e. two Slicer We have placed the slicer here You must have got an idea how to apply it But what happened here, look here I just applied this country filter and this I came here, then I filtered it clearly I am coming here so it is going here what is this If the problem is happening right then it is not like this This number must be going down right now I have to shift from one place to another again and again If it is happening then it shouldn't be so because I'll tell you why it is this is when you put a filter on it Australia, this is pure table, right?

34:49 it's getting smaller it's getting smaller and when If you are filtering it clear then this He's getting a little bigger, just look at him Because these things are being added here Pay right, what is happening here because of this There are some slight changes in that column here You are getting to see it like If we do it in Australia then it will cost here in this much Data is being generated, yet there is less data here Due to being more, the size of the column should be if this is the size of the column then what will we do It is getting more and less again and again so I am pure One more setting on the table, let me tell you this This is a very important setting, I will tell you later I was going to but I will tell you right now Click and go to Pure Table Options This is a pure table by right clicking. Remember settings Go to PO Table Options and this auto fit column wides on update this gonna uncheck this what will happen if I I will uncheck this, there are a lot of settings in it and we'll see if I uncheck this So I would select Australia Dan

35:35 Mark any selected item then click on the table The size is there or else select it The size will remain in its place which is of the column Size First Aegistify So the column sizes don't auto fit he will sit again and again, he does not do more or less If it sits then the same thing was happening, the size of the column Auto fit was being done but it is not being done now There is some issue that it is shifting here and there the slicer is not working because If the columns were shifting here and there then right click It is necessary to do pure table option settings that you can change when showing a report You can use this important setting and it is good You must have thought this was important so Give a like on this thing friend, I am different like this I am going to tell you about these settings, these are very If there were necessary settings then you must have liked it Please share and comment as well By now, you must have got the idea that Brother how do we insert slicer now Some more settings of the slicer are pending I don't know every thing in detail I am always going to teach you completely

36:21 I will tell you everything in full, friends. I am I will tell you only in detail, I am half-incomplete I don't leave it so please give me full details Learn every single thing and more from my courses You will also get a secret information about I would like to quickly tell you a data I am about to launch an analytics course which is a higher package course friends if You want to work in a good company then you should know data analytics in There will be lots of things, power will remain What are the different types of slicers available here? Here are the styles available, you can style them from here You can have one slicer on top of the other here If you have placed a slicer to take the lead

37:06 If you want to take it back you can do it from here look here it is showing send backward it is important to bring it forward only then you can do it You can bring this backwards Forward this is the basic thing of slicer How do you want to keep the width and height, that is it I want to increase or decrease the size of the button, right? Here I have given you the bead, right just It's not that difficult to try and go ahead You think this is a length slicer please make it a little shorter because their names are also If they are small then you can make the slicer smaller than here You can also track it and shorten it like this If you can do this then you can do these minor settings Here you can see another version of the slicer The important setting is the report Connection settings and slicer here There is another important setting in the settings title so i told you title display If you want to keep it aside for here right now all I want is here

37:51 But this is coming now, watch Central North and South are coming I am descending it I do it, I am descending ok how are you coming see you are ascending Descending you can do these settings here There are more doubts in your mind here It will remain that brother what is this given or right The settings on the side are these settings given that brother you can visually indicate items with no data if anyone here in If there is no data in any item then that will indicate separately so he will check for it Check Hide items with no data if that There is no data for that item so it is here Now any such item here will be hidden there is no data in it right every one The data is of Central and North And from the South, but is there any such atom in the South If there is no data then this South is here inside the slicer if you Go to Reports here or Settings

38:36 If you go and do this then this setting depends you have to keep it on only then you can keep it right okay and the next one that is what Report connection this is now report connection one The important option of slicer remains and A Custom Slicer Slicer Customize the Slicer We also show how to do the formatting Now you will see what are the report connections It happens, suppose you take an example here I have made a Peer table, now I have another Peer I want to create a table so what am I doing? and I want a pure table based on this data The data is inside the slicer So you can make these in two ways learn one too then you go here again go to insert and again on PO table Right click and complete the whole process ok come here it's simple There is no need to process it Select the whole thing on the keyboard

39:23 Press the control button and on its border Bring the border by pressing the mouse Ctrl button Take the mouse and drag the Control button down By pressing and place it where you want If you want to keep it on the right, then keep it on the right If I put the slicer down then this table to pick you up place the mouse point over it and create a border like this You can also depend on it here where should I keep it ok so here I have given it For PO table, depend on whether you need slicer Where to keep it and how to keep it I reduce the size with the slicer that here this P table which is on the right I made a copy of this so this is it the slicer is applied to it but if I would have created a new PO table like I would I go to the original sheet here and here I'll buy a PO table here

40:10 Agistify Look here drink table seven has arrived there's a pour table here there's a pour There is a table, right click on this pure table This is six, where did I find out about six? Look above here, look at the name, pure table Six and which one will remain pure table? Five is right so by copying five we have Made Six but Seven which is the pew table In that we do not have state wise but city wise If you want to show it, I take a whistle here And I take sales here, so here City wise sales you are getting the right Here is the country, here is the state, here Pay city now see now I want I If I click on India then I like India I will click on India and it is coming here Bihar Maharashtra right and here if you

40:56 If you look, there is something in the country or the city The filter is not working, I zoomed in a little I get it out, there is no filter in the city This is happening in India's cities, not in the You can see here I have to clear the filter let me do it now you can see that brother these This slicer is being applied on both So I want it to apply only to this so what should I do for him or else I wish that on top of these three too If it applies, I will tell you what I will do Let me tell you, click on the slicer, keep the slicer Go to Report Connection and this is what we see report connection is a very useful thing Friends go to report connection here You will find a dialog box by going here Look at this number five slicer on the table it is there on six also if it is not on seven then what are you want to check seven Or do you want to keep the five blank? So I'm going to keep the five. Now look. India Germany or whatever you are clicking

41:43 yes right the same filter is applied on the same table it's happening so what i wanted to do I will clear it, see here it is on that Now I am going to go to the report connection I want it no no I just want all three I also want to apply here In this I will keep all three tables checked pure table 567 that we know that because We know that in this pure table 567 we have so I'm here in Australia this See Right now, this is how you can make the connection if you want to do it easily in India then see this India Bihar Maharashtra again here mumbai patna and pune and india right to one How to apply slicers to multiple tables You can do it on multiple tables If it is already being applied then how to apply it I told you we can remove it Now there is one more setting left for the slicer which is

42:29 that's formatting is very easy new Slicer Settings Shown Here New Go to Slicer Settings You can find the new one here want to give a name give your own name Want to have your own slicer settings want to name it by doing my settings want to name my slicer Give any name you want and click here But you give it the format, you format it what do you want the whole slicer which Want to give color to the hole slicer? I want to give this color to the slicer You can decide the headers from your slicer What color should the header be? I want to know a little if I want to give this color then you can click here You will be able to see the color of your slicer here I am getting ready just for the example I am giving color here, it is not so proper I am just giving you a quick color I am showing you brother the selected item with Data that is the selected item that also contains the data how would it look if it wasn't data

43:16 If there are selected items, how will they appear How unselected items will appear I can decide the color of each one here. you can decide here It seems like this is happening on its own Let's give it a different color for the background it's like this friend color color color this let's go this Let's take a little bit of dark top header Similarly you can get different colors from here. You can give it to anyone to whom you have given color diya it will appear in bold give it dark Give me some light and you will find out here I am showing you for example There is no formatting applied to this click this click here and my The slicer will come up Custom now look at the right Now your slicer is as per your requirement color has been applied here so that too You can do it basically in a pivot table

44:01 How to use the slicer efficiently Brother, you must have understood the report connection What is a slicer and how do we use it You can hide and hide the header here Ascending Descending The item inside it You can do multiple selection how to do it I have told you all the things in this chapter yes definitely you must have understood, now let's move ahead There is a lot left to see in the picture towards the next chapter Friends [music] Now in this chapter we are going to learn about timeline Yes friends, now when to use timeline I'll tell you first what to do and I will tell you the disclaimer brother, only then It will be applicable when your data contains data what should be the date column it should be The order date may be the purchase date The joining date can be any Date can be that date column should be here If there is a date column then only you can do this timeline Features you can use in PO table

44:47 so here inside I have a big data I have taken another one to show you where my has around 8000 records and 2021 will be here It looks like the last year is 2021 and more Starting year is 2018 so from 2018 onwards I have a sales record for 2021 I'll hit Control A and I'll go right away I will insert and follow the same steps pure I'll move the table here to a new worksheet. right and doing a pure table nine here He is coming let him come what will I do here now But the things are the same, the columns are almost the same. I want that brother here country or state Or I can take anything from here, I suppose this I take country here, country like this There is more to this data country wise What do you want, there is profit sales here too Quantity is also coming so I have started sales I got sales as well as quantity I want quantity here as well

45:32 I'll take this on the side, see the sum of sales sum of quantity is coming I want quantity and profit side too I want to take profit also I took some off sales sum off here Quantities sum of profit together you here You can show it like this meaning multiple You can find all the things that have value here You can enter in pay values ​​i.e. numbers basically its time has come here This is visible even in sum of quantity How much of Australia is coming here The quantity is not visible and the number is off If you want customers also then you can take that You can also take the customer who is here Drag and drop the customer name here If possible then number of customer customer count If you are coming here then I am going to write your name here I want to change this count of customers name instead of I am going to count the number of customers here Place to add number of customers here If I want, I will write the number of the customer

46:18 What to do after selecting that cell Go to the formula bar and type this Look at the heading of the Number of Customers column. it's done, okay, you can total about this too You can take sum off by quantity You can do this by using total quantity instead of quantity. You can change everyone's heading total Sales Country Wise Sales is coming here Currently this is the total sales because some time is coming and total profit then the column heading then you can easily change what i do now I want to see that in the year 2021 The report of sales is here But I saw that it is coming completely, isn't it? four years old is coming to me if he has a record then what can I do for him I will do it and I also want to keep the chart so I'll click on this chart How to insert it here on the pure chart click and I want pure chart Suppose here only column chart is displayed Let's take a lot more records here

47:04 but we can display it in a column chart No problem, let's take it in column chart And here instead of country wise it is written country for a minute and short Someone take it category wise here category one If there is something then this chart should also be made here If you want then increase it like this Keep it, ok, there is a chart here as well, ready right ok so now what am I going to do next now I If I insert a timeline, the timeline Py Table Analyze Tool for Insert go in and click insert timeline here Click here Click on order date Click OK here. See the order date here. Pay attention, only one column is being detected See the Analyze Table Tool Insert Timeline And if this order date is not a column then this It will not be detected, an error will occur here and We have a date column so that's the same column It is being detected, nothing else happens

47:50 it is happening and we are here ok now I am asking you brother what are you doing I want you to be here in this timeline Extend the timeline a little bit from here Let us also take it here and keep it here Let's keep it on reduce its size a bit and put this little slicer here Let's turn it around, this is telling us 2018, 2019 It is telling you the right thing about every month of 2020 and 2021 That is why I am telling about the month because here it is selected in months i want it If I select in quarters then now this Quarters appear smaller If I select it, it will become small If I do it in years then it will be more I want to see the sales of 2018 will become small Here's how our sales were in 2018 Which product was being sold and how? You can see it here category wise

48:35 This is being displayed here in 2018 I want to see 2019 with him I'm going to click here, look like I clicked here and you will see the reflection How was the sale in 2020 and in 2021 Which product was sold, when, how and how much You can quickly see the year wise details here Get here quickly with the help of timeline You are being filtered with some conditions, anything No need to select quarter wise If you want then first quarter of 2018 second Quarter of 2018 Third Quarter Fourth quarter first quarter you know january February is March or April or June like this two three will come together quarter wise If you want a quarter then you can do it from here Drag it like you have a two year old If you want companionship then take this for two years at once So this is how you can drag it I want it months wise for 2018 Then see what the sales were in January month What happened in Fab month wise you can find it here

49:21 The chart shows how the sales are happening You are getting instant reflection in this too That's why there are no empty numbers here, just charts That's why I made it so you can have a reflection it can be seen here that brother here like I I will click, changes are happening in the timeline Those reports are coming there and day wise If you want, you can also take it day wise. Brother what was the sales on 21st January 2019 Right on the 22nd, anything on the 21st There was no sales, maybe it was a holiday on the 22nd What was the sales on 23rd What was the sales on 24th You can get the daily sales here I will do it one by one and give you a clear time line so I'll get you like this so you You can set your timeline here. What to display in Ear Display What you want to do is up to you and The timeline is also same here you can see it You can give different designs here See which color and style you want in this too The report is a connection between two tables at the same time If you have to put another table here

50:06 I have to insert it like I did in the slicer I told you so here it is with two tables Can link report connection bean There is an option here to display the order date is happening you want its not the header You can remove the header if it is displayed You have to keep it, you have to remove the selection label If you don't want the selection level then you removed it I want to remove the time level so this time level removed see from here Once you don't want scroll bars scroll bar or just a little bit to make it smaller or compact you You can use it to show and hide The right selection tool can do these things If you don't want the header then remove the header as well you can so it depends on how you like it How to keep formatting and its style If you want to keep all the things then you can keep them So you have got the idea that brother timeline Basically when is it used and why is it used and how to use it

50:51 Where can you provide formatting What other results appear on the timeline You can see it immediately from your timeline here Here is the list of that particular year you get the report so this was Timeline chapter now moving on to the next chapter Mounting [music] Now it's time for grouping in PO table and Custom Grouping Learning Chapter Number File Right so first of all drink on top of this data we insert the table but this time I PO table will not insert with mouse I will do it using the keyboard, that means I will write here I click on insert then on PO table When you click, this dialog box comes up. I want to do it with keyboard so I am following these simple steps for you Do this also, press alt button on keyboard As you press the alt button, look up H for Home, End Page Lad for Insert for p and here i for insert n if so, I press n on the keyboard

51:39 After pressing right then alt, then n After that I am here for the peer table this is the same dialog box alt and v You can use sequential shortcut key like this Press the Pure Table dialog box to appear. I am done here asistify that you know i have a I selected the cell here and pressed OK now. You can see the PO table has arrived here come on PO, has someone come to table number two Don't let anything come from your number, we have nothing yet No issues at the moment we are placing the order here Drag the date and drop it on the rose Like I did when I dragged the order date to If you drop it then give this date and month like this Things have arrived i.e. here month wise Grouping is default Jan F March If the default grouping is not visible near you

52:26 The fault comes on month wise automatic date It tracks the date if you track it ho here in rose so now i am going to ungroup it If I want to do it then I can just control it here I will press the root button, remember control root

…