Black-Scholes Option Pricing (Excel formula)
December 22, 2020
Black-Scholes option pricing is one of the landmarks for quantitative finance. Let’s learn about the intuition and apply it to price options in Excel!
Read More »
How to Add Value Directly to Existing Cells in Excel?
December 19, 2020
In this article, I will show you how to add value directly to existing cells in Excel with Paste special feature. These steps can also be used on other calculations.
Look Up the Last Value in Column/Row in Excel
December 17, 2020
Very often we have to find out the last value in a column or in a row. When there are so many ways available in the internet, they all have a common issue – too long and complicated. If the
Binomial Option Pricing (Excel VBA)
December 17, 2020
Using the Excel VBA code presented, we can easily create a multi-period binomial tree to price European options with great flexibility and tweaking parameters.
How to Name Multiple Single Cells in Excel?
December 12, 2020
Background Named range is a very useful feature in Excel. With Named range, the formula is more dynamic and looks a lot more descriptive. However, naming range itself can be a painful process. Naming 50 ranges manually can take you
How to Display the Formula as Text in Excel?
December 12, 2020
Background If you click into this article, you must be looking for a way to solve the below problems. How to get the formula displayed as text in Excel? How to display formula rather than result in Excel? How to
Categories
.
- Array Formula (3)
- Data validation (3)
- Excel Formula & Functions (34)
- Excel Skills (37)
- Excel Tips and Tricks (38)
- Finance (5)
- Formatting (8)
- Option Pricing (3)
- Pivot table (3)
- Sharing (8)
- Shortcuts (13)
- Solver (1)
- Technical (6)
- VBA (18)
