“Power Query can automate this entire thing. It can…” — Learn Microsoft Excel with MyExcelOnline at 22:20
“Power Query can automate this entire thing. It can consolidate multiple sheets. It can consolidate multiple workbooks. It can unpivot data so it's ready to put into a pivot table. It has so many uses. It's insane. And it's also built into Power BI and many other Microsoft products. It'll even be coming online via…”
0:00
40:19