1
00:00:14,140 --> 00:00:14,810
Hi, everyone.

2
00:00:15,250 --> 00:00:21,340
And today we are going to explore calenders, 10 bullets in Microsoft Excel.

3
00:00:21,880 --> 00:00:30,820
The objectives are knowing templates and importance of time and calendars where calendars can be applied

4
00:00:30,820 --> 00:00:32,220
for everything.

5
00:00:32,830 --> 00:00:41,320
So motivation to timbal estimates are awesome because if they are really free, save can save you time

6
00:00:41,320 --> 00:00:48,190
and save your effort also can improve your daily life and daily life organization and life management.

7
00:00:48,550 --> 00:00:55,660
Also, they can use it for your personal life optimization and your business optimization.

8
00:00:56,350 --> 00:01:02,050
And these templates are categorized for several applications.

9
00:01:02,590 --> 00:01:10,390
You can check all these templates by selecting type you suggested search.

10
00:01:11,440 --> 00:01:15,040
The first e-mail here is in your calendar with holidays.

11
00:01:15,220 --> 00:01:18,970
So the setting is for this template.

12
00:01:18,980 --> 00:01:23,370
You can have a calendar for any year, just change the year.

13
00:01:23,620 --> 00:01:28,000
So if you are in 2021, just select 2021.

14
00:01:28,000 --> 00:01:33,760
If you are in twenty, twenty, twenty two, just select twenty, twenty two.

15
00:01:33,970 --> 00:01:42,370
If you are in twenty, twenty three just select twenty, twenty three and and so on, you can select

16
00:01:42,400 --> 00:01:43,930
whatever you want.

17
00:01:44,150 --> 00:01:48,190
Also you will find that month is of this calendar.

18
00:01:48,520 --> 00:01:50,260
So this is January.

19
00:01:50,260 --> 00:01:51,670
And this is February.

20
00:01:51,670 --> 00:01:59,260
And this is March, April, May, June, July, August, September, October, November, December.

21
00:01:59,750 --> 00:02:09,340
OK, also you will find the holidays of this year, New Year's Day, Martin Luther King Day and Presidents

22
00:02:09,340 --> 00:02:13,930
Day and Memorial Day, Labor Day and so on.

23
00:02:13,930 --> 00:02:17,730
And the Christmas Day, Thanksgiving Day and so on.

24
00:02:17,740 --> 00:02:25,180
Also, you can edit these holidays and this time you can edit this time.

25
00:02:25,360 --> 00:02:33,010
And automatically when you edit these holidays, you will find the changes in the calendar days.

26
00:02:33,100 --> 00:02:35,290
OK, this is very simple.

27
00:02:35,740 --> 00:02:43,540
You just select the year after selecting the year, you can find the calendar within your hands.

28
00:02:43,540 --> 00:02:47,070
OK, also, this is simple.

29
00:02:47,080 --> 00:02:52,540
It is awesome because it shows the phases of the moon based on calendar.

30
00:02:52,750 --> 00:02:56,110
So you just select the year.

31
00:02:56,680 --> 00:03:06,190
Select the year we are in and when you select the year you will find that phases of the moon calendar

32
00:03:06,190 --> 00:03:14,140
for every month from January, February and March or April and so on its calendar.

33
00:03:14,320 --> 00:03:19,840
Also you will find the moon phases data and you can change this data accordingly.

34
00:03:19,840 --> 00:03:23,740
You will find the updated calendar phases moon here.

35
00:03:24,010 --> 00:03:28,690
So this is Osam template for Phases of the moon.

36
00:03:29,080 --> 00:03:35,170
If you want to find this template, you will find this template attached with the material within the

37
00:03:35,170 --> 00:03:35,590
video.

38
00:03:35,920 --> 00:03:46,270
Also, you can find this by searching for phases of the moon from here for you and from here.

39
00:03:46,270 --> 00:03:47,590
Search online template.

40
00:03:50,670 --> 00:03:54,390
And here is our template, click create.

41
00:03:56,600 --> 00:03:58,720
And here is the template line.

42
00:03:58,760 --> 00:03:59,190
OK.

43
00:04:00,180 --> 00:04:04,640
Also, this is an awesome template for any expenses calendar.

44
00:04:04,910 --> 00:04:10,580
You can write all your expenses based on calendar and based doing day or month.

45
00:04:10,590 --> 00:04:13,310
We agree you want to choose.

46
00:04:13,360 --> 00:04:21,470
OK, so if you have daily expenses, you can write down these expenses by day.

47
00:04:22,100 --> 00:04:27,940
For example, if you have expenses in February, our Friday.

48
00:04:27,980 --> 00:04:34,610
OK, write that you want to write the description you want and write the amount of the data you want

49
00:04:34,820 --> 00:04:41,330
and you will find this data is collected and summed up in this cell.

50
00:04:41,720 --> 00:04:51,480
And after this month you will find the total data will collected here by grand total and monthly total.

51
00:04:51,740 --> 00:04:59,730
Also, you can enter all your expenses over day by day and over the month of the year.

52
00:05:00,050 --> 00:05:08,570
So this is shit is awesome because you know your expenses based on day in day label, you just select

53
00:05:08,570 --> 00:05:10,850
the year and select the day.

54
00:05:10,850 --> 00:05:14,870
You want to enter the data and write the description.

55
00:05:14,870 --> 00:05:18,260
And the amount I hope this stimulates are great for you.

56
00:05:18,470 --> 00:05:19,030
Thank you.

57
00:05:19,040 --> 00:05:20,640
And see you in the next lecture.

58
00:05:20,720 --> 00:05:21,290
Thank you.