Conditional formatting is not new in Excel 2016, but it can be applied differently than it was in Excel 2010. In this movie, you will know how to apply conditional formatting to a range of cells using the Quick Analysis tool, and then customize that formatting via the ribbon as you would in Excel 2010.
- [Voiceover] In this movie we're going to…expand on conditional formatting.…Something that's not new here in Excel 2016,…but there is a new way to apply…conditional formatting.…If you're not familiar with it,…it's formatting that's applied to…selected data based on conditions.…For example, high numbers may be formatted…in green and low numbers in red.…Or you may see icons, data bars…that we talked about in a previous movie.…We're gonna continue working with our…Landon Hotel sheet, 0304, if you're catching up.…Next we're gonna scroll over here.…
Make sure you can see Q4 data.…We already created a chart based on…some of this data.…We're gonna reselect the same data,…which is from cell N10 across and down…to P12.…And there's that Quick Analysis Tool…that appears every time we select data.…Control + Q, the keyboard shortcut.…And when we select it, we're going to see…some options under formatting.…This is Conditional Formatting.…We've already talked about Data Bars…and how they work.…But there's colors and icon sets.…You can see what's happening in the background.…
Author
David Rivers
Released
7/20/2016- Describe when you would use Touch mode.
- Explain how to use the navigation pane to search a document.
- Name the tool that converts older versions of templates to new versions.
- Cite the tool that allows you to create charts quickly.
- Recall how to separate data from one column into two columns.
- Describe the features of Presenter view and explain when you would use it.
- Explain sneak peek and when you would use it.
- Cite the pane where you can get weather updates.
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome56s
-
-
1. Get Started
-
Explore changes to the UI9m 59s
-
Understand cloud computing5m 42s
-
Explore Touch mode3m 44s
-
2. Migrate to Word 2016
-
Understand file formats4m 8s
-
Use the Tell Me assistant3m 41s
-
Open and edit PDF files2m 5s
-
Work with images5m 6s
-
-
3. Migrate to Excel 2016
-
Use quick analysis options5m 30s
-
Create charts quickly3m 22s
-
Format tables and sheets5m 30s
-
Extract data with Flash Fill4m 25s
-
4. Migrate to PowerPoint 2016
-
Explore presentation themes2m 30s
-
Work in Presenter view4m 59s
-
Work with shapes4m 41s
-
Move objects on a path5m 1s
-
5. Migrate to Outlook 2016
-
Use peeks4m 4s
-
Send attachments2m 6s
-
Use the notes function2m 10s
-
Conclusion
-
Next steps50s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Use conditional formatting