课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

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

Solution: Building a tracker 2

Solution: Building a tracker 2 - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

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

Solution: Building a tracker 2

“

(bright music) - [Instructor] Hopefully, you've got your parachute, because here we go, three, two, one, arch! That's what they say when you go skydiving, they say, "Arch," when you do a tandem jump. Okay see, you just get all kind of bonuses with me. See, okay, okay, let me straighten up. All right, first of all, I am going to name a table, all right? And I'm not going to do all of these in order, and that's fine. Here we go, cursor inside this table. I'm going to call this payments, good. I'm going to put this data into a table, format as table. Let's grab this green to match the emojis. Okay, no filter buttons. What am I going to name this? Let's see, participation, great. So, let me do the cross for that next. I'm going to PD for paid, equals, sumifs, open parentheses, somewhat, sum the payments, comma, criteria range, friend column, comma, criteria, Addison, and enter. Convert this into currency. All right, so now…

内容