• 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

Sort and Filter

Sorting and filtering is useful functionality to work on data sets. You will learn Sort and Filter step by step with Example.

Sort:

  • Chapter-1: Data Sorting
  • Chapter-2: Sort by Color

Filter:

  • Chapter-3: Data Filter
  • Chapter-4: Text, Number and Date Filter
  • Chapter-5: Filter by color
  • Chapter-6: Advanced Filter

Download the Excel file for practice.

Start the Tutorial

Top Categories

  • Charts and Visualization (133)
  • Dashboard (9)
  • Excel Tips and Tricks (58)
  • Power BI (20)
  • Power Pivot (14)
  • Power Point Visualization (4)
  • Predictive Analytics (4)
  • Templates (51)
  • VBA (76)

Latest Articles

On object interaction in Power BI

Enhance Your Power BI Experience with On-Object Interaction

March 19, 2023March 21, 2023 PK
Quick Dynamic Sales by Employees chart with Slicers

Quick Dynamic Sales by Employees chart with Slicer in Excel

March 16, 2023March 16, 2023 PK
Dynamic Annual Calendar with Holiday

Free Dynamic annual calendar with holiday and Control Panel

March 12, 2023March 12, 2023 PK
Half Circle KPI

Half Circle KPI Charts in Excel using Doughnut Charts

March 9, 2023March 9, 2023 PK
Waffle Chart with Football Icon-1

Waffle chart with Football Icon in Excel

March 9, 2023March 9, 2023 PK

Popular Articles

Dynamic Chart with Camera

Dynamic Graph with Camera

May 3, 2022 PK
Tooltip in Excel

KPI Dashboard with Tooltip in Excel

August 8, 2021August 8, 2021 PK
Dynamic Chart with Form Controls

Fully dynamic chart in Excel with Scroll bar and Spin button

March 19, 2020February 5, 2023 PK
Top-Bottom Analysis in Excel

Top/Bottom Analysis dashboard in Excel

May 24, 2020May 24, 2020 PK
Profit Analysis using What if Analysis

Profit Analysis Dashboard using What-if Parameter

April 27, 2022May 10, 2022 PK

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
  • 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
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy