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

A selection of bank templates from India and UAE have been added in the latest release of StatementReader - helping you to get more...

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 are the latest templates to be added to StatementReader for banks from UK, UAE, Switzerland, Hong Kong, India, USA, New Zealand:...

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

My starter scripts in January 2021: Track changes in Excel My most hated feature of Excel is tracked changes. Tracked changes in Excel...

My starter scripts in January 2021: Set the file attributes for multiple Excel files Setting file attributes for multiple files in one...