SUPERFAST Variance Analysis with Power Query & Dynamic Arrays in Excel 

Sign up for our free Insiders program and get the example file: exceloffthegrid.com/insiders File Reference for this video: 0232 Quick Variance Analysis

This is a fantastic video on Payroll Variance Analysis that you can literally use at work. Thanks Mark.

I have been loading the named range into a query to create a parameter. I didn't realize you could do it direct! 🤯

Brilliant video! I've been designing a payroll variance analysis tool in PowerQuery all week. Perfect timing! and thank you

This is amazing! I always learn new techniques that help streamline my work! Thank you so much for sharing! ☺

It is a fairly refined method, much more practical than doing it in "wild mode" using functions, without using Power Query. Thank you, Mark.

That is some crazy efficiency there and some great business wisdom about the purpose of the analysis. Thank you!

Another great video showing how far one can go with cleverly setting up the workflow!

Love the new setup Mark.

Very useful! Thanks

Great video !! Great integrated solution !! ✌

This is brilliant ❤

Amazing and very very useful 👌

Brilliant 👍❤, thanks Mark

Thanks Mark Brilliant!

quick and clean 👍

Spot on!

Great video

Brilliant Mark, thanks!

This is awesome. Thanks much

Love it 👍

Can you use groupby function instead of hstack and compute each column?

Why do you do the hashes after cell references (in SUMIFS, for example)?

Now i know value of the hash #. Better than using a table?

This is great if you have reports coming in on an expected cadence, but I’m wondering if you have a solution to do this same thing with previous versions of the file on SharePoint through its past history of updates for 1 wk/1 mo/1 yr?

❤❤❤