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.…