Excel Formulas & Functions for Financial Professionals

Format: Hands-on instructor-led OR lecture/demonstration.

Whether you're modeling a business budget or a manufacturing process, maintaining a list of employees or managing your company's inventory, you're using (or need to use) formulas in Excel.

LEARNING OBJECTIVES:
Upon successful completion of this course, participants will be able to:

• Apply and efficiently utilize all aspects of formulas and functions in MS Excel.
• List the five things that can be included in any Excel formula.
• Describe absolute vs. relative referencing.
• Utilize Scenario Manager.
• Use three-dimensional cell references.
• Build mega-formulas using the instructor's multistep process.
• Create formulas in a PivotTable using calculated fields and calculated values.
• Utilize the Goal Seek tool.
• Use Solver.
• Explain how to use the Formula Auditing toolbar.

HIGHLIGHTS:

• Practice using Excel tools that will create formulas for you.
• Using functions as well as practice using at least one function in each function category.
• Using formulas with charts and graphs.
• Introduction to creating custom functions in Visual Basic.