Speaker 1: In this tutorial I'm going to show you how to create a calendar in Excel, and there are several ways you can do this, but let's look at the easiest method, but I'll also throw in some exciting features and options that I think you'll like. So let's say you're just in Excel like I am here. The first thing I would do to create a calendar is go to the File tab here in the upper left and click, and then go down to the New button. When you click on that it gives you the option for a blank workbook and some other options, but I'm going to browse down the page a ways, and you can see that there are some templates that you can use. There are some budgets, some invoices, and there also are some calendars. So I'm going to go here to Academic Calendar, and I'll click on that. And by the way, if you don't see this particular calendar, or if you want to find other calendars, you can just go up here to the top, search for Online Templates, and type in Calendar, and it will give you many, many more options besides those that I have installed by default on my computer. But anyway, I'm just going to go down and choose the Academic Calendar. Just double-click on it. It brings up a preview, and then I can click Create, and here is my Academic Calendar. As you can see, the template puts in some default dates for parent- teacher conferences and things like that. You may want to delete that if it doesn't match reality, which it probably won't. Up at the top of this calendar, you can see that by default it has the current year. But if I want to, I can change this to, let's say, 2021. Now watch what happens to the dates on the calendar. When I tap Enter, they adjust. And so this is a great built-in feature to these Excel calendar templates, that whatever year you put into this cell, it matches the date numbers and the days. And so that's why I think far and away this is the best way to create a calendar in Excel. It just saves you a tremendous amount of work. Now what if you don't start in August? You can just click here on August, and maybe you want your calendar to start in the month of January. That's okay. You can just go up, choose January, and everything adjusts. But again, this is an academic calendar, and in the United States that generally means August would be the first month. I love that fact that you can just change it, and this Excel template just adjusts the dates and the days. So I'm going to browse down to, let's say, August 17th. Let's say this is the first day of school. Notice that the way that this template is built, in addition to the number underneath it, there's a big cell in which you can type whatever the event is. So I'm going to type in first day of school, and then if I browse down, you'll notice even though I selected August, the rest of the months are here. It just starts with August. So I can browse down to, let's say, the month of May, May 28th, last day of school. I'm going to browse back up to the top, and let's go into September. Let's say every Friday in September there's going to be a pop quiz. Okay, so I can click and type that, and then I could just click away, and then go back and hold ctrl and tap C to copy that, and then I'll just paste that same event onto every Friday in September. And let's say that every Tuesday homework is due. Same kind of thing. I could just do ctrl C, ctrl V to paste. Alright, so you get the idea. You just click, type the events for each of these days. If there is an event, I'll just put assembly here on the 21st of August, but you just fill in those events. You can even put the times in there if you want, and this calendar is coming together nicely. If you want to dress it up a little bit, you can. You could click and drag to highlight a particular month, and then here on the page layout tab, if you want, you could change the colors. You could pull in some themes. So those are some options that you have, but I'm going to undo those changes and just get back to the default that came with the template. I think it looks good the way it is. Now at this point, I've got a nice calendar. I could save this. I could share it with people digitally if I want to, but in some cases you're going to want to print. In order to print, you just click File, Print. Alternatively, you can also hold ctrl and tap P, and it takes you to the print interface, and it gives you a nice preview of what the calendar will look like when printed. And I think this is going to look great. There's September with all the homework and pop quizzes. Poor unfortunate students. There's August with the assembly and the first day of school. So this is print ready. Now I wanted to show you another option that you have. One thing you could do to make your events stand out a little bit is you could use some conditional formatting, and it's actually pretty easy to do this. All you would have to do is select the entire spreadsheet. If you hold ctrl and tap A, it selects the entire spreadsheet. So ctrl A, and then go here to the Home tab, Home ribbon, in the Styles group, look for Conditional Formatting. If you click there, there's an option for Highlight Cells Rules, Text That Contains. So I want to look for text that contains the word quiz. If it does contain the word quiz, then I want to highlight it with yellow fill with dark yellow text. So I click OK. Let's see if it worked. Let's go to September. There you can see that the cell background now is in yellow, and the text is dark yellow. So that helps to draw attention to the days with quizzes, at least if you're printing in color or if you're sharing the calendar digitally. What about homework? I could do the same exact thing. Ctrl A to select everything, Conditional Formatting, Highlight Cells Rules, Text That Contains, Homework. By default, it wants to format it with light red fill with dark red text, but I'm going to change that. I'm going to go to Custom Format, and I can just go here to the fill and choose a different color. I can even change the pattern style if I want to, and then click OK. That doesn't look very good in my opinion, so I'm going to undo that. But the idea is that you can actually create your own custom color schemes and custom formats. Here on Font, I can change the automatic color of the actual text itself. So let's say dark green border. Do I want it to have a border or not? I'll say yes. Let's have an outline, and then fill. Let's fill it with orange. Click OK. Click OK. Again, I'm not thrilled with my choice, so I'm going to go up here to Conditional Formatting, and this time, instead of going to Highlight Cells Rules, I'm going to go down to the very bottom where it says Manage Rules, and there I can change the options that I picked. So this particular one here, I'm going to double click on it, and I'll click Format, and even though that didn't look totally familiar, it is basically the same information that I put in before. So I click OK, click OK, click Apply, and OK, and that's a little bit better. Okay, so I've got Homework Due, I've got Pop Quizzes there. Now let's say in the month of November, let's say on this day here, what is that, Wednesday, there's a Pop Quiz. I tap Enter, and immediately it's formatted based on the rule that I set up. What if there's Homework Due on this particular day? I can type in Homework, and it formats it appropriately. So Conditional Formatting in this case can be great for color coding your Excel calendars. Thanks for watching. I hope you found this tutorial to be helpful. If you did, please click the Like button below, and consider connecting with me on my social media accounts like Facebook, Pinterest, and Twitter. And definitely do subscribe to my YouTube channel for more videos about technology for teachers and students. And when you do subscribe, click the bell next to the Subscribe button. That way you'll be notified whenever I post another video, and watch for a new video from me at least every Monday. If you'd like to support my channel, become a supporter of mine through my Patreon account, and you'll see a link to that in the description below.