How to Compute IRR in Excel (Basic to Advanced)
December 22, 2020
Excel comes with great tools to compute the IRR on an investment. We are going to show you 3 methods in computing IRR and their limitations.
Read More »
How to Add Value Directly to Existing Cells in Excel?
December 19, 2020
In this article, I will show you how to add value directly to existing cells in Excel with Paste special feature. These steps can also be used on other calculations.
How to Name Multiple Single Cells in Excel?
December 12, 2020
Background Named range is a very useful feature in Excel. With Named range, the formula is more dynamic and looks a lot more descriptive. However, naming range itself can be a painful process. Naming 50 ranges manually can take you
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 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
Excel Increase / Decrease Font Size Shortcut
December 4, 2020
In PowerPoint or Word, the shortcut to increase font size is Ctrl + Shift + >. However, this shortcut performs different function in Excel. In Excel, Ctrl + Shift + > means copy to right. So, what is the shortcut
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)
