I liken finding Power Query in Excel for the first time to finding Narnia. A magical place… but hard to find, and maybe a little confusing.
If you’re not familiar, Power Query is an extract-transform-load (ETL) tool directly available inside Excel (and Power BI). If you’re not sure what ETL is — you’re in luck! If you want to learn how to actually find, let alone use Power Query — this is for you too.
This 30-day checklist provides a curated learning path through the best blog posts, videos and more across the web.
Sign up below for the checklist and access to my resource library: 👇
If you’re already subscribed, you’ll find this resource in the learning-guides-and-checklists folder of the library.
This 30-day learning checklist is your curated playlist to gain an understanding of Power Query from the ground up. Consider it a “best of” free web content on this majestic tool. You’ll learn, among other things:
- How Power Query serves as an extract-transform-load tool
- How to connect your first data to Power Query and navigate the interface
- How to sort, filter, aggregate and merge data, along with other common data manipulation tasks
- How to work with folders of files, websites and other data sources
From here, you’ll have a beat on the most reputable names in Power Query for Excel and know where to go for more help.
To get the checklist, subscribe below. This will give you access to my entire resource library, with other checklists, demos and more.
Get the checklist here 👇
I look forward to seeing what you do in Power Query with Excel. Tell me about it in the comments, or share your favorite Power Query for Excel resources. Have ideas for other learning guides? I can take those too 😊.
Leave a Reply