12
Power Query
In a book about nuances and quirks in Excel, I have saved what I consider to be the most nuanced and quirky feature for last: Power Query. I can attest that I picked up and sat down with Power Query multiple times over a series of months before it finally clicked for me. This feature has been around for 10 years, yet most Excel users are unaware of its immense potential.
In this chapter, my goal is to help you use Power Query to automate repetitive processes without writing any programming code. I only have room to share a few examples with you, but along the way, I’ll point out a variety of obstacles and timesavers that will jumpstart your effectiveness. If you find this chapter whets your appetite, Power Query Cookbook, by Andrea ...
Get Exploring Microsoft Excel's Hidden Treasures 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.
