I just wanted to give you a preview of what you're going to be learning in this course, week one is all about arrays. So arrays are where you have multiple rows and multiple columns. So you're going to learn how to work with arrays, we're going to learn how to do things like this, where you can search through arrays for the number of fives. And then you can select where to place that result, and it's going to kind of output a summary of this. Another example, for those of you who are working through the assignments, you'll learn how to randomize things. So here we have an array, and we have a sub routine that just kind of randomizes that. And you'll learn a lot more about arrays, how to export arrays from VBA into Excel and how to import arrays from VBA into Excel. Week two deals with strings and text files, the first thing you're going to learn is how to work with string functions in Excel, and then you're going to sort of adapt this into VBA. For example, here we have a last name, first name format and you can write Excel functions that will extract and separate the first name and last name. And then you can also in Excel write formulas to concatenate those into, for example, email addresses. Once you've learned how to do that in Excel, then you can adopt that and easily make custom functions in VBA. You can also do things like, you can make array functions where I've got a part number here, and I've made a parts array function that extracts the information that's separated by hyphens. And it's adaptable to different alphanumeric characters and different sizes of those. So I can just drag this down and we can extract those. So that's a custom VBA user defined array function that deals with strings. You will also learn how to write to text files and how to import data from text files into Excel. So, here I just kind of made a fun example, we're going to through this in week two. Where you can put a word here, this is one of the longest words in the English language and we can convert that to Morse code. We have the code over here, dashes and dots, and it's going to do that. It's going to put the word here in a column, each letter in a different row. It's also going to ask us to write that to a text file, so then you can navigate it to where you want to save that text file, and then you can use that if you'd like. The second part of this is you can decode a message, well, you can reset here, there's also a Reset button. But then you can decode, so you can import a text file, and its going to go through automatically and it's going to extract the information from that text file, and that text file had Morse code on different lines of the text files. Week three is where things really get exciting, you're going to learn how to open up automatically and iterate through workbooks and also worksheets. So here I've got a single workbook but I've got a bunch of different worksheets, so you're going to learn about how to go back and forth between worksheets. In this example that we're going to be covering in some of the screencasts, we've got different employees who have different work schedules or work availabilities during the day. And you want to sort of see what the most popular time to meet is so you can just go in here and automatically run this. And it's going to go through and count the xs that are found in each of those possible slots. And it's then automatically going to highlight the best time for you to meet. So every week, if you had employees submit their schedules on different worksheets here, then you can reset this and run it again, and you can determine the best meeting time. I've got a slightly different variation of that same problem, here we've got a central workbook. But now, what we're going to do is we've got the schedules on different workbooks. You can easily do this by interfacing with Dropbox, so you can have different people submit Excel files or text files to the Dropbox folder, and then once a week you can consolidate the information so. In a folder I've got the different schedules of employees and some of these files have different numbers of worksheets similar to the problem I just worked through. So when we open up a workbook we're going to count the number of worksheets and we're going to import information from all of the worksheets. So we make it adaptable to a different number of files and different worksheets in those files. For example, if I opened up one of these, this is the employee schedule for three employees, and we're going to consolidate those schedules. And again, you could have this, a Dropbox folder, so over here you could have people download or I guess upload files to Dropbox. And then you could occasionally consolidate information from those so we can run this, and it went through those files one at a time and you can do the same thing. You can determine when the best meeting time is and you can consolidate. So week three is all about worksheets and workbooks and iterating through them and you're going to learn a lot from week three. In week four, which is the last module of parts one and two, you're going to learn all about creating professional user forms. So here we have a user form that's linked to an on sheet button. You can put in information, so the user can input information and they can select different things and then it'll output different things. So this is something that you're going to make at the very beginning of the week. You're going to learn how to populate user forms with information from spread sheets. So, here we have a user form, these are the elements of the periodic table, and you can select from all these elements. And it's going to provide the symbol, atomic number, and atomic mass, which it's looking up here. So we can use combo boxes in user forms. And finally, we're putting it all together using the bisection technique, that is a advanced solving technique that doesn't use the solver and therefore is a live solution. You'll learn about that in part one of the course if you haven't already taken that. But I can open this up, and embedded behind this calculate button, we have the bisection method. So there's a pretty complicated non linear equation that's being solved when we do this. And I can put in a pressure, I can select the temperature from this combo box, this drop down menu, and then I can calculate the conversion. Then I can reset that and do another calculation. So in week four, advanced user input and output, and you're going to kind of put together everything you've learned in both parts of the course. I hope you guys are as excited as I am and good luck with everything.
