课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

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

Key features of an effective data tracker

Key features of an effective data tracker - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

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

Key features of an effective data tracker

“

- [Instructor] Let's look at some key features of a solid data tracker. This tracker was built to help a nonprofit get details about a mail campaign that they had. Over in columns M and N you see the expenses? There was stationary, postage and Ink-jet ink. In the center, we have the donations and they're listed as they came in. We have the donations total in cells D15 and 16, and the cost, and then the net gain. And right now we see that it costs 25 cents to raise every dollar. And this is important for a nonprofit to know, because what if they spent $3,500 in order to get the 4,321.70? Then it would be a lot more than 25 cents to raise a dollar. The first thing that makes this a solid tracker is data is in as few places as possible. For the donations, as they come in, it would be tempting to have the donations by month on different tabs, a May tab, on April tab, et cetera. That would be great if you wanted to see at a…

内容