Skip to content Skip to site navigation Skip to service navigation

Creative Excel Techniques for Filtering and Extracting Data

Class Code Date Delivery Method Cost
  • Thu Aug 15, 9:00 am to 12:00 pm
  • Fri Aug 16, 9:00 am to 12:00 pm
Live Online - 2 sessions $450

Most Technology Training classes will be delivered online until further notice.

Before each sesson, Tech Training will provide a Zoom link for live online classes, along with any required class materials.


Dive deep into Excel's powerful advanced data-mining tools, with an emphasis on building query criteria ranges to find and extract and/or perform calculations on precise data subsets.

This class is designed for experienced Excel users. See below the topics to view a list of proficiencies one must be familiar with in order to get the most out of this class.


  • Comparing AutoFilter and Advanced Filter
  • Comparing database functions to conditional statistical functions
  • Understanding the criteria range
  • Working with Excel Tables and using table structured references in formulas
  • Using in-cell drop-down (data validation) lists to simplify building and changing criteria ranges
  • Using logical comparative operators
  • Using AND and OR criteria logic
  • Using wildcard criteria
  • Using multiple functions in complex calculated criteria, including AVERAGE, VLOOKUP, ISNA, NOT and LEN
  • Using Advanced Filter to extract a data subset rather than filtering data in place
  • Using filtering techniques to prove complex database function results

Prerequisite skills for this class

This class is designed for experienced Excel users. To get the most out of this class, participants should be proficient in and comfortable with at least seven out of the following 10 Excel skills:

  • Copy and paste worksheet data and formulas
  • Filter and sort worksheet data
  • Use the SUM and COUNT functions
  • Use the IF function
  • Use the VLOOKUP function
  • Use the SUBTOTAL function
  • Use conditional functions such as SUMIF and SUMIFS
  • Create formulas with comparative operators such as =, >, < and <>
  • Create formulas with multiple, nested functions
  • Use named ranges and/or Excel tables
Igor Ovchinnikov

Igor Ovchinnikov has been teaching software productivity classes for over 20 years. Stanford staff have enjoyed his training since around 2007. His training philosophy stems from a strong belief that learning is a perpetual cycle of new discoveries and improvement.

Custom training workshops are available for this program

Technology training sessions structured around individual or group learning objectives. Learn more about custom training

University IT Technology Training sessions are available to a wide range of participants, including Stanford University staff, faculty, students, and employees of Stanford Hospitals & Clinics, such as Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health.

Additionally, some of these programs are open to interested individuals not affiliated with Stanford, allowing for broader community engagement and learning opportunities.