For those comfortable with SUM, AVERAGE and other basic functions, but who need to up their game by including logical (IF, AND, OR, SUMIF) and lookup (VLOOKUP, INDEX, MATCH, LOOKUP) functions. In this session, we learn how functions are built and combined to allow Excel to do most of the heavy lifting with lists and calculations. You’ll learn not only how to use these powerful functions, but what to do when they don’t work.