The IF function is one many people shy away from, but this is one function that will truly make every Excel user's life much easier. Excel's VLookup is a handy tool that helps you compare data in two spreadsheets.
In this class you will learn how to:
- Automate decision-making in your spreadsheet using the IF Function.
- Use the IF function to test a value in a specific cell to see if that value meets a certain condition.
- Automate data retrieval and control in your spreadsheet with the VLookup Function.
- Use the Lookup tool to import data from one spreadsheet to another for comparison purposes.
- and more!