Excel 2007 Intermediate – Working with Functions and Formulas

In this course, students will learn how to properly reference cells, use mathematical
operators, and check their formulas for errors. This course also covers how to browse,
insert, and use functions to perform complex mathematical operations. Students will also
learn how to use the IF function, use nested functions to perform multiple operations,
and define and use range names. Finally, array formulas will be discussed.