A chart in Excel can say a lot more than a sheet full of numbers. Learn more about Excel charting!.
Posts by Barbara
Happy Formula Friday!. This Friday we are a bit stuck in the middle, yes you guessed it - its MEDIAN time. As you probably know, the MEAN is a useful way to summarise a group of numbers. But...
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...
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...