Learn how to create a dynamic Actual vs Budget comparison in Excel — even if your Actual and Budget data are in separate files. In this step-by-step tutorial, you’ll learn how to: Import data from multiple Excel workbooks using Power Query Append and merge Actual and Budget datasets Add a column to identify source (Actual/Budget) Build a Pivot Table to compare Actual vs Budget Calculate Variance and % Variance Automate monthly updates with a single click Why this matters: If you prepare performance reports, sales analysis, or financial dashboards, this method will save hours of manual work every month. Chapters 00:00 – Introduction 01:00 – Exercise files 01:30 – Loading data to power query 05:00 – Loading data in power pivot 06:30 – Set up DAX measures 08:25 – Dashboard 13:00 – Test monthly refresh Download Files Social Channels: IG: FB: LinkedIn: X: Other interesting videos: Learn excel dashboard in 5 simple steps: Master Lookup functions: Power Query: Excel: #Excel #PowerQuery #PivotTable #ActualvsBudget #ExcelTutorial #DataAnalysis