Course Outline

Excel for Financial Analysis
Learn introductory through advanced Financial Applications for Excel, presented by an Excel expert! Create range names; build formulas and use functions. Use Auto Filter with conditions, wildcards and calculations. Learn useful Lookup Functions and Database Functions. Create advanced charts for analysis. Learn 5 essential tools for managing data. Use functions and commands to clean up incoming data; learn various techniques for analyzing data with grand totals, arrays and formulas. Use advanced filter on data. Master timesaving strategies and shortcuts. Learn to use Pivot Tables and do linear regression analysis. Receive a complete listing of Excel functions. 2 days (12 hours)
Prerequisites:  MS Excel Level 3 or equivalent experience.
Revised 4/14/2009
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600