Welcome to Everyday Excel part 3. I'm really happy that you've decided to join for part 3, and hopefully you've decided to join for the entire Everyday Excel specialization. Part 3 is the capstone course, it's a project-based course. Mostly the projects, or what I would call guided projects, although as we get towards the end, I don't give quite as many hints and clues. Especially if you're wanting to undertake the honors certificate. The projects for the honors certificate are quite challenging and open-ended. Before we get started, I wanted to just let you know how you can switch up your schedule. I get this question a lot. That is if you get delayed or postponed for whatever reason, how do you switch to a different session? Well, let me click over here. This is what part 2 looks like for me. I actually enrolled, but I never actually completed my own course. It'll say something like the schedule you're enrolled in ends at this particular time. If you'd like more to complete your work, there's always a big blue button over here that says Switch Schedule. If you do become delayed, and you're not getting your work done in time, you can always switch to a later session. Let's get back to Everyday Excel part 3. I would encourage all of you to mouse around on the website. If you go to week 1, this gives the introductory material, the basic course information. You guys should read through all of these materials. I wanted to point out a couple of important things. First, Office 365 is required for this course. You definitely need Office 365. Many of the Dynamic array formulas that you need to solve these projects are only available in Office 365, Excel 365. If you don't have Office 365, Microsoft offers a free 30-day trial. If you're working efficiently that's going to be enough time to complete this course, but also just for your own good, I would encourage all of you to learn Office 365. There's a lot of interesting and unique formulas that are only available as Dynamic array formulas. This is only going to make your life more productive in years to come because as we move forward, everybody is going to be adapting into Office 365. I think in a couple years, the old Excel versions are going to be quite outdated, and if you don't adapt now, you're going to be left behind. I would encourage all of you to learn Office 365. You might grumble that you have to upgrade. I think it ends up being only something like six dollars a month, if you do decide to get an annual subscription. I think a lot of you probably spend more than six dollars a month on Netflix. I know I do. That's an important point about this course. You can read through some of these other reading assignments here. Another question that I get a lot is how to unlock the course files. The course files are only available to paid learners. If you paid for a course certificate, or perhaps the organization that you work for, paid for a course certificate, then you'll have this unlock quiz for course files. I don't think you're going to have that if you haven't paid for the course certificate, but the course files are released when you complete the unlock quiz for course files, this Quiz is just a simple. You just have to enter in a phrase, and it unlocks the reading assignment here at Course Files. That's where you're going to get all the course files so you can work along with me, and you can complete the projects. Other than that, you can read through this information. Then week 2, 3, and 4, this corresponds to the warm-up projects in week 2, the intermediate projects in week 3, and the main projects in week 4. Week 5 is where you'll find the honors information. Coursera only allows modules to be separated into weeks. I think some of these weeks, especially week 4, might take you up to two or three weeks to do. Just because it says week 2, 3, and 4, it doesn't mean you have to necessarily do those, in one week, for each of those modules. Again, if you do get behind schedule, you should see this Switch Schedule button on your home tab on the overview of the course. I would encourage all of you to look through weeks 2 through 5. This is where I have the introductions to all of the projects. You can go through and you can look at the previews. For each of these projects I have a video preview. I'm going to leave that up to you to do. I do offer, for each of the projects, so this is the warm-up project, there are five potential projects that you can choose from and you need to do three. If we click over here on week 3, these are the intermediate projects. There are six possible projects for the intermediate projects, and you have to choose three. Again, you should mouse around to determine which of these you want to do. You might gravitate towards some of these more than others. Again, all of these I have preview screencasts for. Let's go to week 4. This is the meat and potatoes of the course. The main projects. There are five main projects and you have to do three. Each of these projects has a discussion prompt. You can ask others for questions or you can provide hints. For the main projects, I have a lot more details and screencasts available that give hints and suggestions on how to proceed. For all of the projects, there's always a submission quiz. What you'll do after you've completed the assignment, you can click the Grade button. I've got this in the previews for all of the projects. You'll get a completion code. The completion code is just a four-digit number, that you can put into the quiz and if it's correct, you'll get credit, for that project. For those of you who want to tackle the honors projects, there are two of them, for the honors certificate, and you can read about those in week 5. These are quite challenging, especially the Top Hat Consolidator Project. Again, welcome to the course. I'm glad you guys have chosen to take part 3 of Everyday Excel. Good luck, and have fun.
