Excel takes a snapshot of your data set when you create a Pivot Table report and stores it in a pivot cache. This is just an area where your data source is duplicated for easy access, this is...
Recent Posts
When you need to sort and rank a field within a large number of data items it can be confusing to determine the ranking of the data you are looking at if the list is too long, or you may want to turn...
I really do not like the way when you create a Pivot Table and add multiple fields to the Row or Column Label areas, subtotals are shown at the the top for outer fields. This just does not sit well...
This tip is one my most favorite time savers when using Pivot Tables- the ability to create many reports with just a few mouse clicks. The scenario for this example is the national sales manager...
A really common task used frequently in Excel is to compare two lists to highlight items that appear in one list but are not in the other. Here is a great way to combine two great Excel features to...
This tip is really useful for Excel dashboards or anywhere that space is of a premium on a worksheet or, where your data set is just too large to comfortably display. Let's look at using a scroll...