Join David Rivers for an in-depth discussion in this video Using conditional formatting, part of Migrating from Office 2007 to Office 2010.
…When trying to analyze data, groups of numbers it can be difficult sometimes to…shift through and pick out the highest, the lowest the mid-range values for…example, that's where conditional formatting comes in.…It's not new to Excel 2010, you had it in Excel 2007, but there are some new…options available to us now so it's worth looking at as we continue with our…No Obstacles Home Sales worksheet here in the Sales by Region section.…If you skip to this movie, just open up NoObstaclesHomeSales2 from…the Chapter three folder of your exercise files.…
We're going to select a range of sales.…How about E4 across and down to H8.…There's a group of numbers that, when looking at them,…could be difficult to pick out the highest, the lowest, the mid-range values,…and imagine a bigger spreadsheet with even more numbers and…bigger numbers, how difficult that would be.…Well, conditional formatting can help us with that.…When we go up to the Style section here on the ribbon with the Home tab selected.…And give the Conditional formatting button a click,…
- 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.