Improving Excel with Python (May 2022)
Knowledge base

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

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

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

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

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

- 1 min
Extract transactions with wrapped balance figures on a printed bank statement


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

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

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

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


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

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

- 2 min
Excel Top Tip #8 - Improve Excel with Python

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

- 3 min
Excel Top Tip #6 - Build your professional toolkit

- 2 min
Excel Top Tip #5 - Ask and learn

- 1 min
Excel Top Tip #4 - Categorise acronym variations