Excel Tip: Export And Save Your Entire Excel Workbook As A PDF
Converting an Excel work sheet or work book to a PDF document is a great way of sharing content without allowing other users to amend your work. From Excel 2010 onwards this is really easy to...
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...
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...
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...