CIB - Coverage Banking - How can I prepare?

I'm a compliance analyst, currently 4 months into a year long graduate programme. I'm very fortunate to have secured a corporate finance placement for 3 months in the actual FO! I plan to move outside of compliance once the year is over to a more befitting role in CF. Within my current bank. It seems more feasible this way.

However, how can I prepare?

I want to know what softwares you use, what things you do in excel, what course you think will be useful and so on!

I plan to study and do as much reading as possible.