Summary
In this book about nuances and quirks in Microsoft Excel, I saved the most nuanced and quirky feature for last. Power Query can be a transformational tool for you if you can avoid getting stymied. I’ve shared several stumbling blocks that I hit during my learning curve. You should now be well prepared for most things that Power Query may try to throw at you.
In this chapter, you learned how to create a list of worksheets within any workbook, which you can then transform into an interactive index listing. It’s important to understand that Power Query does not offer real-time connections to data, but rather provides snapshots of the data that can be refreshed. Then, we transformed an Excel-based report from an accounting program into a streamlined, analysis-ready dataset.
If you’ve struggled to extract data from PDF files in the past, the ability to do so with Power Query may have you dancing in your chair. I know that being able to unpivot reports...