How to Get the First day of Next Month?
December 11, 2020
Background In this article, I will show you How to Get the First day of Next Month? How to find First day of Next Month? How to find 1st day of Next Month? Sample Workbook Download the workbook to practice
How to Check/Test if Sheets Exist in Excel?
December 11, 2020
Background Sometimes we would like to check if sheets exist in Excel. This is easy when you only have a few worksheets. However, if you have hundreds of sheet, it is not as easy. Even if you have the time
How to Create Jump to Cell Button in Excel?
December 10, 2020
Background Excel has over 1 million rows and more than 10000 columns. Sometimes the navigation between different cells can be difficult and quite time-consuming. Although you might have more than 10000 cells, most of the time there are only a
How to Insert & Run VBA code in Excel – VBA101
December 8, 2020
Background This step-by-step tutorial is for absolute beginners in VBA. You don’t need to have any expertise to be able to follow this tutorial. When I was learning Excel at the very beginning, every single Excel functions excited me a
How to Count Cells that do not Contain Errors in Excel
December 7, 2020
Background Sometimes you may want to know the number of cells does not contain errors in your workbook. Indeed this it not difficult at all. You can accomplish it with just one simple formula. In this article, I will show
How to Sum and Count Cells by Color in Excel?
December 5, 2020
Background Sometimes we may want to sum and count cells based on background colour of a cells. I personally don’t suggest using background colour frequently. I do think background colour has its advantage. You can check out 5 Golden Rules
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)
