Download the practice files from this video here: 👇 --------------------------------------------------------------------------- Step-by-step Power Query follow-along guide here: 👇 --------------------------------------------------------------------------- Access 100+ accounting & finance templates: --------------------------------------------------------------------------- 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 ➡️ Subscribe to my Newsletter! 🔗 FOLLOW ME ON SOCIAL Get updates or reach out to Get updates on our Social Media Profiles! LinkedIn: Twitter: #Excel #ExcelExpert #MasterExcel #ExcelTips #Accounting #Finance #financials #accountingprofessionals #Tutorial #yourcfoguy