Power User vs Top feature in Pivot Table – Part 4

Sort by your report other than A to Z

In the previous section I’ve talked about how to sort or filter your report. But in this time, it is slightly different. You might have a certain arrangement of how you would like your report to be. Not everytime you would want to sort the report in the most ordinary way. You may have a few items that you would like to be listed at the top and some to be at the bottom. There are just a few ways for you to achieve how the way that you wanted to. Let’s check it out:

a) You can use the drag and drop way to arrange the item. This is how you can do it:

Continue reading “Power User vs Top feature in Pivot Table – Part 4”

Power User vs Top feature in Pivot Table – Part 3

Sorting and Filtering Pivot Report

Sort and filter button will automatically add into your Pivot Table once you start creating it. It is part of the feature in Pivot Table. The sorting feature confuses a lot of my student, many times. The first thing that confuses them what should they do first while sorting? I totally understand this. Simply because if you take a good look at the structure of the Pivot Table, as you add many more fields into the report, all you get it one Filter button for Row fields and another one for Column fields.

I will start real slow, so at the end of this section you have got to be confuse no more! I will be using the Pivot report as shown below as the example for this section.

Continue reading “Power User vs Top feature in Pivot Table – Part 3”

Power User vs Top feature in Pivot Table – Part 2

Ways of inserting Pivot Table

a) There are many ways to connect your data to Pivot Table. One of the most mainstream way to insert Pivot Table is hitting the “Pivot Table” command from the “Insert” tab.

b) You also can find the “Summarized with Pivot Table” under the “Table Tools” tab. You will only be able to find this table after converting the range of data into a form of Table. Plus, the cursor must be active within the Table region in order to enabling the “Table Tools Tab”.

Continue reading “Power User vs Top feature in Pivot Table – Part 2”

Power User vs Top feature in Pivot Table – Part 1

So, in this series of articles I’m going to share with you some Top features in Pivot Table you gotta know! Same as everybody else out there, I’m a self-taught Excel user. When I started my first job, I was being requested to use Excel to sort out some report. That’s my first encounter with Excel. Never in my life I have actually being properly taught how to execute tasks in Excel, mostly are trial and error.

Still, I have not come across Pivot Table this tool until much much much later, when I started my career as an Excel instructor. I kid you not, the tasks that I carried out in my earlier of my career life with Excel are nothing much, besides involving insane amount of manual cross check data, sorting, cutting and pasting information. Those tasks pretty much have becoming like a routine for me, almost every day I will be doing the same thing over and over and over again. Sometimes I get curious about some of the other tools in Excel, but I rarely have time explore those tools. You will hear some people say Excel is a very powerful tool, but for me, I didn’t think it was. Simply because of what I have been doing is not other than Ctrl + C Ctrl + V. That was what Excel meant to me.

Continue reading “Power User vs Top feature in Pivot Table – Part 1”

VLOOKUP 101 PART 6

Comparing Old List and New List

Have you ever wonder in what way you can find out the difference in between a new list and old list? Often my student came running to me saying they get confuse where should the VLOOKUP be ?

Don’t Panic! First you must know what you want. If you get a very clear picture of what you want, then your problem should be solved. Anyways, whenever the topic of comparing the new list with old list is when you want to find out which are the new products, which are the old products. Or you could be searching which is the new customer and which is the old customer.

Continue reading “VLOOKUP 101 PART 6”