From the course: Excel 2013 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Using filters - Microsoft Excel Tutorial
From the course: Excel 2013 Essential Training
Using filters
When you're working with large amounts of data as in the list here which has over 700 rows, you don't always want to see all of the data, we might want to see just the Full Time people, or just the people in certain departments, or just those who have been here so many years or have a certain Job Rating. The filtering capability of Excel works smoothly and easily. We're on the Filter worksheet in the workbook called 12-DatabaseFeatures. You can start filtering from the HOME tab by choosing the second button from the right and then choosing Filter or on the DATA tab in the Ribbon, simply click Filter. And that gives us Filter arrows in the top row of our list. If we want to see just the Full Time people, we'll click the arrow for Status and this gives us a complete list of all possible entries within the column. And we can begin here by un-selecting all of them and simply choosing Full Time and then OK. We are only viewing the Full Time people. In the Status bar on the lower left-hand…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.