Skip to main content

Webinar Excel: Filtering and sorting in Excel

Version: Office 365
Duration: 1 hour

Description

Do you need to quickly filter a long list only by data you want to view immediately? In this session you will discover the power of Excel filters! We discuss the best way to filter the different types of data (text, numbers or dates), and what options there are (colour, highest/lowest values, dates that fall within a certain period or custom criteria such as all text containing a specific word, …). In addition to filtering, it can be useful to sort data in order to introduce more structure. Not everything is sorted alphabetically (months, weekdays, …). We take a look at how you can create your own lists to use for sorting.

This is all demonstrated using plenty of clear examples from everyday experience.

Content

Part 1: Filtering and sorting

  • Horizontal sorting
  • Sorting using a list
  • Adding filters to lists
  • Types of existing filters (text, numeric, chronological)
  • Basic filters and advanced filters (colour, comparison)
  • Basic filters and advanced filters (colour, comparison)
  • Dangers with using filters

Part 2: Text filters

  • Filtering by expression
  • Operators and conditions

Part 3: Numerical filters

  • Operators and conditions
  • Filtering versus average
  • Top 10 filters

Part 4: Chronological filters

  • Filtering based on current date
  • Filtering based on a specific date
  • Tips & tricks for chronological filters
View all our trainings

Request a quote

"*" indicates required fields

Address*
Name*
In which language(s) do you wish to organise this training?
You apply for this course as:
Do you want the training online or on-site?