From the course: Excel: Working Together with Power Query and Power Pivot

Unlock the full course today

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

Use a query to cleanse data

Use a query to cleanse data

From the course: Excel: Working Together with Power Query and Power Pivot

Start my 1-month free trial Buy for my team

Use a query to cleanse data

“

- [Instructor] Before we start using our data for analytical purposes, we really should clean it up first. Now, cleaning it up can mean many different things, everything from say changing column headings to splitting columns and that kind of thing. But how about we explore this a little bit further using a couple of examples. To make it easier to understand these concepts, make sure that you have the Excel file open for this movie, and then go ahead and click on query and then select edit, which opens the query editor. Now remember, when using the query editor here, it's only a preview. So any changes that we make don't actually impact the underlying data, which is the CSV file that we have linked to. Under home here, you'll see that we have quite a few different options here for editing and transforming our data. But what we're going to do is select transform to bring up some more advanced options. Now let's start…

Contents