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

    The Importance of Excel in Business

    Microsoft Excel is an indispensable tool for any business.
  2. 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.
  3. Trading

    Improve Your Investing With Excel

    Excel is a useful tool to assist with investment organization and evaluation. Find out how to use it.
  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

    How Do You Calculate Beta In Excel?

    If the right data on key variables is available, you can use Excel to calculate beta.
Frequently Asked Questions
  1. I'm about to retire. If I pay off my mortgage with after-tax money I have saved, I can save 6.5%. Should I do this?

    Only you and your financial advisor, family, accountant, etc. can answer the "should I?" question because there are many ...
  2. My wife and I both converted our Traditional IRAs to Roth IRAs over a decade ago and have invested the maximum allowed each year since. We're buying our first home soon. Do we both qualify for one-time, tax-free, $10,000 distributions?

    You and your spouse each qualify for a penalty-free distribution of up to $10,000 for the purchase, acquisition or construction ...
  3. Is a Thrift Savings Plan (TSP) a qualified retirement plan?

    Take advantage of the government's retirement plan for employees with the Thrift Savings Plan. As with a 401(k), contributions ...
  4. Who manages the assets in a Roth 401(k) account?

    Learn how to personally manage the assets in your Roth 401(k) plan and determine the best options available to help meet ...
Trading Center