Knowledge base

1 min read

Improving Excel with Python (May 2022)

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

1 min read

Excel Top Tip #16 - Test yourself cleaning data in Excel? (part 2)

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

2 min read

Excel Top Tip #15 - How would you solve these 6 challenges in Excel?

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

2 min read

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

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

3 min read

Excel Top Tip #13 - The ICAEW Spreadsheet Competency Framework (part 2)

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

2 min read

Excel Top Tip #12 - The ICAEW Spreadsheet Competency Framework

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

2 min read

Frequently Asked Questions, by phone

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

1 min read

Extract transactions with wrapped balance figures on a printed bank statement

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

1 min read

New extraction ability: Two dates per transaction (like in ABN AMRO bank statements)

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

2 min read

Excel Top Tip #11 - Do you use Excel's new functions?

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

1 min read

Can't copy and paste from a Barclays bank statement PDF

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

1 min read

Copying and pasting gives different text - Extracting transactions from encrypted bank statements

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

2 min read

Excel Top Tip #10 - Hide #N/A, #VALUE and #DIV/0, and more tips

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

1 min read

Lloyds TSB duplicate bank template - Extracting a PDF with a scanned image and searchable text

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

2 min read

Excel Top Tip #9 - Level up in four new areas

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

2 min read

Excel Top Tip #8 - Improve Excel with Python

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

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

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

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