Knowledge base

1 min read

Improving Excel with Python (Day 3 of 5)

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

1 min read

Improving Excel with Python (Day 2 of 5)

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

1 min read

Improving Excel with Python (Day 1 of 5)

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

1 min read

New: No Excel needed

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

1 min read

Land Registry Charts (Day 6 of 6)

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

1 min read

Land Registry Charts (Day 5 of 6)

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

1 min read

Land Registry Charts (Day 4 of 6)

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

1 min read

Land Registry Charts (Day 3 of 6)

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

1 min read

Land Registry Charts (Day 2 of 6)

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

1 min read

Land Registry Charts (Day 1 of 6)

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

2 min read

Excel Top Tip #7 - Set up Excel just for you

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...

3 min read

Excel Top Tip #6 - Build your professional toolkit

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...

1 min read

New offline OCR engine

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...

2 min read

Excel Top Tip #5 - Ask and learn

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...

1 min read

Companies House Charts (Day 5 of 5)

Company status by month

1 min read

Companies House Charts (Day 4 of 5)

Length of company name by year of incorporation

1 min read

Companies House Charts (Day 3 of 5)

Number of Incorporations by City from January 2020

1 min read

Companies House Charts (Day 2 of 5)

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

1 min read

Companies House Charts (Day 1 of 5)

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

1 min read

Excel Top Tip #4 - Categorise acronym variations

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....