Hello, welcome back for another #Excel tip. Today let's take a look at how to use Custom Sorting in a Pivot Table. This is one tip I use all of the time, so I really wanted to share it with my subscribers. If you need to sort your Pivot Table by a sequence other than say Numeric or in Date order then this will be very useful. I need to sort my Pivot Tables on a regular basis by the products in order of importance to the business. You can see a sample of raw data … [Read more...]
Defer Data Updates In Your Excel Pivot Table. – Pivot Table Tip
by Barbara

Hello, Excellers. Today I want to show you a really quick Excel Pivot Table tip that might be very useful for you if you are updating or making changes to a large Pivot Table. You may already know that normally when a Pivot Table data field is added, removed, or moved to a different location the whole Pivot Table is recalculated. So, if you have a large dataset then it may take a little while to update the table. Did you know that you can edit and change your Pivot Table around without the … [Read more...]
How To Apply Conditional Formatting To An Excel Pivot Table – Correctly – Excel Tip
by Barbara

This next tip I know causes a bit of frustration with Excel users, based on the number of times I have been asked about it. It is applying conditional formatting to a Pivot Table. The method of applying conditional formatting to a Pivot Table is not the same as applying it to a regular data set. In a regular data set, you would probably use the method below to highlight all sales values above the average in the data set. This is all working well for us, with the conditional … [Read more...]
Pivot Table Tip- Assign The Correct Row And Column Labels Quickly
by Barbara

Hello Excellers, today I want to share with you a really good Excel Pivot Table Tip with you. Do you ever quickly create a Pivot Table, then end up with really naff labels on them. A bit like below? .. Both the row and column labels really are of no use to use. They look really bad don't you think?. Creating A Pivot Table. Here is a recap of how to create a quick Pivot Table. Select the data set you want to use for your table The first thing to do is put your cursor somewhere … [Read more...]
Excel Tip – How To Hide Negative Numbers In A Pivot Table
by Barbara

Hello Excellers, I have a handy Excel Pivot Table Tip for you today. I was creating a Pivot Table this week, (one of many!), and it contained negative numbers. Now, this was not the end of the world, but I really only wanted positive numbers to show in my Pivot Table. I did not want the either of the zeros or the negative numbers to be visible. This is a handy little Excel trick, so I thought I would share it with you. Here is a sample of the type of data set I was working on and how to hide … [Read more...]
- 1
- 2
- 3
- …
- 5
- Next Page »