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.

Solution: Ad hoc presentation

Solution: Ad hoc presentation

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

Start my 1-month free trial Buy for my team

Solution: Ad hoc presentation

“

(upbeat music) - [Instructor] Okay. I'm going to start with my first requirement, which is to sort my total amount, highest to lowest. So I'll right click. Go to sort. I'll sort largest to smallest. My second requirement is to highlight the total counts of POs that are above the average, using some form of red as an indication. So I'll go ahead and highlight these values. I'll go to my conditional formatting. I'll go to my top bottom rules. And I'll choose my above average, as my requirement states. And I'll use that light red fill and dark red text. Okay, I'll go ahead and click okay. My next requirement is to highlight the total amounts that are 15% or more. So I'm going to go ahead and highlight this range. I'll go to conditional formatting. Go to my top bottom rules. I'll go to top 10% and change that to 15. And because these are good, I'll use green, based on my requirements. Okay. And then I can immediately see that I have a total amount in the top two, or actually in the top…

Contents