From the course: Microsoft Copilot for Excel (2024)
Join today to access over 24,900 courses taught by industry experts.
Applying color scales and data bars
From the course: Microsoft Copilot for Excel (2024)
Applying color scales and data bars
- [Instructor] Now that we've covered highlighting data in different scenarios, I want to quickly cover the other types of conditional formatting, particularly color scales and data bars, both of which are ideal for making quick comparisons and identifying patterns across a numerical column. So let's start by applying data bars to our salary column. Let's launch Copilot and the prompt can be exactly that, so apply data bars to the salary column. Send that prompt over, wait for it to do its magic. And after fast forwarding, you'll see that again, it's a conditional formatting rule being applied. In this case, a data bar using gradient green. Let's go ahead and apply that and pay attention to this salary column. So before when we just had the numbers, it was hard to make out any differences between the salaries without having to pay very close attention. But now our eyes are immediately drawn to the highest salaries, which are these, these, and these, what we can do is make this column…
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.