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


Imagine you’ve managed to convert your bank statement data into Excel but it’s all jumbled.

Maybe your columns are combined or spread out; perhaps your rows only represent a line from your PDF rather than each transaction. Maybe headers, footers and other unnecessary content like ‘page totals’ ‘brought forward’ are still present when you want them removed.

Tidy data leads to tidy analysis; if your transactions are in order, you’re equipped to make better strategic decisions and inform your client on how best to proceed.