On Excel, you can create your own calendar from scratch or you can use a pre-built calendar template that Excel provides. There are templates ranging from 12-month calendars, monthly calendars, weekly calendars, and calendars that have notes. They are already formatted for you and you can add in your events right away.
It is easy to use one of these templates, you just need to choose the template you want and then add your schedule into it. You have the option of customizing your calendar by changing the size of the font, the style of the font, and the colors of the calendar. To learn how to use this function, I chose to do a monthly calendar for the month of November. After you select the calendar you want it will go directly onto your worksheet. Below is what it looks like when you first select the calendar. 
The title will usually say January, so to change this you click on the title and change the formula (shown in the above image in the formula bar) to the correct year, month, and date you want and then press enter and it will update for you. However, the numbers will not be in the correct days of the week (1 will always start on Sunday even if that is not correct) so you will need to re-number the dates. You can change the colors of your calendar by going to themes under the home tab and choose the color scheme you like best. Next, to add events into the calendar, you simply double-click on a date box and type in the event. This is a much easier way to create a calendar in Excel and it saves you a lot of time. These templates still look professional and they keep your events organized well.
I created a calendar for the month of November and added in my important assignments that are due in that month. I found it very straightforward and it produced a well-organized calendar for me that I will definitely be referring to for this busy month! I love that there is an option of getting a template because it saves you a lot of time not having to input all the features of a calendar and for those who like to customize their calendar, you still have the option to do so by changing the theme, color, fonts, and font size. I would definitely recommend using this feature provided by Excel for anyone who likes to create clean looking monthly and yearly calendars in a fast and easy way. Below is a picture of the calendar I created.
Thanks for reading and stay tuned for next weeks post on the pros and cons function!
References:
https://www.smartsheet.com/blog/easiest-way-make-calendar-excel
elissahalliday 