Skip to the content
ITS Training Program ITS Training Program Logo
Home Workshop Evaluation MS Office Archives FAQ About Us Site Map
Workshops
 
  Adobe Dreamweaver 8
  Adobe Flash 8
  Adobe Photoshop CS2
  Creating a Webpage Using
    HTML
  Excel 2003 for
    Financial Investments
  Excel 2003 Functions
    and Data Analyses
  Microsoft Access 2003
  Microsoft Excel 2003
  Microsoft PowerPoint 2003
  Microsoft Publisher 2003
  Microsoft Word 2003
  Outlook Web Access 2003
  PowerPoint Crash Course
  SPSS v15
 
Faculty Corner
 
eLearning Programs and Support
Menu Bottom
Policies
 
Policies Please follow our policies, so we can provide a better service
Menu Bottom

Using Excel for Financial Investments

Use the Power of MS Excel 2003 to help you make intelligent financial decisions. Whether you plan to invest in a mortgage or in Fortune 500 companies, you need to know basic financial concepts such as the value of money, risks involved, and investment returns. We provide hands-on activities using Excel’s Insert Function feature.

Using Excel for Financial Investments Part 1
Cash Flow Management-- In Part One, you will learn how to calculate depreciation as well as the basic concepts of time value of money such as NPV, FV, PMT, PV, and IRR. As Benjamin Franklin said, “A penny saved is a penny earned!”

Using Excel for Financial Investments Part 2
Risk Analysis-- In Part Two, we will discuss ways to measure and analyze investment risks. You will be introduced to concepts such as Variation, Standard Deviation, and Coefficient of Variation.