• 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 (97)
  • Dashboard (4)
  • Excel Tips and Tricks (31)
  • Power BI (10)
  • Power Pivot (9)
  • Power Point Visualization (4)
  • Predictive Analytics (3)
  • Templates (25)
  • VBA (59)

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

Follow Us

Recent Posts

  • Quality Analysis Dashboard in Power BI
  • Bulk Auto Emailer with Picture Signature and HTML body
  • Comparative Analysis Dashboard in Power BI
  • Stylish and Dynamic Comparison Chart
  • Dynamic Filled map in Excel
  • Multicolor Filling Bars in Excel Cells Without using Chart
  • Custom Toggle Button in Excel and Power BI
  • Beautiful Registration form with Picture in Excel VBA
  • 6 Powerful Dynamic Array Function in Excel
  • Exam Application Form with Timer
Copyright © 2018 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.