What are Some Practical Uses for Excel?

Video Transcript

"Hello, my name is Eric White and we're going to talk about some practical uses for Excel. Now, I've opened up Microsoft Excel here and I've put a date, thirteenth of November and the day of the week. I'm not really sure if that's a Monday, but for this demonstration it's a Monday. So let's say I want to know the next, oh I don't know, thirty days after. Excel allowed me to plot the date range and it automatically filled in the boxes for me. Now let's say I want to know how many days are in this. Well let's go ahead and I'm going to continue to pull this down so that I don't know it's thirty. Let's just drop it down there, o.k. So now I want to know how many days o.k. So I'm going to do a sum, but I'm going to do a special sum, more functions and I'm going to do account A. And what this does is it counts the numbers of cells in a range that are not empty. So I'm going to hit o.k. Now it's asking me for the range, I'm just going to pick all the way down to the bottom. O.k., that's fine, and then just hit o.k. It counted the total number of days right there, one hundred and thirty seven. Now let's say, o.k. I got a hundred and thirty seven days and food costs me thirty five dollars a day. So I want to know how much food is going to cost me for these hundred and thirty seven days. So what I'm going to do is I'm going to make this cell equal with this cell times this cell. So for the next thirty seven days it's going to cost me four thousand seven hundred and ninety five dollars to eat. Wow, I'm not going to be hungry. So that's just one example. You can figure dates out, you can do budgeting, you can reference cells. You can do your bills, you know, you could list your rent and your electric and your gas and your car payment and then how much you get paid. And you can list, let's say your rent's eight hundred dollars and your electric is four hundred, and your gas is fifty and your car payment is three fifty. You can total these up, auto sum, hit enter and let's say you make two thousand dollars a month, and you can get the difference, equals your paid minus your bill total. that means you got four hundred dollars that you can be sticking in your savings account. These are just a few ways that Excel is practical or some practical uses for Excel maybe."