Improving Excel with Python (May 2022)
Knowledge base

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

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

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

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

Excel Top Tip #12 - The ICAEW Spreadsheet Competency Framework
Frequently Asked Questions, by phone

Extract transactions with wrapped balance figures on a printed bank statement


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

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

Can't copy and paste from a Barclays bank statement PDF
Copying and pasting gives different text - Extracting transactions from encrypted bank statements

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


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

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

Excel Top Tip #8 - Improve Excel with Python

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

Excel Top Tip #6 - Build your professional toolkit

Excel Top Tip #5 - Ask and learn

Excel Top Tip #4 - Categorise acronym variations


Bank statement extraction
Excel Top Tip #3 - Picking apart formulas
How can StatementReader help bookkeepers?
How can StatementReader help solicitors?


Convert PDF tables to Excel
How can StatementReader help insolvency practitioners/forensic accountants?

Excel Top Tip #2 – See the structure


StatementReader: Support best practice
The first "Excel Top Tips – a monthly helping hand from StatementReader" email


How can I change the date of the opening and closing balance?


What do the summary graphs show?


How do bounced transactions affect other analysis areas?


How do excluded transactions affect other analysis areas?


How do I analyse transactions for multiple bank accounts together?


How do I identify missing words from the transaction narrative?


What does the rolling average section of the analysis show?


How are bounced transactions identified?


How to extract transactions from Barclays bank statements that have been printed by a branch
How do I set up the analysis options and switch between profiles?
Step by step guide to categorising transactions automatically with StatementReader
Can I see a full page sample for bank templates?
Can I save the analysis options to a profile?
How to install and setup StatementReader
What are the recommended scanner settings for a Konica Minolta Bizhub 36 scanner?
What are the recommended scanner settings for a Canon C2225i scanner?
What are the recommended scanner settings for a Fujitsu Document Scanner ScanSnap iX500 scanner?
What are the recommended scanner settings for a Canon C7570i scanner?
What are the recommended scanner settings for a Konica Minolta Bizhub 423 scanner?
What are the recommended general scanner settings?
How do I change the minimum percentage for identifying month on month credit trends?