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.


Related Articles
  1. 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.
  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. 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.
  5. Personal Finance

    7 Types of People Who Fail in Finance

    To work in finance, you must be hardworking and team-oriented, here are some personalities that are not.
  6. Investing

    The Debt Report: The Utilities Sector

    Discover how blue chip U.S. utilities companies are using debt, and why it was important for the industry to deleverage after the financial crisis.
  7. 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.
  8. Insights

    Microsoft, LinkedIn Deal Cleared By EU Regulators (MSFT, LNKD)

    Microsoft's $26.2 billion blockbuster deal for LinkedIn has finally been approved, according to a blog post posted Tuesday by the software giant.
  9. Investing

    5 Popular Utilities ETFs in 2016 (XLU, NEE)

    Discover how the five most popular utilities ETFs for 2016 can add growth and income to your portfolio. Four of these utilities ETFs outperformed the S&P 500.
  10. Trading

    Invest in Utilities With These ETFs (XLU, JXI)

    The strong uptrends shown on the charts of these utility ETFs suggest now could be the time to buy.
Frequently Asked Questions
  1. Where else can I save for retirement after I max out my Roth IRA?

    The first option to explore is to determine if you can contribute to a 401(k), 403(b), or 457 plan at work. If your employer ...
  2. How did George Soros "break the Bank of England"?

    In Britain, Black Wednesday (September 16, 1992) is known as the day that speculators broke the pound. They didn't actually ...
  3. What counts as "debts" and "income" when calculating my debt-to-income (DTI) ratio?

    It's important to know your debt-to-income ratio because it's the figure lenders use to measure your ability to repay the ...
  4. Who are Monsanto's main competitors?

    Learn about Monsanto Company's two main operating divisions and its main competitors within each sector, including The Mosaic ...
Trading Center