A tidy house, a tidy mind – that’s what they say. But even a well maintained Excel spreadsheet may at some point become confusing and complex due to the ever growing amount of data. Still, it is not that difficult to keep an overview and quickly find the information you’re looking for. That’s why in today’s Special Topic we will show you how to filter and sort data appropriately. Use the Autofilter or the Advanced Filter in order to define exactly what part of the data you want to be displayed. A special case that will be treated in an extra video is sorting data using custom lists.

Published on: 30.04.2013

To acces the videos for this Special Topic you must have subscribed to Excel !


Excel 2016

Filtering Data (Autofilter)  
This video will show you how to use the autofilter. You will learn how to filter data by certain criteria and what you have to keep in mind when evaluating the filtered data. (5 Min.)

Filtering Data (Advanced Filters):  
This video will show you how to filter data even by the most complicated criteria using the advanced filter. (8 Min.)

Sorting Tables  
This video will show the different options for sorting range tables by its content. (4 Min.)

Using Custom Lists:  
In this video you will learn how to create custom lists which you can easily add to your tables at a later time. In addition we will show you how to define your own sorting criterias. (4 Min.)



Excel 2013

Filtering Data (Autofilter)  
This video will show you how to use the autofilter. You will learn how to filter data by certain criteria and what you have to keep in mind when evaluating the filtered data. (5 Min.)

Filtering Data (Advanced Filters):  
This video will show you how to filter data even by the most complicated criteria using the advanced filter. (8 Min.)

Sorting Tables  
This video will show the different options for sorting range tables by its content. (4 Min.)

Using Custom Lists:  
In this video you will learn how to create custom lists which you can easily add to your tables at a later time. In addition we will show you how to define your own sorting criterias. (4 Min.)



Excel 2010

Filtering Data (Autofilter)  
This video will show you how to use the autofilter. You will learn how to filter data by certain criteria and what you have to keep in mind when evaluating the filtered data. (5 Min.)

Filtering Data (Advanced Filters):  
This video will show you how to filter data even by the most complicated criteria using the advanced filter. (8 Min.)

Sorting Tables  
This video will show the different options for sorting range tables by its content. (4 Min.)

Using Custom Lists:  
In this video you will learn how to create custom lists which you can easily add to your tables at a later time. In addition we will show you how to define your own sorting criterias. (4 Min.)



Excel 2007

Filtering Data (Autofilter)  
This video will show you how to use the autofilter. You will learn how to filter data by certain criteria and what you have to keep in mind when evaluating the filtered data. (5 Min.)

Filtering Data (Advanced Filters):  
This video will show you how to filter data even by the most complicated criteria using the advanced filter. (8 Min.)

Sorting Tables  
This video will show the different options for sorting range tables by its content. (4 Min.)

Using Custom Lists:  
In this video you will learn how to create custom lists which you can easily add to your tables at a later time. In addition we will show you how to define your own sorting criterias. (4 Min.)