One of the most basic Excel function new users learn along with SUM, COUNT and MIN is the MAX function. However, in previous Excel years- 2003 and earlier, you had to actually type the MAX...
Category: Blog
Welcome again to Formula Friday, your pre weekend dose of Excel Formulaness. Ok so today we will look at the very basics of using the IF formula in particular how to check if one number is greater...
Excel Tip: Export More Than 65000 Lines From MS Access to MS Excel
This is a problem that I have asked about many times. From Excel 2007 onwards the capacity of Excel Rows is waaaaay more than previous versions (in fact it is 1,048,576!). So, why is...
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 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...