Hour 15. Using Functions

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 ...

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.