From the course: Excel Weekly Challenge

Unlock this course with a free trial

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

List and inspect survey results

List and inspect survey results - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

List and inspect survey results

where we teach music history, music theory, and we would like to start some ensembles, and we've asked the students what styles they would like to learn, and here are the results. So if we scroll down, we see we have 46 responses. Now the question is, how many unique entries do we have? So that's when your help is needed. In Column F, create a list of the unique entries that are in Column C, and inspect that list to see if there's anything weird, any misspellings or inconsistent formatting. So pause the video, generate that list, come back, and I'll show you a solution. Okay, you're back, okay, there are a lot of different ways to do that. I'm going to do that with a pivot table. So I'm going to click inside the dataset, z� go to Insert, Pivot Table, yes, I want it on a new sheet, okay. Now, what music would you like to learn? Put that in rows, and I'm going to take this list of unique entries, Copy, I'm going to bring it over here into Column F. Right-click, Paste As Values. And…

Contents