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
How to Generate Random Dates in Excel
December 3, 2020
Background Sometimes we will need to generate random dates in Excel for different reasons. For example, we may create a set of fake data for practising or predicting. Before I was aware of this formula, I used to input different
How To Insert Bracket In Excel Cells (3 ways)
December 1, 2020
Sometimes we have to insert bracket in Excel cells. The easiest way to wrap text in bracket is to manually input it. This process may take an hour if you have thousands of rows. Not only is the manual process
6 Ways To Converting Text To Number Quickly In Excel
November 28, 2020
Often times Excel recognize number as text. That could lead to a lot of problems. Not able to perform mathematic operations Lead to error Cells are aligned to the left In this article, I am going to show you 6
How To Auto Change Sheet Reference In Copied Formulas?
November 26, 2020
In this article, I will show you how to reference worksheet dynamically using the INDIRECT function.
How To List All Worksheets Name In A Workbook
November 26, 2020
Background Sometimes you would like to get a list of all worksheets’ names in a workbook. To create a content page (or use this content page creation tool) To Change Sheet Reference In Copied Formulas To show your boss how
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)
