From the course: Excel for Sales Professionals

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Conditional formatting

Conditional formatting

From the course: Excel for Sales Professionals

Start my 1-month free trial

Conditional formatting

“

- [Instructor] Sometimes you're given a boatload of sales data, like this file here, which is the 04_01 - Conditional formatting file, and you think, jeez this is kind of overwhelming. Sure I could spend hours analyzing this data and studying it, but I'm in sales. I need to be meeting with customers and selling stuff. I don't have time to really study, so let me show you some ways to find quick insights from this data. Let's say in this Sales column, I want to find out just real quickly what the highest sales are and which are the lowest ones. I can press Control + Shift + Down Arrow, and that will select all of those sales amounts, and then this handy shortcut, Control + Q, and that brings up the Quick Analysis options. I'll hover over the Data Bars option first, and there you see a quick preview of what will happen to that column. You get these data bars that are small and they grow to larger lengths depending on the value inside the cell. Or you can hover over this Color option…

Contents