1
00:00:13,450 --> 00:00:14,290
Hi, everyone.

2
00:00:14,320 --> 00:00:23,860
And today we are going to explain the Microsoft Excel template, the objectives of this lecture is knowing

3
00:00:23,860 --> 00:00:30,000
templates, templates, types, templates, importance and templates applications.

4
00:00:31,210 --> 00:00:36,040
So why we should use templates because templates already.

5
00:00:36,550 --> 00:00:44,270
Three, save your time, save your effort, improve your daily life management and optimize your life.

6
00:00:44,980 --> 00:00:53,830
So this is a blank of picture of templates and template usage.

7
00:00:54,280 --> 00:01:01,720
And you can find templates from ready templates from Microsoft Excel by using file tape.

8
00:01:02,020 --> 00:01:04,560
You suggested search.

9
00:01:04,820 --> 00:01:12,640
OK, OK, let's get started with one of the most important personal budget templates.

10
00:01:12,640 --> 00:01:15,590
And this templates is personal.

11
00:01:15,610 --> 00:01:16,930
Monthly budget.

12
00:01:19,660 --> 00:01:27,910
Here is our template today about personal monthly budget worksheet to track your projected and actual

13
00:01:27,910 --> 00:01:31,450
monthly income and projected actual cost.

14
00:01:32,080 --> 00:01:41,350
So the first step is to enter your expenses in various categories and the respective tables, projected

15
00:01:41,350 --> 00:01:45,100
balance, actual balance and difference are calculated.

16
00:01:45,280 --> 00:01:48,950
So let's get started and choose this template.

17
00:01:50,020 --> 00:01:58,900
The first thing you should to do is to enter your projected monthly income here and projected extra

18
00:01:58,900 --> 00:02:03,100
income here and the total will be automatically calculated here.

19
00:02:03,940 --> 00:02:12,310
Also, you should enter your income, actual monthly income here and extra income here, and the total

20
00:02:12,310 --> 00:02:14,960
monthly income will be automatically calculated.

21
00:02:15,400 --> 00:02:22,620
Also, you should enter the various categories of your daily or monthly expenses.

22
00:02:23,440 --> 00:02:34,180
For example, according to housing, you should enter your projected cost and actual cost and difference

23
00:02:34,180 --> 00:02:35,730
will be automatically calculated.

24
00:02:35,850 --> 00:02:44,710
OK, so for rent, enter the rent, the phone, electricity, gas, water, cable, waste removal,

25
00:02:44,710 --> 00:02:50,770
maintenance supplies and other expenses, projected cost and actual cost.

26
00:02:50,890 --> 00:03:01,210
OK, and for entertainment, for videos, Sidis movies, concerts, sports events and so on.

27
00:03:01,210 --> 00:03:08,020
And also projected cost and actual cost and difference will be automatically calculated and so on for

28
00:03:08,020 --> 00:03:16,300
transportation, vehicle payment, insurance, vehicle payment, insurance, field maintenance, projected

29
00:03:16,300 --> 00:03:22,030
cost and actual cost loans, personal student credit card and others.

30
00:03:22,030 --> 00:03:28,420
Projected cost and actual cost also for insurance for your home health life.

31
00:03:28,420 --> 00:03:34,600
Other for enter projected cost and actual cost and the difference will be automatically calculated.

32
00:03:35,590 --> 00:03:38,170
Taxes in the same way.

33
00:03:38,170 --> 00:03:46,840
Federal, state, local food, groceries, drink out others saving or investment retirement account

34
00:03:46,840 --> 00:03:53,770
investment account and to the cost and actual cost also bets, food, medical, grooming, toys, others

35
00:03:54,250 --> 00:04:03,800
and to predict the cost and actual cost, charity and donation similarly to that previous category.

36
00:04:04,240 --> 00:04:15,150
OK, and enter legal and personal care about medical clothing, hair, health club, dry cleaning and

37
00:04:15,160 --> 00:04:16,060
user fees.

38
00:04:16,570 --> 00:04:22,550
All this cost is projected cost and actual cost.

39
00:04:23,290 --> 00:04:30,940
And finally, you will find the total projected cost in this to all the previous projected tab will

40
00:04:30,940 --> 00:04:34,450
be some up here and calculated totally here.

41
00:04:35,590 --> 00:04:43,270
Similarly, the total actual cost will be automatically calculated for all previous categories based

42
00:04:43,270 --> 00:04:45,460
on your expenses and your costs.

43
00:04:45,970 --> 00:04:53,920
And the total difference here are just the difference between the total projected cost and actual rejected

44
00:04:53,920 --> 00:04:54,190
cost.

45
00:04:54,470 --> 00:04:55,470
Okay, okay.

46
00:04:57,370 --> 00:05:00,520
And here there is projected balance.

47
00:05:00,520 --> 00:05:04,210
Projected balance is a projected income minus expenses.

48
00:05:04,540 --> 00:05:09,240
So you will find this calculation based on two terms.

49
00:05:09,460 --> 00:05:16,330
The first term is your total monthly income and the second term is your

50
00:05:19,240 --> 00:05:20,770
total projected cost.

51
00:05:21,200 --> 00:05:22,230
OK, OK.

52
00:05:23,500 --> 00:05:28,990
Also, you will find the actual balance here, actual income minus expenses.

53
00:05:29,170 --> 00:05:32,080
So they are calculated here are based in two terms.

54
00:05:32,230 --> 00:05:39,640
The first term is your total monthly income and the second term is.

55
00:05:41,450 --> 00:05:42,680
Total actual cost.

56
00:05:42,920 --> 00:05:44,270
OK, OK.

57
00:05:45,500 --> 00:05:52,250
Also, you will find the difference and the difference here is just actual minus projected.

58
00:05:52,850 --> 00:05:57,280
So this is about the personal monthly budget.

59
00:05:57,620 --> 00:06:05,030
You can calculate your projected balance, projected income, your expenses, your actual income, your

60
00:06:06,770 --> 00:06:12,350
actual expenses and the difference between actual and projected.

61
00:06:12,770 --> 00:06:13,460
Thank you.

62
00:06:13,460 --> 00:06:15,590
And to you in the next Tremblant.