Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
In this worksheet called ApplianceSales, there are about 900 records and it covers data over a two-year period. And let's imagine that our filtering needs revolve around Column E, what's happening in the Date column. Let's apply the filter by going to the Data tab, clicking Filter. If you have worked with date filtering in the past, it's been one of the more cumbersome capabilities of Excel in the filter arena and very often in prior versions you needed to go into the so- called Advanced Filter to get these done.
I am going to click the drop arrow here and you will of course see date filters, just as we might have seen numeric filters or text filters, but huge expansions here. And imagine, perhaps thinking of your data, how you might use some of these filters to narrow down the data from certain months or weeks or quarters, and don't overlook the second to last choice here. All Dates in the Period. Now, I remember distinctly how in prior versions if you wanted to get data just from July and the data might have covered multiple years, this was not easy. Now it is.
I'm going to click July and we're seeing July data. There it is for 2011, there it is for 2010. It isn't necessarily sorted,. Maybe that has to do with how the data appeared ahead of time, but it's so easy to get to. And let's not overlook, also as we click this drop arrow, choose Date Filters, maybe we want to see the data from a certain quarter, and possibly next quarter, this quarter, or last quarter, but once again, going down to the second last choice here, how about just the data for Quarter 3 over the two-year period? And here too we might or might not want to sort the data, but we're seeing the data there for September and then August and July and so on and so on.
Maybe we want to sort on opposite order, but you get the idea here. Out of all our records here, 229 out of the 909 are from the third quarter, and it's so easy to get to with this new enhanced datefilter. Anybody who works with date type data will really appreciate the huge advances here with this capability.
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.