Excel How to Combine Multiple Workbooks Using Power Query

VBA has been known as the sole approach in consolidating data from different workbooks. Working with VBA makes one’s job easier especially when working some tasks which can’t be done in regular Excel interface. However, if you’re not into programming, you may end up of doing your task manually which, as we all know, will surely consume time and prone to errors.

With the help of Power Query, merging multiple workbooks into one becomes handy. Not only you can do this in just few clicks, but also you can ensure that you’re getting the right information. All you need to do is to put your workbooks in one folder and let the Power Query will do the consolidation for you.

Here’s the step by step guide on how you can achieve this.

PRACTICE FILES:
https://drive.google.com/drive/folder...

"Learn continually – there’s always “one more thing” to learn!"
Steve Jobs

*************************************************
Want to learn more about Excel?

SUBSCRIBE NOW:
   / @romeocostillas  

YouTube Playlist:
   • Excel Keyboard Shortcut Control Combi...  

Or visit me on Facebook at   / excelbyromeocostillas  

See you there!


Romeo Costillas
Microsoft Certified Solutions Associate BI Reporting
Microsoft Office Specialist Master
Microsoft Office Specialist Excel Expert
Microsoft Innovative Educator
Discrete Event Simulation Modeler


Tagalog Excel | Filipino | Pinoy Excel | Excel Tagalog Tutorial | Paano Gamitin ang Excel

#excelbyromeocostillas #Excel #ExcelTips