• Advanced Excel
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
    • Find and Replace
  • VBA Course
  • Products
    • Restaurant Management
    • PK’s Utility Tool V3.0
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • AMS – Lite
    • AMS V1.0
    • AMS V2.0
    • Sale/Purchase Software
    • PK’s Function Kit
  • Blogs
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Templates
  • Excel Dashboard
    • Sales Dashboard
    • Process Dashboard
    • Performance Dashboard
    • Project Management
    • Outbound Dashboard
    • Incentive Dashboard
    • Zonal Dashboard in Excel
    • Quick Dashboard
  • Free Templates
  • Power BI
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Tag: Filter

Data Transformation to create Comma Separated List automatically
Excel Tips and Tricks Power Pivot

Automatically Creating Employee-wise Skill Set Lists

December 12, 2022March 8, 2023 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
Read More
Searchable and Dependent Drop-down list
Excel Tips and Tricks

Searchable and Dependent Drop-down list in Microsoft Excel

September 18, 2022September 18, 2022 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
Read More
Quick Productive Tips in Excel
Excel Tips and Tricks

Quick Productive Tips in Microsoft Excel

August 8, 2022August 8, 2022 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
Read More
Find Top Employee with Filter Function
Charts and Visualization Excel Tips and Tricks

Find Top Employee with FILTER and RANK Function

June 7, 2022September 9, 2022 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
Read More
Row Level Security in Power BI
Power BI

Static and Dynamic Row Level Security in Power BI

October 25, 2020October 25, 2020 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
Read More
Wildcard in Excel
Excel Tips and Tricks

Wildcard in Microsoft Excel

June 21, 2020June 21, 2020 PKComments Off on 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
Read More
Sort by Cell color
Excel Tips and Tricks

Quick Re-Arrange Columns Sequence Using Data Sorting

July 24, 2019July 24, 2019 PKComments Off on 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
Read More
Sort by Custom List
Excel Tips and Tricks

Excel Tips: Sort data by Custom List

January 18, 2019 PKComments Off on 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
Read More
Fill Blanks
Excel Tips and Tricks

Excel Tip : Fill the blanks cells in your data

November 14, 2018November 14, 2018 PK0
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
Read More
Filter with multiple values
VBA

VBA: Filter Data with Multiple Values

September 14, 2018September 14, 2018 PK0
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
Read More
  • Advanced Excel
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
    • Find and Replace
  • VBA Course
  • Products
    • Restaurant Management
    • PK’s Utility Tool V3.0
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • AMS – Lite
    • AMS V1.0
    • AMS V2.0
    • Sale/Purchase Software
    • PK’s Function Kit
  • Blogs
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Templates
  • Excel Dashboard
    • Sales Dashboard
    • Process Dashboard
    • Performance Dashboard
    • Project Management
    • Outbound Dashboard
    • Incentive Dashboard
    • Zonal Dashboard in Excel
    • Quick Dashboard
  • Free Templates
  • Power BI
  • About Us
  • Contact Us
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy
This website uses cookies to improve your user experience, analyze site traffic and serve targeted ads in accordance with our Privacy Policy ACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT