课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

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

Connecting a value to a shape

Connecting a value to a shape - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

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

Connecting a value to a shape

“

- [Instructor] Sometimes when we're tracking data, especially if it's got a lot of moving pieces, we want our bottom line big and bold. Here, we're planning an event. We've got our guest list, the number of guests, expenses, the budget, the total so far, the difference, food costs, a lot of information. We want to know, over budget or under budget? Let's tie that to a shape. We start with equals if, open parentheses. If this difference is greater than or equal to zero, then comma, double quote, under budget. And then I want to hit the Windows key and the period and I want the sunglasses. Go back here, double quote, comma. If that's not true, then I want double quote over budget and what emoji do I want? Let's get this grimace. Double quote and close parentheses. Okay, and Enter. Right now we are under budget by over $1,800. Now the shape. Go to Insert, Illustrations, Shapes. I'm going to grab the rectangle with the…

内容