Applying conditional formatting
- [Voiceover] We have learned to format cells…using number formats,…allignment options and cell styles.…But we can also create rules and conditional formatting…that will apply specific formatting…when certain conditions are met.…During the Excel 2013 MOS exam,…you may be asked to demonstrate your knowledge…and understanding of conditional formatting.…Let's explore the various methods…of applying conditional formatting…and how we can create simple rules…to change the formatting of data…that meet that rule criteria.…There is also a new tool in Excel 2013…that I think you're going to love.…
It's the Quick Analysis tool.…And this tool allows us to quickly apply…conditional formatting to a range of cells.…In this video, we will learn how to create rules,…modify those rules,…and use that Quick Analysis tool.…Notice the MOS icons next to two of these items.…Remember that means that creating rules…and modifying rules will probably be…on your Excel 2013 MOS exam.…So we'll focus on those two things.…I have the 03_06 exercise file open.…
Author
Released
4/4/2016Disclaimer: Microsoft does not produce, provide, or endorse this video training course.
The course first explores the MOS certification program, its cost, and its format. Jennifer then walks through all of the Excel certification objectives in detail. She includes free practice files so you can follow along as she demonstrates each skill. There are challenges to test your skills at the end of almost every chapter, and the full-length, 50-minute practice exam at the end of the course will ensure you're ready for the real exam.
- Preparing for the exam
- Understanding the registration process
- Creating new Excel workbooks and worksheets
- Formatting data
- Inserting columns and rows
- Moving data
- Applying conditional formatting
- Creating tables
- Applying formulas and functions
- Summarizing data
- Creating charts
- Taking a full-length practice exam
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2013 Essential Training
with Dennis Taylor6h 32m Intermediate -
Excel 2013: Charts in Depth
with Dennis Taylor3h 46m Advanced
-
Introduction
-
Welcome48s
-
-
1. Microsoft Office Specialist Exam Overview
-
Prepare for the exam2m 12s
-
2. Create and Manage Workbooks and Worksheets
-
Create new workbooks3m 20s
-
-
3. Create and Modify Cells and Ranges
-
Apply conditional formatting6m 32s
-
Create and use named ranges4m 50s
-
Use Find and Replace5m 28s
-
Solution: Cells and ranges5m 57s
-
4. Create and Modify Tables
-
Create tables6m 15s
-
Modify tables4m 51s
-
-
5. Apply Formulas and Functions
-
Format with text functions7m 49s
-
6. Create Charts and Objects
-
Format charts4m 44s
-
Solution: Charts and objects4m 44s
-
7. Final Practice Exam
-
Conclusion
-
Next steps22s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Apply conditional formatting