Comprehensive list of things that you can do with Power Query.
Excel Power Query is one of the most powerful new features within Microsoft Excel and the easiest to learn.
You can use Power Query to clean & transform your data that you download from your ERP or accounting system and display it in a report for Excel to work with.
The best thing is that you can reapply the same transformation steps in just ONE single click, saving you HOURS! So next week when you get the same report with updated data, a simple REFRESH will transform your data once again!
As of October 2018, this interactive tutorial continues to be expanded, with 33 of the 50 topics completed. New topics are being added.