Hi, everyone.
And today we are going to explain the Microsoft Excel template, the objectives of this lecture is knowing
templates, templates, types, templates, importance and templates applications.
So why we should use templates because templates already.
Three, save your time, save your effort, improve your daily life management and optimize your life.
So this is a blank of picture of templates and template usage.
And you can find templates from ready templates from Microsoft Excel by using file tape.
You suggested search.
OK, OK, let's get started with one of the most important personal budget templates.
And this templates is personal.
Monthly budget.
Here is our template today about personal monthly budget worksheet to track your projected and actual
monthly income and projected actual cost.
So the first step is to enter your expenses in various categories and the respective tables, projected
balance, actual balance and difference are calculated.
So let's get started and choose this template.
The first thing you should to do is to enter your projected monthly income here and projected extra
income here and the total will be automatically calculated here.
Also, you should enter your income, actual monthly income here and extra income here, and the total
monthly income will be automatically calculated.
Also, you should enter the various categories of your daily or monthly expenses.
For example, according to housing, you should enter your projected cost and actual cost and difference
will be automatically calculated.
OK, so for rent, enter the rent, the phone, electricity, gas, water, cable, waste removal,
maintenance supplies and other expenses, projected cost and actual cost.
OK, and for entertainment, for videos, Sidis movies, concerts, sports events and so on.
And also projected cost and actual cost and difference will be automatically calculated and so on for
transportation, vehicle payment, insurance, vehicle payment, insurance, field maintenance, projected
cost and actual cost loans, personal student credit card and others.
Projected cost and actual cost also for insurance for your home health life.
Other for enter projected cost and actual cost and the difference will be automatically calculated.
Taxes in the same way.
Federal, state, local food, groceries, drink out others saving or investment retirement account
investment account and to the cost and actual cost also bets, food, medical, grooming, toys, others
and to predict the cost and actual cost, charity and donation similarly to that previous category.
OK, and enter legal and personal care about medical clothing, hair, health club, dry cleaning and
user fees.
All this cost is projected cost and actual cost.
And finally, you will find the total projected cost in this to all the previous projected tab will
be some up here and calculated totally here.
Similarly, the total actual cost will be automatically calculated for all previous categories based
on your expenses and your costs.
And the total difference here are just the difference between the total projected cost and actual rejected
cost.
Okay, okay.
And here there is projected balance.
Projected balance is a projected income minus expenses.
So you will find this calculation based on two terms.
The first term is your total monthly income and the second term is your
total projected cost.
OK, OK.
Also, you will find the actual balance here, actual income minus expenses.
So they are calculated here are based in two terms.
The first term is your total monthly income and the second term is.
Total actual cost.
OK, OK.
Also, you will find the difference and the difference here is just actual minus projected.
So this is about the personal monthly budget.
You can calculate your projected balance, projected income, your expenses, your actual income, your
actual expenses and the difference between actual and projected.
Thank you.
And to you in the next Tremblant.