Control Huge Data using Filters in Microsoft Excel

Instructor:  Jed Guinto
Course Dates: Open-ended
Enrollment Dates: Enroll Anytime
Who can Enroll: Anyone
Course Language: English
Price:  FREE

About the Course

DESCRIPTION
Once you start dealing with larger sets of data, filters come into play. It allows us to remove (temporarily) information that is of no relevance to us. Think of it as peeling an onion. When you remove the skin, its still there on the counter for your wife to clean up, leaving you with the onion. Filters in Excel work the same way and you can apply multiple filters one after another until you find what you’re looking for. 

TARGET AUDIENCE
This is for anyone who has started using large sets of data in table form or more experience users who are now struggling to manage larger data sets. 

STRUCTURE
This is a detailed course spanning over 20 videos and total time of about 50 minutes

DIFFICULTY
This is not for beginners and more for later intermediates and experts. 

COURSE OUTCOMES

  • Master Order ID
  • Reordering/Alphabetizing
  • Check boxes
  • Search Fields
  • Sorting By Colour
  • Filtering by Colour
  • Number filters
  • Multiple Filters
  • Conditional Formatting Combinations
  • Charts and Graphs
  • Array Fills

Course Structure

  • The Opening Act
  • Initial Setup
    • Case Study Explained
      00:00:00
      • DOWNLOADABLE FILE!!
    • Applying Your Filter
      00:00:00
    • Applying a Master Order ID
      00:00:00
  • Colour filtering, Searchbox and Checkboxing
    • Reordering A to Z, Z to A
      00:00:00
    • Using the Checkbox
      00:00:00
    • Using the Search Field
      00:00:00
    • Sorting By Colour
      00:00:00
    • Filtering By Colour
      00:00:00
  • Number Based Filtering
    • Number Filter - Equals and Does Not Equal
      00:00:00
    • Number Filtering - Greater Than and Less Than
      00:00:00
    • Above and Below Average
      00:00:00
    • Top Items Filter
      00:00:00
    • Applying Multiple Filters
      00:00:00
  • Bonus Filtering Options
    • Conditional Formatting Combination
      00:00:00
    • Charts and Graphs
      00:00:00
    • Array Fill
      00:00:00

Instructors

Jed Guinto
Jed Guinto
Jed Guinto is the Co-Founder of Paperclip Learning. Currently pursuing his Ph.D. in Aerospace Engineering, he is also an avid educator with experience teaching primary students, high school students and undergraduate Aerospace, Civil and Mechanical Engineers. Over 44,000 students from over 170 countries have signed up for his courses.

This entry was posted in . Bookmark the permalink.