What It Feels Like When You Finally “Get” Excel Power Query…
Published in
2 min readMar 6, 2018
Honestly, this is literally what it feels like when the dots connect.
Why?
Because you actually, at that moment, realize the massive waste of time that you previously lived with shaping data in Excel AND you see the potential of what you can now do (that was impossible, or simply too tedious to do before).
Get Started
In this post, I’m rounding up my prior Medium posts specific to Power Query.
These are “real” examples, as well as content I have summarized to learn the basics (just the basics…) of Power Query.
Pick posts that interest you and get started! I will keep this updated as I add new posts to share.
Basics
- Microsoft Excel — Introduction to Power Query Excel Add-In
- Microsoft Excel — Sharing Power Query Queries Between Excel Workbooks
- Microsoft Excel — 1 Essential Power Query Design Step
- Microsoft Excel — The Simplest Way to Understand PowerQuery
- Microsoft Excel: Create a State / Region Lookup Table in 5 Minutes with Power Query
Intermediate
Use Case Applications
- Microsoft Excel: PowerQuery to Flexible Content Dashboard
- Microsoft Excel — Power Query Use Case Walkthrough (Part 1)
- Microsoft Excel: Basic PowerQuery — Stock Price Data From Google Sheets
- Microsoft Excel — RSS News Feed Into Excel Using Power Query?
- MS Excel: 4 Creative Power Query Data Source Approaches to Consider (Part 1)
- Microsoft Excel — The #PowerQuery Challenge
- Microsoft Excel — #BitCoin and Power Query
- Microsoft Excel — The Possibilities With Power Query (#Investing)
Let me know in the comments which posts you find most useful!
