Speaker 1: TikTok where it's like making like a whole assignment schedule in Excel. I thought that was pretty cool idea for all your classes to be kind of in one spreadsheet and you can say okay is this done, is this not done. I couldn't really find a video on YouTube of how to kind of do it or like a tutorial on TikTok so I figured I'd just kind of make one for y'all real quick and show you how nice and simple and easy it is and then add something that might be a little bit more complicated but really helps out in the long run. So first things first I want to have a date, I want to have the assignment that's due, and then I want status. Is it completed, is it not completed, whatever. So I want to also start with I'm gonna basically pretend I'm going in order of syllabus so I'm gonna do one class and then I'm gonna do the next class and I'm gonna do the next class. So let me go ahead and just start with my first class. I'm gonna say it's my math class. So on today I have a math assignment due. Oh I wish I could spell math assignment due. Okay and then we have another one due on the 4th. So this is assignment, I'm gonna say another math assignment. Sure. Okay and then we actually have our first exam on the 10th. So math exam and then kind of continuing on I'll add a few more. On the 12th we have our next math assignment and then on the 14th we have our first math quiz and that kind of gives us a good basis for math right. I'm gonna go ahead and skip a line and I'm gonna say okay I also have a business course. And on the 1st of September we have our first Connect assignment due for chapter 1 right. And then we have our next Connect assignment, our next Connect assignment. I'm gonna go ahead and pre-fill that but I'm gonna change that to chapter 2 right. And then turns out we have our first exam on the 25th. So I'm gonna say business exam and then on the 27th we have another Connect assignment due for chapter, chapter 3 okay. And I'm gonna say okay I'm gonna put one other class in here. You can do this for as many classes as you need. I'm gonna say this is for my English class right. So on 830 we had a getting to know you short essay due okay. And then on the 2nd we had we're gonna have our first thesis or let's get say essay idea due. And we actually don't have to include the word due because that's the whole point. And then we have on the 4th we have a discussion post due. And turns out um we also have another discussion post due on the 6th. I'm gonna leave it at that. So this is all great but we see how like these are coming into our status. If you just double click on right in between B and C it'll automatically size it to that biggest box. And so this is all great but it's kind of bland. So I'm gonna add I'm gonna say okay my math class I'm gonna highlight that box in a blue. And I'm gonna make sure that I'm the color coordinate this so I know this is my legend okay. This is math is blue. And then I'm gonna say okay business I'm gonna make sure we have that all selected. Business I'm gonna do a nice green color okay. And so then I'm gonna highlight this business. And then for my English class I'm gonna do a nice orange. Why not? And that's for my English class. Okay so now we have a nice legend out here to the side. What we don't have is we don't have everything in order. We just have our assignments there. So what I'm gonna do is we're gonna highlight all of this and we're gonna come over to data. In fact actually you don't even have to go to data you can just come right here to sort and filter. And we're gonna do a custom sort and we're gonna say okay we want to sort it by our date column from oldest to newest okay. And then you see that those spaces are gone now but we have everything in order by date and what assignments. If you want to end it here that is perfectly fine. Simple, easy, everything to look at. You can say like you can just put a Y in here and then boom it's done. However I want to show y'all a cool little thing I found out the other day with adding checkboxes. So not everyone probably has a setup yet but there's this developer tab. If you don't have this it's really easy to set up. If you're on Mac you're gonna click on Excel and you're gonna go to preferences. Let me see if the let me probably because I'm trying to type. Okay we're gonna go to Excel and then preferences. What you're gonna do is you're gonna come over to your ribbon and toolbar and you're just gonna say click developer and then save right. If you're on like Windows or PC essentially the same thing except for I believe it's under file and then option preferences. Same kind of idea. So we're gonna come to this developer tab and there's this checkbox and I'm gonna say okay I want that checks checkbox right here. I'm gonna put it right in there. I'm gonna go ahead and I don't want all the text so I'm just gonna I'm gonna take that out right and then I'm gonna size it in there. I'm gonna size it so it kind of fits right in there perfectly right. Okay I'm gonna command C or if you're on a Mac oh sorry we want to copy that all right and then we're just gonna come oh getting too close. We're just gonna come and we're gonna paste that and we're just gonna put a bunch of those right in here. You can do this for each one or whatever you feel like is most important. They're getting kind of close together. So what we could do is we could resize these. If you two finger click or right click and do row height we can make these bigger and we'll say um let's go ahead and make those maybe like double that so 32. Okay there we go. I'm gonna bring this down here for the sake of this video. Oh hold on let's select the whole thing. Row height 32. Okay there we go. For the sake of this video I'm not gonna do the all the checkboxes. It is a bit time-consuming to set up but in the end so worth it. So I'm gonna put that there. I don't want to check that. Put that there. Come on check that one real quick. Oh I keep checking all of them. Okay and then put that one kind of right in the middle there. All right so I think this is probably the coolest part but I'm gonna right click or two finger click if you're on Mac and do format control. And I'm gonna say okay I want to link it to this box right here. And then I say okay. Just kidding. Hold on guys. You want to link it to the box next to it. So we want D to. Sorry about that. Press okay. And so it'll pop true up right here when it's checked and false when it's not. After doing this we want to create a conditional formatting. So I'm gonna click on this box and I'm gonna create a conditional format. So I'm gonna create a new rule and it's gonna be a classic rule where we use our own formula. We're gonna create an if statement. It's gonna be equals if and our statement is if D to right here equals true then true and then just false as the last statement. Put this in there exactly based and the only thing that really needs to change is the cell. And we're gonna say we're gonna custom format and we're gonna say okay when that is when this clicks to true right here we want it to strike through whatever assignment we just finished. Okay so now watch this. I click the checks box and that assignment is completed. It's done which is really cool right? And then if it's not done don't worry it goes back. And so you can do this for each box that you have and then when you're done if you want you can just right click or two finger click and we can hide this so then that's not there you don't see it. You just see okay it's done it's not done it's done it's not done. And then you can just do that for all your assignments. It is a little bit time-consuming if you want to do the check boxes but it might be worth it for some. Let me know if y'all got if you have any questions come ask the MTs or the counselors. Thank y'all.