PKComments Off on 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
PKComments Off on 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
PKComments Off on 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
PKComments Off on 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
PKComments Off on 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
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
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
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