If you’re like us and have had limited investment in the budgeting process, you’re probably using excel to produce your budgets. We now have over 300 cost centres and each cost centre manager owns and produces their budgets, making consolidation a nightmare! Up until recently, we used macros and vba to manage the collation of…
Over the last few years, our department at work have been looking at ways we can improve efficiency. As with many other finance departments our work is dominated by Excel. With quite a lot of repetitive tasks being undertaken in Excel. Power Query has literally changed how we approach a lot of tasks within Excel.…