Ep 2. Using Lookup Functions and Formula Auditing

Using Lookup Functions and Formula Auditing is the second episode of the third season of the Microsoft Excel 2016 - Training show. In this episode, viewers will learn about the power of lookup functions and formula auditing tools in Excel.

The episode begins with a brief explanation of what lookup functions are and why they are important. The host then shows viewers how to use the VLOOKUP function, which involves searching for a specific value in a table and returning the value found in the same row as the search value. The host walks through an example of how to use VLOOKUP to search a large dataset for specific information, such as sales data for a particular product.

Next, the host discusses the HLOOKUP function, which is similar to VLOOKUP but searches for a value in a horizontal row instead of a vertical column. The host demonstrates how to use HLOOKUP to search for data in a table that is organized by date.

The episode then moves on to formula auditing tools, which are designed to help users find and troubleshoot errors in complex formulas. The host explains how to use the Trace Precedents and Trace Dependents tools to identify the cells that are used in a formula and those that depend on it. This can be useful for understanding how a formula works and identifying errors that may result from changing a value in one cell.

The host also covers how to use the Evaluate Formula tool, which allows users to step through a complex formula one element at a time to see how it is calculated. This can be helpful for identifying errors or understanding how a formula works.

Finally, the episode concludes with a discussion of conditional formatting, which allows users to highlight cells based on specific criteria. The host demonstrates how to use conditional formatting to highlight cells that contain certain types of data, such as numbers above or below a certain threshold.

Overall, Using Lookup Functions and Formula Auditing is a valuable episode for anyone who uses Excel regularly, particularly those working with large datasets or complex formulas. The host provides clear explanations and real-world examples to help viewers understand these powerful tools and how to use them effectively.