课程: Excel Weekly Challenge

免费学习该课程！

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

Add a shape

Add a shape - Microsoft Excel教程

课程: Excel Weekly Challenge

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

Add a shape

“

- This is pretty neat. We want to insert a shape, and then have that shape show the total revenue. And it's got to be variable. Check this out. I'm going to change this to 1,000. Our shape updates. But also, prevent the shape from moving around, because this gets annoying. Watch, I'm going to double-click. No, I want the shape to stay in one place. Alright, pause the video. Pull up the exercise file. Work it out. Come back, and we'll go through it. Alright, you're back. Let's do this thang. Okay, we're going to go to Insert. Insert a shape. Whatever shape we want. Let's go back to this one. Alright, now we need a sum of the revenue. I'm going to put that here. Equals, sum, open parenthesis, this Revenue column, Enter. To connect our shape to that value, we have to select a shape. Go to the formula bar. Equals, and then select a value. Enter. It's beautiful. Slide it over a bit. Okay, so I'm…

内容