| Course | Excel: Track and Analyze Business Data [WDRS0016/CR/01] |
|---|---|
| Prerequisites | A good working knowledge of Excel |
| Prerequisit Course | |
| Requal. Interval | One Time Only |
| Contact | Nicole M Gee |
| Reference Material | |
| 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 |
| Course Content | |
| 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. |