Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

Excel like a Pro: How to filter excel data SUPERFAST using only the keyboard?

Dev M

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
5 Videos (21m)
    • 1. Filtering with keyboard preview

    • 2. Three shortcuts to apply or remove filter

    • 3. Filtering on a particular item(s)

    • 4. Types of filters

    • 5. Filtering on different data types


About This Class

Enroll for this class, if you like learning techniques:

  • To get more done on excel in short amount of time
  • Work like a pro on excel, mastering the keyboard shortcuts without having to touch the mouse.
  • Make your everyday spreadsheet experience a breeze

In this course, learn how to filter data super fast using only the keyboard without touching the mouse.

You can download the file which I have used in the class to follow along and complete the exercises in the class project. 

2 of 2 students recommendSee All

Very informative and explained in an elementary way.
Good information. Too many people do not take full advantage of the power in Excel.
Dr. Ross Wirth

Professor, Org Change & Strategic Planning





Excel is a bread and butter software, which I tend to use extensively as a part of my job.

It especially plays a big role in Data Analytics where you need to make sense of huge volume of data within minutes.

Being in such a profession, figuring out faster ways of working on Excel was not only imperative for survival but also a fun process to break the normal work routine.

Given the depth of Excel features and applications, my goal here is to build focussed class on specif...

See full profile