1. Guide To Excel For Finance: Introduction
  2. Guide To Excel For Finance: Linking Yahoo! Finance and Other Outside Financial Data To Excel
  3. Guide To Excel For Finance: PV And FV Functions
  4. Guide to Excel for Finance: Annuities
  5. Guide To Excel For Finance: Valuation Methods
  6. Guide To Excel For Finance: Goal Seek
  7. Guide To Excel For Finance: HLookup And VLookup
  8. Guide To Excel For Finance: Ratios
  9. Guide To Excel For Finance: Technical Indicators
  10. Guide To Excel For Finance: Advanced Calculations
  11. Guide To Excel For Finance: Conclusion

Excel is an ideal tool for individuals and investors to manipulate financial data.  This tutorial is just a small example of everything Excel has to offer.  The help function directly in Excel, plus other Investopedia-based and online tutorials, can offer direction to find further functionality.  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.


Related Articles
  1. Investing

    Guide To Excel For Finance

    Formulas, functions and features you need to know when using Excel for financial analysis.
  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. 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.
  4. Small Business

    How to Calculate Net Present Value (NPV) in Excel

    Learn how to calculating the net present value (NPV) of your investment projects using built-in functions from Excel.
  5. Tech

    How to Calculate ROI in Excel

    Daniel Jassy, CFA, shows how to calculate ROI in Excel.
Frequently Asked Questions
  1. What Is a Holistic Marketing Strategy?

    Understand what holistic marketing is, and learn how the components of this strategy work when applied to different business ...
  2. What's the First Stock Warren Buffett Ever Bought?

    Find out about Warren Buffett's first experience in stock market trading. Learn some of the Berkshire Hathaway CEO's basic ...
  3. When Is a Put Option Considered to Be 'in the Money?'

    Learn about put options, how these financial derivatives work and when put options are considered to be in the money related ...
  4. What Are Some of the Top Hostile Takeovers of All-Time?

    Learn about some of the most noteworthy hostile takeovers in history, including the KKR acquisition of RJR Nabisco and the ...
Trading Center