Perform Left/Mid On Array Formula (Excel)
November 25, 2020
LEFT, MID, RIGHT are some of the most useful text function in Excel. They allow us to extract a specified number of characters from a text string. Yet, normal LEFT, MID, RIGHT only work in a single cell. To perform
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
5 Best Datasets to Practice Excel For Free
November 12, 2020
Practice makes Perfect. When you learn about new Excel formula, you would absolutely need resources to help you consolidate this new knowledge, and to apply it to real-life, tangible examples that you can think deeper as to the meaning of
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)
