How to Fill Sequential Data Quickly in Excel
June 2, 2021
In this article, I will show you how to fill linear and growth sequence by fill command and fill handle. This will save you a lot of time.
Read More »
3 Reasons for Option Explicit (Excel VBA)
January 19, 2021
Option Explicit is often an overlooked aspect when we write VBA codes! Learn here about 3 reasons to use it on EVERY VBA codes you write going forward.
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!
5 Golden Rules for Excel Formatting
November 27, 2020
Motivations Today I want to share 5 golden rules of Excel formatting with you, which I have gathered through years of working in the financial industry, and observed how high-calibre professionals impress their teams and managers with attention to these otherwise
Day 1 as an Excel professional
November 5, 2020
We know what it’s like staring at an empty void of blank white table called “Excel spreadsheet” with no idea what is going on. To make something special, you just have to believe in special. Kung Fu Pandas (2008) Don’t
Partner Guide
October 6, 2020
Welcome to Dollar Excel Partners! We are more than glad to see you around and can’t wait to see your first Excel product available! To deliver a seamless experience for our customers, we adopt a set of publishing guidelines that
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)
