She is a rising and highly engaging trainer. She has been involved in training Microsoft Windows 8 and Windows Phone development and design Microsoft Student Partners (MSP) for a year. Within her first year venture into the training industry, she is now highly sought after by banking, investment firms and high-tech industries; to execute competent Microsoft Office training. She specializes in delivering Office Word, Office Excel, Excel BI and Office PowerPoint training, having most of the occasion delivering beyond client expectations of what defines a training.
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:
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.
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”.
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
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
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.