Welcome to week two. Alex has found himself back at school this week. There are some case-by-case calculations that the accounts department at a local school has to work through. The case-by-case nature of the task is proving to be very time consuming and the accounts department are making errors along the way. So, the whole process has become quite tedious. Alex to the rescue. A key business use for Excel is as an automation tool. Large companies don't have time to work through data cell by cell, and this approach is also prone to error. In a spreadsheet containing thousands of clients, we have built some unique relationships where they may have negotiated different cells with us, such as discounts. This means we cannot perform blanket calculations on all our data. So, each action must be tailored to the criteria of each record. When calculations need to be made on a case-by-case basis, what is actually happening is something called conditional logic. For each case, we are asking Excel, if something is true, then do this action and else, do another action instead. Some of you may be familiar with these statements from software programming. If not, don't worry, we're going to start with the basics. Without having to work through a spreadsheet row by row, we can create an if statement that takes all possible scenarios into account and ask Excel to perform certain calculations for each scenario. As we are following Alex's work to fix the school's workbooks, you will learn how to use logical functions. First, we will look at the IF function, then the AND function, as well as the OR function. After that, we will combine logical functions. First, IF with AND and with OR, and then we will look at Nested IFs. Finally, we will work through IFERROR and IFNA. Just like last week, we have a series of practice videos to equip you with these coaxial skills. So, download the Excel workbooks and work alongside us step-by-step. Then take a break, relax, refresh, reset, and attempt these workbooks again because practice makes permanent. After these videos, we have a practice challenge for you to take your Excel skills even further. Remember the toolbox, which you should be checking out regularly. Of course, this week's great Ninja tip. Now, let's sit down with Nicky and work through conditional logic in depth.