Build a DYNAMIC budget with POWER QUERY

GRAB THE TEMPLATE → https://tinyurl.com/2372fnph

---------------------------------------------------------------------------
Learn every single feature in Excel with my newest course: https://www.yourcfoguy.com/courses/ev...
---------------------------------------------------------------------------
Access 100+ accounting & finance templates: https://www.modelwiz.com
---------------------------------------------------------------------------

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
https://www.yourcfoguy.com

➡️ Subscribe to my Newsletter!
https://www.yourcfoguy.com/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