From the course: Excel: Working Together with Power Query and Power Pivot
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Enhance your query
From the course: Excel: Working Together with Power Query and Power Pivot
Enhance your query
- [Instructor] Once you've cleansed your data, did you know that there are tons of ways to enhance your query, making it even easier to analyze later on? Let's explore a few. Make sure that the Excel file for this video is open. And then go ahead and click on Query, and then Edit to open up the query editor. What you'll notice here is that for every transaction, there's a make and a model. For example, we have the Nissan Leaf. Now, I like to make it clear at a glance, which one you switch. So take a look at this neat feature. Let's go ahead and select the Make column, and go ahead and click on Transform. Now let's click on Format and then select Upper Case. You'll see that all of the makes have been changed from title case to upper case. And you'll see that the applied step has been created off to the right called upper case text. Now let's go ahead and look at the very first column, which is the clean alternative fuel…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.