From the course: Excel Challenges

Unlock this course with a free trial

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

Stack and group data

Stack and group data - Microsoft Excel Tutorial

From the course: Excel Challenges

Start my 1-month free trial Buy for my team

Stack and group data

“

- [Instructor] In this workbook, we've got three worksheets. We've got one for people who took decorative soldering, and then textured glass, and tactical design. Let's go back. We want to know, who are the people who took all three classes and have earned a special certificate? We can see at the top, Simon Almasi in this course, Simon Almasi, and Simon again. So we know there's one person at least. Are there any more? And notice, these pictures are from me. I'm making a kaleidoscope. I've been working with stained glass. So let's have a little fun and incorporate my hobby into Excel. And hopefully you're doing similar, incorporating Excel into your life and not just work, right? Pause the video. List the people who've earned the certificate. (upbeat music) Let's do it. First of all, hopefully you noticed that I gave you the hookup. I'm going to click inside this dataset, go to Table Design. This one is called soldering. The next one, glass, and tactical design. This table name is…

Contents