From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Working with inventory percentages

Working with inventory percentages - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Working with inventory percentages

“

- [Instructor] You and I run a small workshop where people can come on weekends and work on crafts. We recently did an inventory to compare what we thought we had versus what we actually have. We thought we had 19 resin casts, but actually have seven. But look at that percentage column. Can you help me out with that please? First, in that percentage column, show a percent, out to two decimal places, and then use conditional formatting to highlight any values that are less than 80%. That'd be so helpful. So please, pause the video, clean that column up, come back, and I'll show you a way to do this. All right, let's clean this up. I'm going to highlight this range. Go to percent, and I want it out to two decimal places. Want to increase the decimals, one, two, there we go. 44.44% of purple modeling clay. All right, now we need the conditional formatting and we can get out of here. Highlight Cell Rules, less than, then…

Contents