From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Summarize data visually with built-in conditional formatting
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Summarize data visually with built-in conditional formatting
- [Instructor] Using conditional formatting makes it easy to find just what you're looking for, especially if you're trying to find your top 10 selling items. After watching this video, you'll know how to apply built-in conditional formatting and how to remove conditional formatting. Let's jump right into our conditional formatting workbook and take a look at our data. These are our Q1 internet orders. We have information for regions, order date, product quantity, status, and order amount. Let's first take a look at how we can apply conditional formatting to our region column. I'll start by selecting from A4 all the way down. And on the home tab, let's go to conditional formatting. Highlight cells rules and take a look at our options. We can have Excel apply a rule that if the value in the cell is greater than or less than a specific amount, the cell will be formatted with either a new cell font color or fill color. We can also have a rule applied if the value falls within a range or…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Paste data using special paste options6m 28s
-
(Locked)
Fills cells by using AutoFill4m 16s
-
(Locked)
Insert and delete columns, rows, and cells3m 15s
-
(Locked)
Format cells and ranges5m 39s
-
(Locked)
Apply styles to cells and ranges6m 44s
-
(Locked)
Define and reference named ranges5m 18s
-
(Locked)
Insert sparklines5m 35s
-
(Locked)
Summarize data visually with built-in conditional formatting5m 3s
-
(Locked)
Challenge: Manage data, cells, and ranges27s
-
(Locked)
Solution: Manage data, cells, and ranges4m 23s
-
-
-
-
-
-