Making sense of bundled orders with Excel - Microsoft Excel Tutorial

(electronic music) - This is based on a real situation from a client who deals with musical equipment. (guitar music) They get a lot of orders from a lot of different places and stores, and then they get distributed to a lot of different places. (laughing) Yeah, we're going to need a bigger truck. There's also somebody in the middle, somebody who's in the back of this truck, who's putting stuff on it, and that person does not care who ordered what and how many. They don't care where it's going to be directed to. Somebody else figures out, two go here and five go here and one goes there, and this gets to be a big deal when the warehouse is much larger, and you got so many different items in bundles. You need a way of summarizing that. This is the person that my client needed to help, and this is how I whooped this on this client, and I'm going to whoop it on you now. In Excel, let's go. Here's our music warehouse. We have strings, basses, tuners, amps, and here is our list of orders in…