Advanced Excel Techniques Part 1 ... An Introduction to Conditional Statements and Lookup Functions

In this course you will learn to:

1) Use and implement the Excel IF function in a number of practical applications
2) Use the IF function in conditional formatting
3) Use and implement the CHOOSE function in a number of practical applications
4) Use and implement the VLOOKUP function in a series of pratical applications
5) Use and implement the INDEX function in a number of practical applications
6) Use and implement the MATCH function in a practical application