1. Guide To Excel For Finance: Introduction
  2. Guide To Excel For Finance: Linking Yahoo! Finance and Other Outside Financial Data To Excel
  3. Guide To Excel For Finance: PV And FV Functions
  4. Guide to Excel for Finance: Annuities
  5. Guide To Excel For Finance: Valuation Methods
  6. Guide To Excel For Finance: Goal Seek
  7. Guide To Excel For Finance: HLookup And VLookup
  8. Guide To Excel For Finance: Ratios
  9. Guide To Excel For Finance: Technical Indicators
  10. Guide To Excel For Finance: Advanced Calculations
  11. Guide To Excel For Finance: Conclusion

Excel is an ideal tool for individuals and investors to manipulate financial data.  This tutorial is just a small example of everything Excel has to offer.  The help function directly in Excel, plus other Investopedia-based and online tutorials, can offer direction to find further functionality.  It is also important to take note of third-party cell "add-ins" to Excel, which represent separate programs that can link directly to Excel and have pre-built formulas and other applications, to further improve on the utility of Excel as a financial tool.


Related Articles
  1. Tech

    Advisor Tools: To ‘Excel’ or Not Excel?

    Microsoft Excel has been a staple of the financial services industry for decades but specialized advisor software solutions have sprung up in recent years.
  2. Trading

    Improve Your Investing With Excel

    Excel is a useful tool to assist with investment organization and evaluation. Find out how to use it.
  3. Tech

    How to Calculate NPV in Excel

    Daniel Jassy, CFA, shows how to calculate NPV in Excel.
  4. Small Business

    Calculating Net Present Value at Different Points Using Excel

    Calculating the net present value (NPV) of your investment projects using Excel.
  5. Investing

    Want to Forecast the New iPhone's Impact on AAPL?

    Take a sneak peek at how Daniel Jassy, CFA uses Excel to forecast the latest iPhone's impact on AAPL.
  6. Tech

    How to Calculate ROI in Excel

    Daniel Jassy, CFA, shows how to calculate ROI in Excel.
  7. Personal Finance

    Microsoft Excel Features For The Financially Literate

    Here are some of Excel's functions and features that a financial professional can use to make his or her job more efficient.
  8. Insights

    Simulating stock prices using excel

    Here, we'll use the average of the change in log prices, volatility, normal distribution and Excel to formulate the future prices of an asset.
Frequently Asked Questions
  1. How do you Fund a Forex Account?

    Global currencies are traded on the forex market. Here's how to tap in.
  2. How a bond's face value differs from its price

    Discover how bonds are traded as investment securities and understand the various terms used in bond trading, including par ...
  3. What does CHIPS UID mean?

    Learn what CHIPS UID stands for and how it facilitates the transfer of funds as the back-end of the ACH network for both ...
  4. What does the de Minimis clause for investment advisers mean?

    Learn the answer to what the de Minimis clause for investment advisers means.
Trading Center