I’ve been in the IT industry for some years, having been both in distribution and vendor. At some point in the sales cycle, a price quotation needs to be made. If you have been involved in this process, you would probably realize how cumbersome it is to manually sort through a vendor’s price book to look for the correct part number based on the product and the band pricing, before decking out a table with line items and price. While this takes up your precious time and energy, it also keeps the possibility of human error pretty high. Enter Microsoft Excel.
Microsoft Excel is no stranger to most of us. In this tutorial, I show step-by-step how to make a simple price quotation template using Microsoft Excel, which can potentially help you cut many minutes to an hour each time you need to do a price quote to your distributor, reseller or customer.
This tutorial involves needing to know beforehand the following Excel formula functionalities:
- Data Validation (External link to Microsoft)
- VLOOKUP (External Link to Microsoft)
- IF (External Link to Microsoft)
You would also realize by the end of this video, that the example is oversimplified when you compare it with real price lists/books that you are probably working with. If you have any questions at all that you want to ask about in relation to price lists/books that you are working on, please feel free to hit me with a private message, and I’ll see how I can help you.
Without further ado, here is the tutorial video: