Build a DYNAMIC budget with POWER QUERY

---------------------------------------------------------------------------
---------------------------------------------------------------------------
---------------------------------------------------------------------------

Power Query is one of Excel's most powerful features. If you're not using it, you're likely wasting time on tasks that could be automated.

In this video, I'll demonstrate how to build a headcount forecast dashboard using two methods: the traditional manual way and using Power Query.

By comparing these approaches, you'll see firsthand how much time Power Query can save you.

⏱️ Timestamps
00:00 Intro
01:20 The Manual Way
01:45 Arranging The Source Data
04:30 Splitting The File Into 4 Different Files
05:43 Copying The Data Into Our Forecast File
07:17 Refreshing The Data Using The Manual Way
08:30 Recap The Manual Way
08:57 Introducing Power Query
10:59 Building The Headcount Forecast Using Power Query
11:30 Using The Power Query Editor
12:10 Adding Columns In The Power Query Editor
14:20 Merging In Power Query
16:03 Create References In Power Query
17:00 Loading Queries As A Table
17:37 Creating The Dashboard For Every Department
19:40 Consolidating All The Files And Printing The Table
20:49 Appending Queries
22:05 Populating The Headcount Dashboard
22:54 Ending Notes

ABOUT THIS CHANNEL
Looking to level up your career in Finance & Accounting? You're in the right place. Each week I upload videos around Accounting, FP&A, and Excel to help you grow in your career and learn something new.

⚡️ Check out my channel here: / @yourcfoguy
Don’t forget to subscribe!

🔎 FIND ME AT

➡️ Subscribe to my Newsletter!

🔗 FOLLOW ME ON SOCIAL
Get updates or reach out to Get updates on our Social Media Profiles!
LinkedIn: / joshaharonoff
Twitter: / yourcfoguy

#Excel #powerquery #powerquerytutorial #Finance #FinanceAndAccounting #Accounting #AccountingProfessionals # Tutorial #YourCFOGuy

[Junmarvi]

I’ve been doing the manual method for about 9 years, but over the past 5 months, after studying, watching YouTube (including your videos), learning online, and with the help of AI, I’ve been able to speed up my workflow. Now I can get my job done faster and still have time to relax. Thanks for sharing! Im planning to create similar videos to help my Filipino community in the Philippines, i’ll be using our own dialect to make it unique.:)

[catherinegreen]

Hello Pro CFO, I love the presentation; it is friendly - delivered professional insights.

Please remember my turkey wings this thanksgiving. There is so much to give thanks - is one of them.

[I_am_Magic_Mothae]

OMG I AM SO HAPPY I FOUND YOUR CONTENT, UOSKILING TO THE MOOM!!!🚀🚀🚀

[Gemdale]

Help, following your guide and its great except that when i create the new workbook none of my queries are listed - do i need to link them somehow or amend something in settings?

[dawoodkidwai]

Hey! Thanks for the video!

I’m actually working on the budget and we have like 7-8 departments. i’d create templates then let the H.O department head fill them and share it with me and then i’d with the help of xlookup and sumif consolidate all of these different files into one file and link it with their GL accounts 😂 and then from their on link this consolidation with my final company wide Ops+G&A file. Linking it with the income statement 😅 … lots and lots of manual work although i’ve a control point to monitor the errors but still very much prone to silly mistakes. I’d try using the power query now, hopefully it’ll help reduce the complexity and time. 😅

[scotolivera]

what about building full budget? not only for headcount

[richardhay]

I can do it with Dynamic Array funtions faster than I can with PQ.