Course Name: 

Microsoft Excel 2000 / 2003

Lesson 2 � Working With Formulas and Functions

Introduction:

This course teaches how to work with formulas and functions in MS Excel. It is intended for those who already have a basic understanding of how to use the most basic features of MS Excel (97-03).

We offer courses for first time users to advanced users looking to get the most out of this powerful program. With a firm understanding and skill using Microsoft Excel, you can improve the way you turn data into information using powerful tools to analyze, communicate, and share your results with others.

Topics for Discussion:

1.      Using Excel�s functions

2.      Work with the Insert Function button

3.      Math and Statistical functions

4.      Define functions, and functions within functions

5.      Open the Insert Function dialog box

6.      Examine the Insert Function dialog box

7.      Insert Function helpful tips

8.      Excel's financial functions

9.      Recognize optional arguments

10. Copy and paste formulas and functions

11. Problems using copy and paste with formulas

12. Use relative references

13. Use absolute references

14. Use mixed references

15. Auto Fill features

16. Create logical functions

17. Using the �If� function

18. Excel's date functions

19. The TODAY and Now functions

Pre-Requisites:

• �Lesson 1 - The Fundamentals� or equivalent knowledge from using MS Excel.
• Any version of MS Excel from 2000-2003

Cost:

$50.00

References:

Course material will be given out at the time of the lecture.