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.

Excel in real life: Auditing inventory

Excel in real life: Auditing inventory - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Excel in real life: Auditing inventory

“

- [Instructor] You and I work in a warehouse and here is the afternoon pick-list, all of the stuff that we have to get to fill orders, but the list is not useful the way it is. We've gotta make some changes and fill some stuff in. First, in the master list, replace locations D4 and D18 with annex because those items have been moved to the annex. Then, fill in the location and in stock column in the pick-list with data pulled from the master list. Finally, create a column that checks to see if we have enough of each item in stock, meaning subtract the quantity in the pick-list from the in stock value. Pause the video, fill all this data in, come back, and I'll show you one solution. You're back, hope you did well. There are lots of different ways to do this. I'll show you one way. Let's get at it. First of all, replace D4 and D18 with annex. Let's move the objectives box. I'm gonna highlight the entire column L,…

Contents