DA401 - Excel 2007 - Getting to Know Formulas

Description:

This course is for those who have experience with Excel and want to enhance their knowledge in the topic of formulas and functions. This course will discuss basic formulas and functions in a lecture/hands-on format.

Objectives:

Topics to be covered include:

• Navigating the Ribbon
• Creating formulas
• Using 3-D cell references to create formulas
• Absolute versus relative cell references
• Using named range in a function
• Using basic functions
• Troubleshooting formulas
• Using conditional formatting through logical functions

Reasonable Accommodations

Individuals who need reasonable accommodation to participate in CIT Training courses should let CIT Training know at least 5 days prior to the class. For interpreting services, please request them from the ORS Interpreting Services by completing the form at Interpreting Services Form or calling (301) 402-8180 or TTY (301) 435-1908 at least 5 days before the start of the class.

Who should attend:

NIH staff using the Office 2007 products who are wanting to learn about basic formulas in Microsoft Excel.

Instructor(s):

Michele Schwartzman, CIT

Time Required:

3 Hours

Sections Available: