From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Summarize data with conditional formatting
From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)
Summarize data with conditional formatting
- [Instructor] Using conditional formatting is a great way to summarize your data. In this video, we will review the conditional formatting rule for showing items that are greater than or less than a specific amount. We'll also work with a conditional formatting rule that will show us items that are above or below average. We'll take a look at a conditional formatting rule that allows us to see the top five percent or the bottom five percent of our range of cells. On the Excel 2016 MOS exam, you may have one or two questions asking you to apply conditional formatting for a specific rule. So, we're going to explore how to use this great tool and I'll give you examples along the way of what you might encounter on the exam. I have the zero three zero three exercise file open, so let's go ahead and get started. Working with our first worksheet, 2016 Commission, let's take a look at the sales for each of our sales reps. I want to select all of the sales data, so I'm going to start in cell…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.