1. Guide To Excel For Finance: Introduction
  2. Guide To Excel For Finance: Goal Seek
  3. Guide To Excel For Finance: PV And FV Functions
  4. Guide To Excel For Finance: HLookup And VLookup
  5. Guide To Excel For Finance: Linking Yahoo! Finance and Other Outside Financial Data To Excel
  6. Guide To Excel For Finance: Ratios
  7. Guide To Excel For Finance: Technical Indicators
  8. Guide To Excel For Finance: Valuation Methods
  9. Guide To Excel For Finance: Advanced Calculations
  10. 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. There are literally hundreds of ways to use Excel to manipulate financial data and help it improve the investment process. In this tutorial, we will examine some of the more useful tools used in Excel for finance. 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: Goal Seek
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. Tech

    How to Calculate R-Squared in Excel

    Daniel Jassy, CFA shows how to calculate R-Squared in Microsoft Excel.
  3. 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.
  4. Tech

    How to Calculate ROI in Excel

    Daniel Jassy, CFA, shows how to calculate ROI in Excel.
  5. Small Business

    Calculating Net Present Value at Different Points Using Excel

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

    How Do You Calculate Beta In Excel?

    If the right data on key variables is available, you can use Excel to calculate beta.
  7. Personal Finance

    The Best Financial Modeling Courses for Investment Bankers

    Obtain information, both general and comparative, about the best available financial modeling courses for individuals pursuing a career in investment banking.
Frequently Asked Questions
  1. Why Do Most of My Mortgage Payments Start Out as Interest?

    Fear not: Over the life of the mortgage, the portions of interest to principal will change.
  2. What is the difference between secured and unsecured debts?

    The differences between secured and unsecured debt, and how banks buffer risks associated with each type of loan through ...
  3. How Many Times has Warren Buffett Been Married?

    Warren Buffett has been married twice in his life, but the circumstances surrounding the marriages were unconventional.
  4. What's the smallest number of shares of stock that I can buy?

    Many people would say the smallest number of shares an investor can purchase is one, but the real answer is not as straightforward. ...
Trading Center