How to Show Zeros as Blank Cells In Excel
January 12, 2021
Background Zeros are almost inevitable in a workbook. Sometimes you may change the appearance of the zero. Do you have the following ask? Display zero as blank cells Show zero as dash Hide zero without actually deleting zero In this
How to Create Drop Down List with Color (Excel)
January 12, 2021
I have a drop-down list and I want the cell to be formatted to a specific color depending on the selected value. Numerous Excel users From time to time, I get this questions from my followers on Instagram. They want
How to Generate Random Variables in Excel
January 8, 2021
Generating random numbers is easy with Excel! Learn about generating uniform and normal random numbers in Excel to aid your business analysis!
Binomial Option Pricing (Excel formula)
January 6, 2021
Option pricing is a heated topic in quantitative finance, and let’s explore how we can use the binomial option pricing model in Excel to compute option price!
How to Sum Intersections of Multiple Ranges (Excel)
January 4, 2021
Background Sometimes we have to sum the intersections of multiple ranges. Can you think of a formula? Using INDEX MATCH? INDIRECT? And nested IF function? I go through exactly the same thought process until I meet Intersection operator. Don’t panic
How to Merge Cells Across Multiple Rows/Columns
January 4, 2021
In this article, I will show you how to merge cells across multiple rows and columns simultaneously.
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)
