13 Mind Blowing Power Query Features to Automate Your Excel Work (Beginners Tutorial Part II)

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: http://www.youtube.com/@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: https://www.linkedin.com/in/joshaharonoff Twitter: https://www.twitter.com/yourcfoguy #Excel #ExcelExpert #MasterExcel #ExcelTips #Accounting #Finance #financials #accountingprofessionals #Tutorial #yourcfoguy