How to make a calendar with Excel?

How to make a concise and practical calendar in Excel?

Seeing those complicated tutorials on the Internet, do you think one is bigger than the other? Today, I will teach you a very simple method.

In fact, Excel itself is a very powerful tool, and many functions are ready-made. It depends on whether you can find it without a function.

As shown in the figure, the calendar is completed in several simple steps:

First, we open the file in the New tab.

At this point, we can see that in addition to the blank workbook in the upper left corner, there are various work template tables, including a school calendar (any year):

Click on the template:

At this point, we will find that there is already a calendar in Excel, and we can also change the year. As the year changes, the following dates will be updated synchronously:

In addition, you can insert a memo under the date:

How's it going? Is this a simple and practical way to make a calendar?

In fact, there are many very useful templates in the new template, such as basic flow chart, student curriculum arrangement and other forms:

The template is simple, generous, convenient and practical. You don't have to scratch your head to think about functions in the future. You can go to Xinjian to see if there is already a template in Excel ~

Did you learn how to make a calendar in Excel today?

You are welcome to leave a message and tell me your problems or puzzles in learning excel, and I will actively try my best to answer them ~