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: Filter
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
Find Top Employee with FILTER and RANK Function
In this article, we have explained how to find top selected employee with the help of FILTER and RANK Function. You will also learn the SORT and OFFSET Function. We
Static and Dynamic Row Level Security in Power BI
Row level security with Power BI is used to restrict data access for particular users. Filters restrict data access at the row level, which are defined within roles in Power
Wildcard in Microsoft Excel
In this article, you will learn how to use Wildcard in Microsoft Excel. Wildcard is very useful in excel and can make your work very easy. What is Wildcard? Wildcards
Quick Re-Arrange Columns Sequence Using Data Sorting
In this article, you will learn how to sort the data by columns. If you have multiple columns in your excel sheet and you want to arrange the order of
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
Excel Tip : Fill the blanks cells in your data
Many times we have zig-zag data which has to be formatted in proper manner to create some report or dashboard. In this article you will learn how we can fill
VBA: Filter Data with Multiple Values
In this article you will learn how we can use an excel range as a filter criteria and paste the filtered data on another worksheet. For example, we have below