This short course is designed to get you acquainted with Excel tables fast. Tables also allow for easy data entry and formula creation, making it faster to copy formulas and create totals or counts on the fly.
This short course is designed to get you acquainted with Excel tables fast. Converting your Excel 2013 data range into a table (formerly known as lists) can help you be more efficient and effective by allowing you to quickly sort, filter, and format data. Tables also allow for easy data entry and formula creation, making it faster to copy formulas and create totals or counts on the fly.
Sorting Data While we have data that's formatted as a table, the sorting becomes so easy, here's what we do, we click into the column we want to sort by, anywhere in the column, I'd like to sort alphabetically by last name, we can head to the data tab at the top, in the sort and filter group we've got A to Z to sort ascending, give it a click, we have sorted by last name. Maybe I'd like to sort by state, but descending, so I click anywhere in the column with the state, head back into the sort and filter group, there's my Z to A button, sort descending, ta da, this is a quick and easy way to sort, we've got other methods, tune in for the next lessons. I hope you found this information helpful, and I look forward to seeing you, in the next lesson.
Filtering Data When we have our long list of data, we're always looking for the quickest way to find what we need, filters are the way to get it done. Filters will hide what we're not interested in seeing, and show what we are interested in seeing, so let's head over to the state column, use the drop down arrow at the top, and let's head down into the middle. Yeah look at this we've got the select all, and it is checking every single state, uncheck select all, nobody is selected, and we can then pick the states that we're interested in, so I can grab a couple of states in here, click OK and my list is filtered on my selection. Let me bring those back, clear the filter from state, something else we can do is go into the state drop down and we can pick only one, we can always do that, just make one choice, and click OK, pick what you need. I hope you found this information helpful, and I look forward to seeing you in the next lesson.
Finding and Adding Data Occasionally when we're ready to do a filter, we see that there is a long list of items to pick from, come with me over to the state column, long list, I don't want to have to scroll to find the ones that I can pick and check, there's a faster way, see the search box? Love the search box, I can click in and if I'm looking for Texas I type the letter T, it filters the list in the filter list, and now I see CT, TN, TX, I could uncheck the ones that I'm not interested in seeing, but if I keep typing it picks it for me, and then I can click OK. Pretty nice, well how about this? Back to state, click in the search, I type in the letter P for Pennsylvania, it's the only one that shows up, I press Enter, I'm not even going to click OK I'm going to press Enter, filter is done, talk about speedy. I hope you found this information helpful, and I look forward to seeing you in the next lesson.
Formatting Tables When we convert our data list into a table we get this standard color scheme, the blue and the white. And it's good I like it, but we don't have to stick with it, oh no you can change it to a color scheme of your choice, if we're interested in doing that we must be clicked into the data table, and we will have the table tools designed to have at the top. Give it a click; we're heading out to the right for the table styles, quick styles, and wow, lots of color choices, now not only can we pick them, but live preview works in here, so if you float over them you can see it on your table before you pick it. So float around, find the one that makes you happy, yes how are you feeling today? There's more to if we scroll down, down, down, down, there's a bunch down here to, so float around, of course we've got to try them all on right? Which is the one that makes you happy, once you find it, give it a pick, and you've got your new color scheme, that's why it's called quick styles. I hope you found this information helpful, and I look forward to seeing you in the next lesson.