Knowledge base

My starter scripts in January 2021: List Excel file attributes in Excel File attributes of Excel files (the file properties accessible on...

My starter scripts in January 2021: Split Excel file into separate files As an extension on yesterday’s problem (combining multiple Excel...

My starter scripts in January 2021: Combine multiple Excel files from a folder I always advocate finding a problem early on when picking...

We have now removed the need to have Excel installed on the user's machine; this improves the availability and stability of...

My exploratory data analysis of Land Registry data in November 2020: The highest number of inter-country transfers over a 5-year period...

My exploratory data analysis of Land Registry data in November 2020: Pairs of companies with the highest number of transfers over 5 years...

My exploratory data analysis of Land Registry data in November 2020: Ownership history for St. Pauls House, Church Street, Canterbury -...

My exploratory data analysis of Land Registry data in November 2020: Country preference for property ownership by region This graph forms...

My exploratory data analysis of Land Registry data in November 2020: A snapshot of properties in England and Wales with overseas...

My exploratory data analysis of Land Registry data in November 2020: Overseas companies that own property in England and Wales This...

Here is the email sent to all subscribers on 19 November 2020. To receive Excel top tips just like this, you can subscribe by clicking...

Here is the email sent to all subscribers on 24 September 2020. To receive Excel top tips just like this, you can subscribe by clicking...

OCR is important for StatementReader to start with the right text in the right place on the page - a high quality OCR engine means far...

Here is the email sent to all subscribers on 28 August 2020. To receive Excel top tips just like this, you can subscribe by clicking...

Company status by month

Length of company name by year of incorporation

Number of Incorporations by City from January 2020

Number of active companies in top 9 SIC codes (ranked by max-min spread)

Change in 'Mortgages.NumMortOutstanding' for top cities (ranked by the number of companies changing)

Here is the email sent to all subscribers on 23 July 2020. To receive Excel top tips just like this, you can subscribe by clicking here....