课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Solution: Building a data tracker for event details

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

课程: Excel: Tracking Data Easily and Efficiently

开始一个月试用 购买团队方案

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.…

内容