All articles with 'Textjoin()' Tag
Excel text functions are essential for cleaning up data, extracting parts or combining results. Learn the most important functions and their usage in this article.Continue »
9 box grid is a popular method for talent mapping. Download this free excel template for tracking and visualizing your employee performance & potential data.
In this article, I explain about powerful excel features like FILTER(), SORT() and CONCATENATEX() to create a similar 9 box talent map grid for your data.Continue »
Are you in IT & use Excel often? This article explains top 10 formulas for IT professionals. Useful for project managers, IT analysts, Testing people and BAs.
We cover a 10 practical situations and explore various Excel formulas to solve them. Example workbook provides more details too.Continue »
Risk comes from not knowing what you are doing. Warren Buffet If you ever ask a project manager what they are up to, they will tell you “I have no idea“. So risks are quite common in project management. That is why I made this awesome free Excel risk map template to keep track and […]Continue »
We all know that VLOOKUP can find first match and return the results. But what if you want all the matches? Use this simple trick instead.Continue »
Use the new Textjoin() function to reverse a string of characters suing a formulaic solution.Continue »