From the course: Excel Power User Challenge

Unlock this course with a free trial

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

Match Zodiac Signs

Match Zodiac Signs

- [Narrator] Let me say upfront that I am not espousing the Zodiac signs. If that's your thing, great. If you hate it or whatever, I'm not pushing it. I just think that this would be a really cool Excel exercise. That's the only reason we're here. Alright, so we have seven people in column B and we would like to know what their Zodiac signs are, just out of curiosity. Is Beverly a Taurus, a Gemini, Aquarius? That's the challenge. Get the Zodiac signs, the name, not the symbol or the dates or the ram, right? You just want to know if somebody's an Aries, a Libra or whatever, all right? It's going to take some effort, but you up for it. (light music) Okay, here's how we're going to do this. You're going to see some cool stuff. Now I'm going to need some room, put that there. Now watch this, Aries, Taurus, great. Enter, haha. Flash fill with the hookup. Slide that over. Now we need the dates, watch this.…

Contents