Data Transformation to Create Comma Separated List Automatically
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 to Create Comma
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
5 Quick Productive Tips in Microsoft Excel
In this article, you will learn the 5 Productive Tips in Microsoft Excel to improve the productivity in Microsoft Excel. 5 Quick Productive Tips in Microsoft Excel Tip #1: Auto
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 in Power BI uses role filters to restrict which data rows users can access. This tutorial introduces static and dynamic approaches, including the USERPRINCIPALNAME DAX function for the
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
Rearrange Columns in Excel Using Data Sorting (3 Quick Ways)
To rearrange columns in Excel without endless cut and paste, let the Sort command do the work. Most people only ever sort rows from top to bottom, but Excel can
Sort Data by Custom List in Excel (Months, Sizes and More)
When you sort data by custom list in Excel, you choose the order yourself instead of accepting A to Z. That matters for month names, T-shirt sizes, priority levels and
Fill Blank Cells in Excel with the Value Above: 4 Quick Tricks
Need to fill blank cells in Excel with the value above? Exported reports often show a date or a supervisor name only on the first row of each group and
VBA Filter Data with Multiple Values and Copy to Another Sheet
With a short macro you can filter data with multiple values in VBA and copy the result to another sheet in one click. Instead of ticking names in the filter