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

    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.
  5. Tech

    How to Calculate R-Squared in Excel

    Daniel Jassy, CFA shows how to calculate R-Squared in Microsoft Excel.
  6. 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. Who are Whole Foods' (WFM) main competitors?

    Whole Foods' main competitors are Sprouts Farmers Markets and Trader Joe's. However, the recent acquisition by Amazon my ...
  2. What caused the Stock Market Crash of 1929 that preceded the Great Depression?

    Find out what led to the stock market crash of 1929, which in turn led to the Great Depression. It sparked a nearly 90% loss ...
  3. How does inflation affect the exchange rate between two nations?

    Inflation is closely related to interest rates, which can influence exchange rates. Countries attempt to balance interest ...
  4. What are some examples of free market economies?

    In a free market economy, the law of supply and demand, rather than a central government, regulates production and labor. ...
Trading Center