TRAIN Online Class Schedule
Course Excel: Track and Analyze Business Data[WDRS0016/CR/01]
Prerequisites A good working knowledge of Excel
Requal. Interval One Time Only
Contact Nicole Gee
Target Audience Educated Excel users needing more experience with functions and formulas.
Objective Create simple formulas with cell references and functions. Use absolute and mixed cell references in formulas and use the Round function. Build formulas using the IF and Vlookup functions.
Course Content A variety of functions and formulas to analyze and track business data will be covered. Topics include:
*Creating basic formulas with cell references
*Creating formulas for a profit statement
*Using functions and labels in formulas
*Creating formulas for income projection
*Creating formulas with mixed and absolute cell references
*Using the Round function
*Adding clip art
*Experimenting with the If and Vlookup function
*Using the If and Vlookup functions in a formula
*Calculating loan payments
Instructor's Comments If you withdraw from the class 10 business days or fewer before it begins and do not find a replacement, you will be charged the full fee.

Invalid Fermi ID: 00000X

Fermi ID Employee   Visitor   Contractor   Other -- Fermilab Phone Book
  This course has a fee. Select the project and task to use when the class is booked.
Project:
Task
Note: The task code popup above requires a recent version of JavaScript. If no tasks appear when you select a project code please use a newer browser. If one is not available please contact the ServiceDesk for assistance. If you return to this page please re-select your project code to re-populate the task code popup.
Waiting List Option Add me to any class that becomes available.
Do you wish to be added to the waiting list? When a class is created or an opening becomes available, persons on the waiting list are automatically enrolled. An email notification will be sent at that time.