From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Visuals using conditional formatting

Visuals using conditional formatting

From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Start my 1-month free trial Buy for my team

Visuals using conditional formatting

“

- [Instructor] Conditional formatting applies various formats based on condition we specify like we can highlight values that are greater than 1000 or we can show above or below average. When you sort and then you mix in meaningful conditional formats, you can easily discover information faster than any other traditional sort. We've been focused on the totals and we filtered them to 55,000 and up. We've created a combo chart to capture the PO counts and the total amounts as the sample visual. But let's go back over to our PO counts again and let's sort those total amounts highest to lowest. So I'll travel over to my file here. Okay, one of the things I want to do because I'm going to supply conditional format. So I'm going to go ahead and change this table format. I'll go to table design and I'm just going to choose no format. I do want to go ahead and sort my total amount, highest to lowest, so I'll right-click and I'll sort it largest to smallest. Now that we've sorted the column…

Contents