Download the practice files from this video here: 👇
http://yourcfoguy.kit.com/13-things-power-query?utm_medium=video-description&utm_source=youtube&utm_campaign=13-thing-power-query
---------------------------------------------------------------------------
Step-by-step Power Query follow-along guide here: 👇
https://docs.google.com/document/d/1quHb6nXMn3CtTem3K7wTrEhFCugE8eESj0emAOmNCTg/edit?usp=sharing
---------------------------------------------------------------------------
Access 100+ accounting & finance templates: https://www.modelwiz.com
---------------------------------------------------------------------------
Power Query has totally changed the way I work in Excel, saving me what feels like thousands of hours!
In this tutorial, I'll show you 13 mind-blowing Power Query features that will help you automate your spreadsheets and transform your data with just a few clicks.
Learn everything from extracting data from tables and folders to creating custom columns, merging queries, and building powerful pivot tables.
⏱️ Timestamps:
00:00 Intro
00:30 What Power Query is?
02:17 Power Query Feature 1 - Extracting Data From Table
02:57 Power Query Feature 2 - Loading Data Back as a Table
05:12 Power Query Feature 3 - Extracting Data From a File
07:55 Power Query Feature 4 - Extracting Data From a Folder
09:38 Power Query Feature 5 - Deleting Columns
10:14 Power Query Feature 6 - Filtering Data
10:30 Power Query Feature 7 - Adding A New Column
12:10 Power Query Feature 8 - Make Edits via M Code
13:58 Power Query Feature 9 - Merging in Column
17:40 Power Query Feature 10 - Extract Data From a Named Range
19:50 Power Query Feature 11 - Unpivotting Data
21:15 Power Query Feature 12 - Loading Back as a Pivottable
24:15 Power Query Feature 13 - Loading Data Into The Data Model
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 #financialanalysis #Finance #FinanceAndAccounting #Accounting #AccountingProfessionals # Tutorial #YourCFOGuy