Hello, Excellers. Welcome back to another #Excel Tip blog post. This Pivot Table blog will take you through the Drill Down feature in Excel Pivot Tables. When you create a Pivot Table in Excel, each of the values represents one line of data or record in that data set. The Pivot Table creates a summary of your data set. Let's use an example in this blog post. You can download the sample data set and Pivot Table, by clicking the download button below. I have a very simple data set and … [Read more...]
Excel Tip Custom Sorting Your Pivot Table.
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...]
Recommended Excel Resources
