Win £12,000 at TRA Golf Day
We're dusting off the golf clubs and getting ready for The Recycling Association's golf day, which takes place after the association's...
MTD for VAT reporting
There have been several documents published over the last few months on the subject of Making Tax Digital for VAT. The following article,...
Excel Custom Number Formats
Over the coming weeks we are going to show you how to create custom number formats in Excel. In this first blog we will explain the...
Comparing Lists
Sometimes it is necessary to compare information that is contained in two lists to see if there is duplication in the two lists. To...
Excessive Rows (and/or Columns)
Have you ever opened a spreadsheet and noticed that there seems to be thousands of rows (and/or columns - we will only discuss rows in...
Printing - Multiple Pages from a single worksheet
Often when we are creating an Excel based report, we need to print various sections. If all the information is contained within one...
Formulas not calculating
One problem that we are asked about on a fairly regular basis is to do with formulas not calculating in a spreadsheet. We will not go in...
MID Formula
This post follows on from our post dated 2 June 2017 and deals with extracting data from the middle of a string of information....
Drop Down List Defaults to Middle or Bottom?
One of the quirks in Excel that we have come across is when creating a Drop Down Data Validation List ("Drop Down DV List") the listing...
Extract text before a space
Often when data has been downloaded in Excel there is information in a cell that you would like to split in to two different cells so...
