• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Finance Train

Finance Train

High Quality tutorials for finance, risk, data science

  • Home
  • Data Science
  • CFA® Exam
  • PRM Exam
  • Tutorials
  • Careers
  • Products
  • Login

Excel Modelling

Excel Modelling

Most Important Excel Skills for Finance …

Excel is a life skill for any finance or accounting professional. I know ... Continue reading

Excel Modelling

Alternative to MSN Stock Quotes Add-in i …

This discussion happened with the intent to find the best Alternative to MSN ... Continue reading

Excel Modelling

How to Show Negative Numbers in Brackets …

In accounting and financial models sometimes you will want to show negative ... Continue reading

Excel Modelling

Create Financial Dashboards Using Excel …

Microsoft Excel has always been the spreadsheet software of choice for ... Continue reading

Equity Analysis, Excel Modelling

Stock Evaluation Spreadsheet …

Our user Jim Grant has created a very useful stock evaluator spreadsheet and ... Continue reading

Excel Modelling

Stock Portfolio Tracker in Google Docs S …

One of the best ways to manage your money is to use a spreadsheet program ... Continue reading

Excel Modelling

Get Stock Quotes in Excel: New Excel Add …

Excel is the most commonly used tool by people to manage and keep track of ... Continue reading

Excel Modelling

Excel: How to Sort Data Using a Custom S …

If you have some data in your spread sheet you can use the sort function to ... Continue reading

Excel Modelling

Excel: How to Move to First or Last Row …

This is a common problem faced when you are dealing with a large list. You ... Continue reading

Excel Modelling

How to Magnify a Selection in Excel? …

Sometimes an excel sheet may contain a large amount of data but you may be ... Continue reading

Excel Modelling

Formula to Check if a Cell Contains #N/A …

Sometimes you will have a formula in a series of cells and in some of those ... Continue reading

Excel Modelling

How to Delete Blank Rows Using Excel VBA …

Here is a simple problem, you have a set of data in an excel sheet, but ... Continue reading

Excel Modelling

Why take Excel Training? …

Sales figures of a cement depot, student admissions month on month in a ... Continue reading

Excel Modelling

Making MSN Stock Quotes Add-in Work in E …

This post is with reference to how to get stock quotes in excel using the ... Continue reading

Excel Modelling, Financial Mathematics

Using Excel to Calculate Annuity …

An annuity refers to a series of equal cash flows that occur periodically ... Continue reading

Excel Modelling

Calculating EWMA Correlation Using Excel …

We had recently learned about how to estimate volatility using EWMA – ... Continue reading

Excel Modelling, Financial Markets

How to Calculate Volatility in Excel? …

We know that the prices of different financial assets such as currencies and ... Continue reading

Excel Modelling

Stock Quotes in Excel for NSE/BSE …

Often times, you will need to get the stock quotes for different stocks in ... Continue reading

Excel Modelling, Statistics

Using LINEST() Function in Excel for Mul …

The LINEST() function calculates the statistics for a line by using the ... Continue reading

Excel Modelling

Online Excel Training – Beginners …

Being in the field of finance, Excel is an almost indispensable skill that ... Continue reading

  • Go to page 1
  • Go to page 2
  • Go to Next Page »

No other posts to show.

Primary Sidebar

Latest Tutorials

    • Data Visualization with R
    • Derivatives with R
    • Machine Learning in Finance Using Python
    • Credit Risk Modelling in R
    • Quantitative Trading Strategies in R
    • Financial Time Series Analysis in R
    • VaR Mapping
    • Option Valuation
    • Financial Reporting Standards
    • Fraud
Facebook Group

Membership

Unlock full access to Finance Train and see the entire library of member-only content and resources.

Subscribe

Footer

Recent Posts

  • How to Improve your Financial Health
  • CFA® Exam Overview and Guidelines (Updated for 2021)
  • Changing Themes (Look and Feel) in ggplot2 in R
  • Coordinates in ggplot2 in R
  • Facets for ggplot2 Charts in R (Faceting Layer)

Products

  • Level I Authority for CFA® Exam
  • CFA Level I Practice Questions
  • CFA Level I Mock Exam
  • Level II Question Bank for CFA® Exam
  • PRM Exam 1 Practice Question Bank
  • All Products

Quick Links

  • Privacy Policy
  • Contact Us

CFA Institute does not endorse, promote or warrant the accuracy or quality of Finance Train. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.

Copyright © 2021 Finance Train. All rights reserved.

  • About Us
  • Privacy Policy
  • Contact Us