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

Microsoft Excel can be an invaluable resource for investors wanting to dig into more detail on financial market data. Excel can help you analyze stocks and investments, determine how much to save for your son for college, calculate how much savings you can accumulate in the stock market, or how much you should pay for a car.

There are literally hundreds of ways to use Excel to manipulate financial data and help improve the investment process. In this tutorial, we will examine some of the more useful tools used in Excel for financial analysis. If you're looking for a more in-depth educational experience, Investopedia Academy offers a finance-specific MS Excel Course that features video instruction, case studies, and downloadable models.

 

 


Guide To Excel For Finance: Linking Yahoo! Finance and Other Outside Financial Data To Excel
Related Articles
  1. Investing

    Microsoft, Facebook Create an Ad Tracker for Excel

    The two teamed to create a Excel add-on to let advertisers track ad spending on social media.
  2. Small Business

    How to Calculate NPV Using XNPV Function in Excel

    Learn how to calculate the net present value (NPV) of your investment projects using built-in functions from Excel using the XNPV function.
  3. Tech

    How to Calculate CAGR in Excel

    Daniel Jassy, CFA, shows how to calculate CAGR in Excel.
  4. Personal Finance

    Don't Overlook 529 Plans for College Savings

    Don't overlook 529 plans as a tax-advantaged way to save for a child' education.
  5. Investing

    Ratio Analysis Tutorial

    If you don't know how to evaluate a company's present performance and its possible future performance, you need to learn how to analyze ratios.
Trading Center