- Define functions in Microsoft Excel
- Use lookup functions and formulas
- Use logical functions and formulas
- Use financial functions and formulas
We’ve already learned some basic functions and formulas in Excel; however, there are more powerful and complex functions that Excel can do. In this section, we’ll take a look at some of these more complex functions.
Lookup Functions
You can view the transcript for “Stop using VLOOKUP in Excel. Switch to INDEX MATCH” here (opens in new window).
Logical Functions
You can view the transcript for “Logical Functions (AND, OR, IF) – How to use Logical Functions in Excel” here (opens in new window).
Financial Functions
You can view the transcript for “BEST Financial Formulas on Excel | For Business & Finance Professionals” here (opens in new window).