Join David Rivers for an in-depth discussion in this video Showing data with sparklines, part of Migrating from Office 2007 to Office 2010.
…Earlier in this chapter we learned how conditional formatting can…help us visualize data picking out highs, lows, mid-ranges etc.…What conditional formatting does not do is show us trends.…Typically we would use charts for that but there is a new feature here in…Excel 2010 that will allow you to pick out trends without creating full blown charts,…it's called Sparklines and we are going to take a look at it now.…As we continue with our No Obstacles Home Sales workbook.…If you skip to this movie to get caught up you can open up no obstacles home…sales five from the chapter three folder of the exercise files.…
We're going to go over to the sales by region tab where we did set up a table.…And we also set up some conditional formatting for the values in this table.…Now we're going to insert Sparklines and…that means going up to the Insert tab on the ribbon.…There's the new category Sparklines.…We can create lines, columns, even win/loss to show upper and lower values.…Let's go to column, we'll start there.…
- 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.