Power Query is one of the most important updates in the history of Excel. What once seemed impossible or would require VBA is now very simple. Understanding the role of Power Query will change the way you work with data.
This chapter will walk through several examples of how you can use Power Query to streamline tasks and prepare data for analysis. Be ready! You will never work the same way again.