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.
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)