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.