Using the IF function to add logic to formulas and to nest functions
Using many of Excel’s text based functions
Parsing data using the TextToColumns feature
Creating a unique list of items from a column or table with many duplicates
Utilizing one of Excel’s most valuable (and used) functions for looking up data