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. Small Business

    The Importance of Excel in Business

    Microsoft Excel is an indispensable tool for any business.
  2. Tech

    How to Calculate R-Squared in Excel

    Daniel Jassy, CFA shows how to calculate R-Squared in Microsoft Excel.
  3. Tech

    How to Calculate CAGR in Excel

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

    How to Calculate ROI in Excel

    Daniel Jassy, CFA, shows how to calculate ROI in 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.
Frequently Asked Questions
  1. Is Technical Analysis a Self-Fulfilling Prophecy?

    Technical analysis seems to be useful, but some say it is simply reinforcing what investors believe.
  2. How does a cost-of-living adjustment (COLA) affect my salary?

    Learn how employers add cost-of-living adjustments to workers' salaries to offset the effects of inflation or aid in a relocation ...
  3. Is Net Operating Income (NOI) the same thing as Earnings Before Interest and Taxes (EBIT)?

    Find out about net operating income, earnings before interest and taxes, why they are not equivalent, and which measure takes ...
  4. What Is a Pitchfork Indicator & How Do I Use It?

    The technical indicator known as Andrew's Pitchfork is rarely used by novice traders.
Trading Center