课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

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

Hidden sheets

Hidden sheets - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

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

Hidden sheets

“

- [Instructor] Here's a form that's doing a lot of things, right? So we've got room for 10 orders, and then go here. And in this column, the data is in the table. And in this column I have a dropdown list and I want to order red replacement hands. It's pulling up the price, it's giving me a detail. And then I want 10, enter. We've retrieved a discount rate and we've calculated the final price based on the discount. And all of that magic is happening over on this sheet. We've got a lot of details. Here are all of the items. Details about the items, their prices. Over here is where we have the discount grid. And then here are notes that we have. Okay? Clock B will be discontinued. Local pickups should only be arranged through the 38th Street store and we don't need this information hanging out all the time. If we are using it ourselves, we don't want to accidentally be over here. If we pass this over to someone…

内容