Join David Rivers for an in-depth discussion in this video Filtering data with table headers, part of Migrating from Office 2007 to Office 2010.
…By converting our range of data into a table, you get some filtering options.…And there are some new ones here in Excel 2010 that you didn't get in Excel 2007.…So let's take a look with our table here in our sales by region sheet.…If you skip to this movie, open up no obstacles home sales three.…From the chapter three folder of your exercise files.…Let's turn this range into a table,…including the header row here with product and the various regions.…So we'll click and drag across and down.…
And, we'll add the grand total at the bottom as well so it's all part of…a table we're about to create by going to the Insert tab and selecting Table.…Notice the range is already there for…us and my table has headers, yes that's checked off.…That'll be Product NE, NW, SE and SW including Total.…We'll click OK, and right away we see those filtering drop-downs.…Now we saw this in Excel 2007.…The nice thing here in Excel 2010, if this data went on past one screen full unless…we scroll down this Header row stays put so we always know what we are looking at.…
- Understanding the reasons to switch
- Customizing the ribbon
- Saving to the cloud
- Adding screenshots to files
- Understanding file formats and compatibility
- Using conditional formatting in Excel
- Saving presentations as video
- Importing Outlook contacts, calendars, email, and more
Skill Level Intermediate
Word 2010 Essential Trainingwith Gini von Courter8h 3m Beginner
Outlook 2010 Essential Trainingwith Karen Fredricks2h 55m Beginner
PowerPoint 2010 Essential Trainingwith David Diskin3h 24m Beginner
1. Getting Started
2. Migrating to Word 2010
3. Migrating to Excel 2010
4. Migrating to PowerPoint 2010
5. Migrating to Outlook 2010
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.