1
00:00:14,230 --> 00:00:14,930
Hi, everyone.

2
00:00:15,340 --> 00:00:23,770
And today we are going to explain Microsoft Excel template so the objectives are knowing templates,

3
00:00:23,770 --> 00:00:29,500
templates, type templates, important templates, application and templates are awesome because it's

4
00:00:29,500 --> 00:00:30,490
really free.

5
00:00:30,880 --> 00:00:35,560
Save your time, save your effort, improve your daily life management, optimize your life.

6
00:00:35,740 --> 00:00:40,240
OK, and today we are going to explain a new template.

7
00:00:40,510 --> 00:00:45,220
And our template here is Personal Expenses Dashboard.

8
00:00:45,910 --> 00:00:52,930
So if you want to get this template, you can find this template attached in the material of this lecture.

9
00:00:53,200 --> 00:00:58,060
Also, you can find this template here in Microsoft Excel from File.

10
00:00:59,600 --> 00:01:14,900
New research by personal expenses enter and here is our final click and create, and this is our Today

11
00:01:15,260 --> 00:01:18,420
template about personal expenses dashboard.

12
00:01:18,680 --> 00:01:20,800
So how does it work?

13
00:01:23,360 --> 00:01:33,410
Open expanse, look, and when you open excellences look, you will find that category subcategory and

14
00:01:33,410 --> 00:01:34,000
amount.

15
00:01:34,370 --> 00:01:45,910
So you write the date and select category and you have daily fun housing, transport categories.

16
00:01:47,660 --> 00:01:56,090
Also, you have some category like cinema, clothing, contract, electricity, fail, gym, haircut

17
00:01:56,090 --> 00:02:09,500
and a great subway, sweets and etc. also in dollar and the amount you spend on this category.

18
00:02:09,750 --> 00:02:18,760
OK, and when you complete this data, you will find two dashboard.

19
00:02:19,010 --> 00:02:29,300
Just click on it or you can open the dashboard from here dashboard tab and you will find this chart.

20
00:02:29,300 --> 00:02:32,240
With this filters.

21
00:02:32,960 --> 00:02:34,580
You will find that.

22
00:02:34,580 --> 00:02:42,710
You will find category, you will find sub category and you just select the filter you want to slice.

23
00:02:42,890 --> 00:02:51,980
So if you want you do know your expenses in March, just select Marsch and here is your expenses and

24
00:02:51,980 --> 00:03:02,030
more if you want to know your expenses in April or May or August or July, OK.

25
00:03:03,290 --> 00:03:05,420
You just select the.

26
00:03:06,450 --> 00:03:13,470
Category, you want to slice, you want to filter, if you want to let all the filter and present all

27
00:03:13,470 --> 00:03:24,150
your data, just remove any filter from here, clear filter or I'll see here is your expenses over all

28
00:03:24,150 --> 00:03:24,830
categories.

29
00:03:25,320 --> 00:03:33,540
Also, if you want to know your daily expenses, if you want to look, if you want to know fun category,

30
00:03:33,540 --> 00:03:42,240
if you want to know transport category, housing category, if you want to clear all these categories

31
00:03:42,240 --> 00:03:42,770
from here.

32
00:03:43,260 --> 00:03:49,710
Also, if you want to know a subcategory specific subcategory your expenses for a specific category,

33
00:03:49,950 --> 00:03:53,140
just select from this list here.

34
00:03:53,340 --> 00:04:06,300
So I want to know our expenses for fail or for Jim or for haircut and Jim by pressing control.

35
00:04:06,300 --> 00:04:10,920
If you want to select two filters, just select control.

36
00:04:11,010 --> 00:04:18,840
So control landing for Jim Haircut if you want to also to add electricity.

37
00:04:19,680 --> 00:04:21,500
If you want to add cinema.

38
00:04:22,560 --> 00:04:25,350
Here is our expenses for cinema, Jim.

39
00:04:25,350 --> 00:04:31,740
Haircut, electricity, land, phone in all days in all main categories.

40
00:04:31,940 --> 00:04:36,830
OK, if you want to clear this filter of course from here.

41
00:04:38,730 --> 00:04:40,560
So it's amazing.

42
00:04:40,560 --> 00:04:43,550
It's amazing dashboard for your personal expenses.

43
00:04:43,560 --> 00:04:47,790
It's really it's a free please practice, please use it.

44
00:04:48,450 --> 00:04:51,030
So thank you and goodbye.