Knowledge base

Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing...

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

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

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

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

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

How do you work with your clients? Quickly get to know more about how we do business with some points we live by: Supporting new users...

Ever come across a bank statement with transactions that flow to the next line? These are tricky to extract into Excel, as the last...

A statement format that looks nice, but makes extracting transactions difficult is showing two dates in the same column like this: See...

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

If you can't select the text in your PDF bank statement, then you have a scanned image. To extract your transactions with StatementReader...

Select the text from your PDF bank statement, copy, then paste into notepad - if you see gibberish or different characters in notepad,...

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

Lloyds TSB send out bank statements like this: Some of the text here is searchable, and some is an image, so the OCR engine skips the...

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

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

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

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

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