Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In this course, Dennis Taylor shares easy-to-use database commands and methods for maintaining an Excel database. The course covers sorting, adding subtotals, auto-filtering, and using the Excel Advanced Filter feature and specialized database functions.
When you work with Excel's filtering capability, you should be aware of the fact that Excel does recognize the kind of field data you are working with. Let's suppose that in this particular worksheet we want to Fflter and maybe we want to filter by Date or Status. Sometimes we're not even sure. Let's apply the Filter. If we click the arrow for Status, we do see that Excel recognizes that as a text field and gives us somefilter possibilities. If we were interested in looking at Column G and applying a filter, that's a Date column, we see Date filters, a totally different kind of list there.
But let's suppose we're interested in the Salary column, Number filters, and we see some choices here and this is an expansion on prior capability in Excel. We simply want to find, for example, those records where people's salaries are within a certain range. So we'll choose Between. We don't have to worry about setting up the logic here. It's all done for us. We're interested, for example, in seeing all those records where the salaries are between 60,000 and 70,000. Click OK.
And there they are. We could sort those Descending, Ascending, as necessary. If on the other hand we say let's find all of those salaries above average. Once again, something new, easy to get to. We don't have to worry about setting up a formula. We don't have to refer to some cell that has that average in it. Above Average, and of course this is a moving target too. What are we seeing now? All the salaries that are above average. Lower left-hand corner reminds us that's roughly half the records. So the ability to get to numeric filtering is simpler and has been expanded.
It's a lot easier to use than prior versions. And once again, because Excel recognizes the kind of data that you have in a field, it makes filtering much more efficient.
Find answers to the most frequently asked questions about Managing and Analyzing Data in Excel 2010.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.