• 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 V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • 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

Excel, VBA and Power BI tutorials

Tag: Filter

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

Data Transformation to create Comma Separated List automatically

December 12, 2022December 12, 2022 PKComments Off on Data Transformation to create Comma Separated List automatically
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
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
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
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
Wildcard in Excel
Excel Tips and Tricks

Wildcard in Microsoft Excel

June 21, 2020June 21, 2020 PKComments Off on Wildcard in Microsoft Excel
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
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
Fill Blanks
Excel Tips and Tricks

Excel Tip : Fill the blanks cells in your data

November 14, 2018November 14, 2018 PK0
Filter with multiple values
VBA

VBA: Filter Data with Multiple Values

September 14, 2018September 14, 2018 PK0

Top Categories

  • Charts and Visualization (126)
  • Dashboard (8)
  • Excel Tips and Tricks (53)
  • Power BI (19)
  • Power Pivot (14)
  • Power Point Visualization (5)
  • Predictive Analytics (3)
  • Templates (49)
  • VBA (75)

Read More about..

  • Advanced Excel
  • VBA Course
  • Dashboard
  • Chart and Visualization
  • VBA Tips
  • Excel Tips and Trics
  • Our Excel Products
  • About US
  • Contact Us

 

Subscribe to our Newsletter



Download Free Dashboards

  • Project Management Dashboard
  • Zonal Dashboard
  • Sales Dashboard
  • Outbound Dashboard
  • A Quick Dashboard
  • C-SAT Dashboard
  • Performance Dashboard
  • Process Dashboard
  • Incentive Dashboard

Recent Posts

  • How Chat GPT can help to write Complex Excel Function, VBA code and DAX for Power BI
  • Power BI dashboard with 3D Glass Chart
  • Use of Symbols and Emojis in Excel Drop-down List and Excel Charts
  • Five awesome formulas in Excel
  • Quick 3D Container chart in Excel
  • TEXTSPLIT function with three use cases in Excel
  • LAMBDA Function in Excel with Example
  • Data Transformation to create Comma Separated List automatically
  • Inventory Management Template for Multiple Locations
  • Paste Special in Microsoft Excel
Copyright © 2018 PK-AnExcelExpert.com - Privacy Policy