课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

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

Challenge: Building a data tracker for event details

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

课程: Excel: Tracking Data Easily and Efficiently

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

Challenge: Building a data tracker for event details

“

(upbeat music) - Your challenge is to build in alerts and controls in this workbook as we track the event details. Here's some things we need to pay attention to. In cell J1, it says that we have a minimum of 21 days if we want to change to a larger venue. Cell H2 says that there are 110 days until the event. We see that the max capacity is a hundred and so far we have 23 guests. 27 people have RSVP'd for a total of 50, so we're halfway to the maximum capacity. Also, notice in cell C6, there's a question mark that should not be. Here are the objectives. Ensure that the attending column only accepts Y or N. Ensure that the guest column will only accept whole numbers because we can't have 1.8 guests. We can't have L guess, and then we need some type of indication that we are within 25 days of the event. So you're going to have to change this number and make sure that it works so where maybe you get down to nine, we…

内容