Are there any decent ways of learning more Excel? I am confident with pivots, V&H lookups, and a bit of coding but I would love to learn more. Are there seminars to go to that would help? Or advanced courses you can recommend?
Always try and be practical in your learning, going to seminars and attending advanced courses will improve your knowledge but it's the application of that knowledge that counts.
Create an opportunity - my knowledge has increased exponentially over the last couple of years (you will find this happens, one day, you'll be chugging along doing simple accounts/tasks, then somebody will ask you do something and everything snowballs after that). Here's the story:
However I contribute a lot of it down to this. One day I was on twitter and a small independent metal music company I followed was looking for accounting advice - I was still a student, so I offered my help, we got chatting and we discussed what he wanted.
He wanted more money for himself. So I made him a model. It was a really simple model, money in, money out, overheads, production costs for making music, his different income streams etc. I did a quick cashflow to see if there were periods where he would spend more money. When I was doing it, I would
google for the answers. Other people must be in a similar situation. It was as simple as that. I did it in my spare time. It was great because you would read up similar scenarios and ultimately their advice in the same situation. Development of knowledge.
So either find an opportunity or mess about with dummy figures. Think about the information you deal with on a daily basis and ask yourself how could you automate the tasks you currently do (macro?) - is there a better way to present it?
Just remember, if you're doing your exams, it's just the beginning. You're a mercenary for hire. Your skills are wanted out there.