Hi, everyone.
And today we are going to explain Microsoft Excel template so the objectives are knowing templates,
templates, type templates, important templates, application and templates are awesome because it's
really free.
Save your time, save your effort, improve your daily life management, optimize your life.
OK, and today we are going to explain a new template.
And our template here is Personal Expenses Dashboard.
So if you want to get this template, you can find this template attached in the material of this lecture.
Also, you can find this template here in Microsoft Excel from File.
New research by personal expenses enter and here is our final click and create, and this is our Today
template about personal expenses dashboard.
So how does it work?
Open expanse, look, and when you open excellences look, you will find that category subcategory and
amount.
So you write the date and select category and you have daily fun housing, transport categories.
Also, you have some category like cinema, clothing, contract, electricity, fail, gym, haircut
and a great subway, sweets and etc. also in dollar and the amount you spend on this category.
OK, and when you complete this data, you will find two dashboard.
Just click on it or you can open the dashboard from here dashboard tab and you will find this chart.
With this filters.
You will find that.
You will find category, you will find sub category and you just select the filter you want to slice.
So if you want you do know your expenses in March, just select Marsch and here is your expenses and
more if you want to know your expenses in April or May or August or July, OK.
You just select the.
Category, you want to slice, you want to filter, if you want to let all the filter and present all
your data, just remove any filter from here, clear filter or I'll see here is your expenses over all
categories.
Also, if you want to know your daily expenses, if you want to look, if you want to know fun category,
if you want to know transport category, housing category, if you want to clear all these categories
from here.
Also, if you want to know a subcategory specific subcategory your expenses for a specific category,
just select from this list here.
So I want to know our expenses for fail or for Jim or for haircut and Jim by pressing control.
If you want to select two filters, just select control.
So control landing for Jim Haircut if you want to also to add electricity.
If you want to add cinema.
Here is our expenses for cinema, Jim.
Haircut, electricity, land, phone in all days in all main categories.
OK, if you want to clear this filter of course from here.
So it's amazing.
It's amazing dashboard for your personal expenses.
It's really it's a free please practice, please use it.
So thank you and goodbye.