Courses

In this course, students will learn how to use Excel to perform advanced calculations to facilitate decision-making and the acquisition of insight.  The advanced formulas often provide advanced automation or searching capabilities, which can save time and produce quick, efficient results.

Formulas covered include Sum IF, Error IF, Count IF, Conditional Formatting, VLOOKUP and HLOOKUP, Index and Match. You can use some formulas interchangable, as well as nested. For example the combination of the INDEX and MATCH functions in Excel provides a more advanced way to look up and assess information inside an Excel sheet or workbook. While functions like VLOOKUP and HLOOKUP allow you to search for information, they have limitations on where and how they search that can prevent you from easily obtaining the information you need. The MATCH function is nested inside the INDEX function and can be used to find a certain type of data, while INDEX is used to connect that information to the other data available in its row. In other words, MATCH allows you to find the position of a value in a range, and then INDEX is used to return a specific value in relation to the original value. It is important for two-way lookups and case-sensitive lookups, and you can even use it to find the closest match from the data you have.

You will also learn creating a forecast and predictions in Excel, using historical time-based data, and apply it to predictions. You can take a look what does it take here.

In this course students will also gain the skills necessary to create and use pivot tables and charts, audit and analyze worksheet data, trace precedents and dependents, utilize data tools, collaborate with others by protecting worksheets and books, import and export data; convert text and validate and consolidate data.