Automatically Creating Employee-wise Skill Set Lists
Data transformation is an important aspect of data analysis and is often used to manipulate data in a way that suits our needs. One such manipulation is creating comma-separated lists
Tag: Sort
Searchable and Dependent Drop-down list in Microsoft Excel
In this article, we have created a Searchable and Dependent Drop-down list in Microsoft Excel. We have used Dynamic Array function of office 365 to create the drop-down list. We
Quick Productive Tips in Microsoft Excel
In this article, you will learn the quick tips in Excel to improve the productivity in Microsoft Excel. Tip #1: Auto Serial Number: We can Sequence function in Excel to
Excel Tips: Sort data by Custom List
Many times it happens when we are not able to sort our data as per our requirements. We have to take some support column to sort the data. For example