Super Easy Budget vs Actual Comparison| Excel Project Demo

[@samuelodoom3952]

Great video. Please from your presentation, i realised when you made changes to the excel sheet on the right and consequently refreshed the second one, the adjustment took effect on the left one too. Meaning the two sheets are linked to each other. Can you please share with me how you linked both sheet. Thank you in advance.

[@ExcelSifu]

The source file is linked to the report via 'Get & Transform' There has an option to choose from another file. Upon refreshing, it will get the data from external source file. Hope this helps

[@TheID1997]

@@ExcelSifu is it availabel on 2016? where I can find it? is it on Data manager> transfermation file? Thanks

[@ExcelSifu]

@@TheID1997 yes. It's available on Excel 2016, Data, Get & Transform

[@userme2803]

Wrong way to calculate variance. Accounting101, for budget, the var is Budget-Actual

[@ExcelSifu]

Thanks for your correction on Accounting 101. 🙏🏻