The ‘The Excel Experts’guide to Excel Errors

2018-02-19T20:33:26+00:00

'The Excel Experts' guide to Excel Errors Whether you’re a seasoned Excel professional, a casual spreadsheet user or anything in between, the chances are you’ve experienced one or two problems when using Excel formulas. Errors in your formulas can get in the way of what you’re trying to do, make [...]

Order Tracking and Invoicing Spreadsheet

2017-10-15T14:48:30+00:00

Order Tracking and Invoicing System We built the Order tracking and Invoicing system for a film processing agency that wanted to keep track of their clients orders as they passed through their factory. Information from the arrival package was scanned into the system and the relevant information extracted and stored in an [...]

Property Portfolio Management Spreadsheet

2018-02-19T20:34:11+00:00

Property Portfolio Management Spreadsheets Using Excel Dashboards, we built the property portfolio workbook for an estate agency, to help them to keep track of their clients’ property portfolios and investments. The idea  […]

Daily work orders updated automatically in Excel

2018-02-19T20:34:59+00:00

Daily work orders updated automatically in Excel Drawing data from one spreadsheet and inserting it into another spreadsheet is a very common and time consuming process in the business environment.  A process that can be speeded up considerably using vba to automate the process.  This is easier the more standard the [...]