The Power of Excel Power Query

Have a look at what Excel Power Query can do for you.

Its a boon for the Excel users who regularly work with the raw data and spend hours in clearing, formatting and repairing it.

Power query can do a lot of repetitive task for you without any VBA macro programming.