How to Input Time Duration in Excel
August 17, 2022
Excel doesn’t have a direct way of inputting time duration. In this article, I will show you how to input time in Excel quickly.
Read More »
How to Generate Random Numbers with Decimals
July 22, 2022
In this article, I will show you how to get random numbers with decimals in Excel. There are 3 formulae of your choice to cope with different situation.
How to Stack Multiple Columns into One Column
July 12, 2022
I will show you how to stack multiple columns into one single vertical column, from up to down and from left to right.
How to Delete Row if cell in certain column is Blank? Excel
July 4, 2022
In this article, I will show you how to delete rows if cell in certain column is blank. It doesn’t matter if your workbook contains hundreds of worksheets.
How to Mass Delete hidden rows/ columns in Excel
June 24, 2022
In this article, I will show you how to delete hidden rows in Excel at a few clicks. It doesn’t matter if your workbook contains hundreds of worksheets.
Excel Split Long Text into Short Cell Without Splitting Word
May 10, 2022
I will show you how to split long text into shorter cells without splitting word. This allows you to select the length of the end result.
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)
