How To Do Case-sensitive Find And Replace In Excel?
November 20, 2020
In this article, I am going to show you how to do find and replace only if the case matches. Normal Find and Replace example Sometimes, we want more than just normal find and replace in Excel. However, in default
How To Reverse Concatenate In Excel (3 ways)
November 14, 2020
CONCATENATE Function is a crucial function to structure data according to your needs. Reverse concatenate in Excel is equally important since sometimes you might want to split one cell into multiple cells. However, there is no such function as unconcatenate
How To Center Cells Across Multiple Columns?
November 9, 2020
This article is to show you how to center cells over multiple columns in Excel without leading to the problems of merging cells using center across selection.
What the heck is =SUMIFS()? (1 of 2)
June 12, 2020
The first time I hear about =SUMIFS() was at the computer literacy class in college. The instructor tried using some data in Excel to illustrate how it works, but just like most of the class, I had no clue about why this formula matters. It was just like trigonometry to
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)
