From the course: Excel: Analytics Tips

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Power Query tools

Power Query tools - Microsoft Excel Tutorial

From the course: Excel: Analytics Tips

Start my 1-month free trial Buy for my team

Power Query tools

“

and walk you through a quick and brief introduction to one of the most powerful tools in Excel called Power Query. This is a four-star, advanced analytics tip. We're going to talk about how to connect, shape, transform and load data from external sources into Excel using these Power Query tools. you may see Get & Transform and it all means the same thing. I'm using Office 365 Pro Plus and this is what I see in my Data tab. I've got a group of tools called Get & Transform data and a Get Data command off to the left. And what we're going to do in this demo is connect to a flat CSV flat, note that you can also connect to database sources or web APIs and so on and so forth. In this case, we're going to keep it simple. I've made this file available as part of the course. Basically, we're going to do a quick analysis of some Kickstarter campaign data. So once we point to the file, we'll see this Query preview and then click Edit to launch our Query Editor. And this will open as a separate…

Contents