I’m ashamed to admit I’m one of those who initially thought of Power Query as being a toy for hardcore financial modelling, or manipulating enormous data sets within multinational companies.
This may be because these are often the sort of examples provided. It’s very easy as a busy finance professional in a small or medium finance team to assume based on this that there are better things to spend your time on.
It was only after my second attempt at learning Power Query that I truly grasped how revolutionary it could be for all finance professionals and teams. If you use Excel to do anything at all, the chances are Power Query will allow you to do it better. In this article I’ve set out four areas where knowledge of a bit of Power Query could transform your professional life.Continue reading “Why you need Power Query even if you don’t use Big Data”