Data Analysis in Excel-Filtering data SUPER FAST using only the keyboard Free class

Devesh M

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
5 Videos (21m)
    • 1. Introduction to filtering

      3:03
    • 2. Three shortcuts to apply or remove filter

      3:15
    • 3. Filtering on a particular item(s)

      6:56
    • 4. Types of filters

      2:13
    • 5. Filtering on different data types

      5:04

About This Class

Boost your excel (spreadsheet) skills by learning simple methods which will make your everyday excel experience a breeze. Master excel shortcuts to make you more efficient and productive on spreadsheets.

In this video, I will show you how to filter data super fast using only the keyboard without touching the mouse.This is part 1 of 3-part series on data analysis using excel which covers the  following topics-

  • Sorting,
  • Filtering 
  • Pivot Tables.

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.
Ross Wirth

Professor, Org Change & Strategic Planning

16

Students

--

Projects

Working as an Internal Auditor in a Big 4, 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 specific activities which you can quickly master, double your speed and become a pro at.

Please check out my class on "Data Analytics in Excel: Filtering data Superfast using only the Keyboard".

Here's the free enrollment link

http://skl.sh/2aUefld

Premium enrollment link:         

http://skl.sh/29yWLbs

Do let me know of any feedback and suggestions. Thanks!