Have you come across a data set that looks a bit like this?. The source data in your Pivot Table is not as clean as it should be with a slight variation in spelling that is a right pain in the...
Category: Blog
Eliminate (or reduce) Errors by Using Your Own Auto Correct.
Here is another time saving tip for you today, Excel not only has autocorrect, but you can instruct it to insert the correct words for you, even if you shorten them to a few letters, to save time...
Here is a really great way of displaying a micro (or easily resizeable) chart in Excel. It makes use of the Camera Tool. Sometimes hidden, Camera is a tool that is really useful but not that many...
Formula Friday – Create A Dynamic Pivot Table Data Source Using OFFSET and COUNTA Functions
Happy Friday Excellers..... Pivot Tables are great for taking hundreds or even thousands of rows of data and be able to summarise and analyse your data set with a few clicks of your mouse, if...
Formula Friday – Create A Dynamic Report Header Using The Concatenate Function
I like to automate processes as much as possible and creating report headers for updated monthly reports are no exception to this. If you have the same headers every month, but only the Month name...
Friday Formula Fun Time..... Do you find that your VLOOKUPS are sluggish sometimes when you are dealing with larger data sets?. Here is a way to speed them up....use 2 VLOOKUPS at a...