Hi guys, this is a new type of post for me Formula Friday. Every Friday I will blog on a formula or function in Excel. I'm looking forward to this new posting schedule. Today's post will be the...
Tag: Excel Tips
Excel can be customized in many ways to make you work more efficient. One of the ways to achieve this is to change the location of where Excel automatically saves your files. File...
I find there are times when you do need to start right again from scratch with a Pivot Table, but removing all of the column fields, row fields, data fields, filters etc can take time. Excel of...
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...
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...
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...