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. Financial Advisor

    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. Investing

    How Do You Calculate Beta In Excel?

    If the right data on key variables is available, you can use Excel to calculate beta.
  3. Small Business

    Calculating Net Present Value at Different Points Using Excel

    Calculating the net present value (NPV) of your investment projects using Excel.
  4. Personal Finance

    7 Types of People Who Fail in Finance

    To work in finance, you must be hard working and team-oriented, here are some personalities that are not.
  5. Personal Finance

    Schedule Loan Repayments with Excel Formulas

    Calculate all the particulars of a loan using Excel, and set up a schedule of repayment for a mortgage or any other loan.
  6. Insights

    Simulating Stock Prices Using Excel

    We will use the average of the change in log prices, the volatility, the normal distribution and Excel to formulate the future prices of an asset.
  7. Investing

    Financial Statement Manipulation An Ever-Present Problem For Investors

    The SEC has taken steps to eliminate this type of corporate fraud, but it remains a real risk for investors.
  8. Small Business

    What's Involved in Quality Management?

    Essentially, quality management entails overseeing all activities and tasks needed to maintain excellence.
  9. Financial Advisor

    Shareholders' Equity

    Learn how to calculate this common formula in finance.
  10. Small Business

    Calculating the Internal Rate of Return Using Excel

    The internal rate of return on investments is explained and illustrated in different investment scenarios.
Frequently Asked Questions
  1. Depreciation Can Shield Taxes, Bolster Cash Flow

    Depreciation can be used as a tax-deductible expense to reduce tax costs, bolstering cash flow
  2. What schools did Warren Buffett attend on his way to getting his science and economics degrees?

    Learn how Warren Buffett became so successful through his attendance at multiple prestigious schools and his real-world experiences.
  3. How many attempts at each CFA exam is a candidate permitted?

    The CFA Institute allows an individual an unlimited amount of attempts at each examination.Although you can attempt the examination ...
  4. What's the average salary of a market research analyst?

    Learn about average stock market analyst salaries in the U.S. and different factors that affect salaries and overall levels ...
Trading Center