From the course: Excel: Tracking Data Easily and Efficiently

Unlock the full course today

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

Solution: Building a data tracker for event details

Solution: Building a data tracker for event details - Microsoft Excel Tutorial

From the course: Excel: Tracking Data Easily and Efficiently

Start my 1-month free trial Buy for my team

Solution: Building a data tracker for event details

“

(upbeat music) (upbeat music) - [Instructor] So how'd you do? Hopefully, you did well and applied some of the things you've learned so far. But let me get into it. First, ensure that attending only accepts Y or N. Okay, I'm going to highlight here. And go to Data. Data Validation. List. I want to put capital Y comma capital N. And just in case and for Mac users, I'm going to put comma lowercase n comma lowercase y. And I'm going to make an error alert. Okay. And here we go. We have an error at this question mark. And I am going to put a t. Nope, didn't work. Cancel. All right. Andrea is a yes. All right. Now the Guests still in the data tab. Data Validation. Allow whole number between let's say 1 and 20. I don't think anybody's going to show up with a school bus to our event. Right, so click Okay. Now, and we test. Five, how about b? Didn't accept it. Cancel. All right.…

Contents