Description: This course has been updated to include several advanced formulas as well as formulas used by the beginner as well as IT users. You will cover how to trace formulas, check errors, evaluate formulas, and how to use the Watch Window. You will review the use of range names and how to use them in logical functions and lookup functions. You will be introduced to new formulas such as the LAMBDA and RANK functions. You will also learn complex functions, such as SUMIF, AVERAGEIF, and COUNTIF functions. You will also learn a wide variety of Text Functions that can be used in a wide variety of processes when creating complex spreadsheets. In addition, you will learn about date and time functions, including finding the day of the week and the week number.
# of Days:
Setting: