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…
Download the excel file and follow along! Following on from my last article on how Power Query can be used in Finance departments to increase efficiency, we created a report and automated the lookup for product category. By creating a Power Query report we will save time and effort every time we create this report.…
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.…
Budget season is well underway and there isn’t a doubt that it is a long protracted and tiring exercise for all departments involved. But what can we do to prevent budget season woes? But what are the key elements to a smooth and successful budget season? Timetable & Planning Lets face it, the key to…