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

This guide to Excel provides an overview of some of the more useful tools for investors to utilize, but really just touches on a few of the many applications available. Additionally, as touched upon previously in the tutorial, it is also important to take note of third-party cell "add-ins" to Excel, which represent separate programs that can link directly to Excel and have pre-built formulas and other applications, to further improve on the utility of Excel as a financial tool. If you enjoyed this guide and are interested in some additional video instruction, check out Investopedia Academy's Microsoft Excel Course to take your skills to the next level.


Related Articles
  1. Investing

    Guide To Excel For Finance

    Formulas, functions and features you need to know when using Excel for financial analysis.
  2. Small Business

    The Importance of Excel in Business

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

    How to Calculate CAGR in Excel

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

    How to Calculate ROI in Excel

    Daniel Jassy, CFA, shows how to calculate ROI in 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. Small Business

    Calculating Net Present Value at Different Points Using Excel

    Calculating the net present value (NPV) of your investment projects using Excel.
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