ATOI365D

#Office365Challenge – Excel – Data Filters.

Day: 139 of 365, 226 left
Tools: Excel
Description: Using Data Filters In Excel

When working with a lot of data in Excel, it’s valuable to be able to filter to see specific data. When your data has headers (names for the columns), you are able to use Data Filters.

To switch this on, go to the Data Tab > Filters. When selected you will see the filter dropdowns next to each column name:

DataFilters

This allows you to sort data as well as supply filters to only see selected data. With numbers you can do further filtering by opening “Numbers Filters”. Here you can define more filter criteria.

DataFilters2

And there’s another really cool thing about Excel!!

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.

Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.