The highlights of this hour are

Why you should use Excel functions

How to use the Insert Function dialog box

How to use the Formula palette

What you should know about financial functions

How to use date and time functions

How to use logical functions

How to use lookup functions

Hour 5, "Letting Excel Do the Math," explained the uses of simple worksheet functions and showed examples of some functions in action. The text lists each function and indicates where to include arguments. If you've read Hour 5, you have a basic understanding of the purpose of functions and how they work.

This hour explains the use of the Insert Function dialog box and Formula palette, which makes it easier to use the more complex Excel functions. In addition, this session includes an extensive listing of many important Excel functions and gives you an opportunity to use some of them in the To Do exercises.