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.


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. 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.
  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. 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. What is the formula for calculating earnings per share (EPS)?

    Learn why earnings per share (EPS) is often considered to be one of the most important variables in determining a stock’s ...
  2. What is the formula for calculating internal rate of return (IRR) in Excel?

    Understand how to calculate the internal rate of return (IRR) using Excel and how this metric is used to determine anticipated ...
  3. What is the formula for calculating net present value (NPV) in Excel?

    Understand how net present value is used to estimate the anticipated profitability of projects or investments, and how to ...
  4. Why are IRA, Roth IRAs and 401(k) contributions limited?

    Find out why contributions to IRA, Roth IRA and 401(k) retirement savings plans are limited by the IRS, including what the ...
Trading Center