Join David Rivers for an in-depth discussion in this video Filtering data with slicers, part of Migrating from Office 2007 to Office 2010.
…There's a new feature here for those of you who like to work…with pivot tables that will help you filter out and analyze your data.…We're going to take a look at slicers now here in Excel 2010.…And you'll need to open up NoObstaclesHomeSales4 from…the exercise files, Chapter Three folder and go to the Sales by Rep tab.…We have new tab down here, new worksheet that has some additional information.…All we're going to do is create a pivot table out of some of this information.…So we'll select the range, that's going to be from A3, across and down, to C15.…
Next we go up to Insert and select Pivot Table.…Over here where we see the create pivot table dialog,…the range is already selected for us.…We're going to put it in the existing worksheet.…So we can look at it side by side, click this little icon to…select where were going to put it, let's just put it right here in F2.…We'll expand that again and click okay.…All right, so we're ready to create our pivot table by choosing the fields that we…want to add to this report.…
- 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.