• Advanced Excel
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
  • VBA Course
  • Products
    • 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
    • PM Dashboard
    • Outbound Dashboard
    • Incentive Dashboard
    • Zonal Dashboard in Excel
    • Quick Dashboard
  • Power BI
  • About Us
  • Contact Us

PK: An Excel Expert

Online Excel 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 (101)
  • Dashboard (5)
  • Excel Tips and Tricks (33)
  • Power BI (12)
  • Power Pivot (11)
  • Power Point Visualization (4)
  • Predictive Analytics (3)
  • Templates (29)
  • VBA (61)

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

  • Vertical and Circular Bullet Chart in Excel
  • Inventory Management Template for Store
  • 10 Pro Tips for Excel Charts
  • Dynamic Hourly Project Planner (Gantt Chart)
  • Price Fetching Tool from Amazon and Flipkart
  • Automated Attendance Sheet in Excel
  • Ideas in Excel
  • Daily Sales Report – Data Extraction from multiple PDF files
  • Hourly Auto Email with Scheduler
  • Static and Dynamic Row Level Security in Power BI
Copyright © 2018 PK-AnExcelExpert.com - Privacy Policy