How to use Power Query to build a flexible budget model for revenue and CoGS


Details
Details
In this practical session Myles will work through a case study with the group, demonstrating how PowerQuery can be used to create a flexible budget model for revenue and CoGS.
After a brief overview of PowerQuery and a walkthrough of the model design, Myles will build out the model, explaining the techniques being used. The working files will be shared ahead of the session, so members will have the opportunity to work through the case during the session.
About the speaker
Myles is a co-founder of Full Stack Modeller, which provides Excel training for finance professionals through their award-winning training programme. He is also a Fractional Finance Director for three local companies and a CIMA accountant. He has been training in Excel for over 15 years.

How to use Power Query to build a flexible budget model for revenue and CoGS