From the course: Excel Weekly Challenge

Unlock this course with a free trial

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

Write a formula from nothing and create your own data

Write a formula from nothing and create your own data - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Write a formula from nothing and create your own data

“

- [Instructor] We've been asked to write a formula and we've got no data, but that's not going to stop us because you and I are good at Excel. The formula that we've been asked to write, if product category equals C and project manager equals Lauren, insert a blue pennant like the one in cell D2. To do this, generate at least 10 rows of fake data so that you can apply the formula and make sure that it works. Don't hard-code any values and be sure to test the result. Pause the video, work it out, come back, and I'll go through it. Okay, let's do it. While you were away, I made my fake data and I made sure to have at least one Lauren C combination. And there it is in row nine. Now the test column, and that's where the formula is going to be tested at. And one thing to check before we get going, go up to this pennant, that is a Wingdings font and a capital P, who are going to need to know that. Here we go. Equals…

Contents