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 »
How to Apply Serial Number After Filter in Excel?
May 24, 2021
In this article, I will show you two ways to apply serial number after filter. The first way is to add a new column of serial number and the second way is to make the serial number renumber automatically.
How to Split Excel Sheets into Separate Workbooks
April 26, 2021
Splitting Excel sheets can be a daunting task when you have got a bunch of workbooks. Today I will share with you the VBA code to split Excel sheets with a click.
How to prevent duplicate entries in Excel?
April 23, 2021
Duplicates sometimes can be a bad thing which lead to mistakes and wrong calculation. In this article, I will show you how to set a no duplicates rule to cells.
How to get distinct values in Excel? (6 ways)
April 19, 2021
I will show you 6 different ways to get distinct values in Excel. “Remove duplicates”, “Advanced filter”, “Function”, “Formula”, “Pivot table” and “VBA”.
How to copy data from multiple sheets at once
April 15, 2021
In this article, I will show you how to copy data from different sheets and paste them at once by using the clipboard.
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)
