SUPERFAST Variance Analysis with Power Query & Dynamic Arrays in Excel

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Get the example file ★ Sign up for our free Insiders program and get the example file: https://exceloffthegrid.com/insiders-signup/ File Reference for this video: 0232 Quick Variance Analysis.zip ★ About this video ★ In this video, we build a tool for performing monthly variance analysis super fast. All we have to do, is change a date and click Refresh All. INCLUDES: 0:00 Introduction 0:18 Scenario 0:40 Dynamic file path 2:23 Load the data 5:16 Variance calculation 8:28: Using the solution 9:24 Wrap up ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: https://twitter.com/exceloffthegrid #MsExcel