© The Author(s), under exclusive license to APress Media, LLC , part of Springer Nature 2021
A. MurrayAdvanced Excel Successhttps://doi.org/10.1007/978-1-4842-6467-6_5

5. Power Query – You Will Never Work the Same Way Again

Alan Murray1  
(1)
Ipswich, UK
 

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.

Introduction to Power Query

Power Query first appeared as an add-in in Excel 2013, named Power Query. And ...

Get Advanced Excel Success: A Practical Guide to Mastering Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.