How to freeze top and bottom row at once in Excel
April 12, 2021
In this article, I will show you two workarounds to freeze header row and bottom row. One of the solutions is with table and another one is without using table.
Read More »
How to remove all conditional formatting from a workbook
April 8, 2021
In this article, I will show you how to delete conditional formatting from a workbook with VBA code.
How to highlight cells that equal multiple values in Excel?
April 5, 2021
Basic conditional formatting allow us to highlight value equal to one value at a time. Here I will show you how to highlight cells equal to more than one value.
How To Remove Digits After Decimal In Excel?
March 30, 2021
In this article, I will show you three ways to delete number after decimal points in Excel.
How To Extract Images From Excel In 1 Minute
February 22, 2021
When we have to archive the content, very often we also want to extract the photos out from Excel into separate files in a folder. How to do that?
Value-at-Risk (VaR)| Risk Management in Excel
February 17, 2021
Value-at-Risk (VaR) is an important heavy-tail metric for financial portfolio. Let’s learn about historical/parametric approach of VaR calculations, and 4 different ways to present VaR.
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)
