From the course: Excel Power User Challenge

Unlock this course with a free trial

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

Errant choices

Errant choices - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Errant choices

“

- [Instructor] What do you know? People aren't always cooperative. We asked people to list three color choices. Angelo down to Whitley that you see in column B. We asked them pick color choices from the available so that then later we can do some analysis and make some decisions. But we always have to check data quality. Are there any color choices in column C that are not available? That's where your help is needed. Notice Angelo picked charcoal. Yes, charcoal is available. Tangerine, yes. Tangerine's available. And lime as well. But what about any others? Pause the video, find any people who chose unavailable colors. Get that list and come on back. (upbeat music) Welcome back. Let's fish out any errant choices. First, I am going to put my cursor in this dataset. Right + click, get data from table slash range. We are going into Power Query. I'm going to boost this up and then highlight the color choice column.…

Contents