Excel制作订单管理系统
When you first start to use Excel, you probably work with files that somebody else set up. Eventually, you're ready to build a workbook of your own, and this video shows how to make an order form in Excel, starting from a blank workbook.
初次使用Excel时，您可能会使用他人设置的文件。 最终，您准备好构建自己的工作簿，该视频演示了如何从空白工作簿开端在Excel中创建订单。
Excel中的简单订单表格(Simple Order Form in Excel)
These instructions will help you make an order form in Excel, with drop down lists to choose products, and another drop down list to select a customer.
这些说明将协助您在Excel中创建订单表单，其中包括用于选择产品的下拉列表以及用于选择客户的另一个下拉列表。
The video also shows you to to set up the formulas that return the customer address, and other formulas to get the product price and calculate totals.
该视频还向您展示了如何设置返回客户地址的公式，以及其他公式来获取产品价格并计算总计。
观看视频 (Watch the Video)
This video shows shows how to make an order form in Excel, step by step, starting from a blank workbook. The timeline below the video shows when each step begins.
该视频显示了如何从空白工作簿开端逐步在Excel中制作订单表格。 视频下方的时间轴显示了每个步骤的开端时间。
To follow along, you can get the sample file from my Contextures site. It has the product list and customer list, so you don't have to spend time typing those.
接下来，您可以从Contextures网站上获得样本文件 。 它具有产品列表和客户列表，因而您不用花费时间输入这些内容。
演示地址
影片时间表 (Video Timeline)
00:00 Intro 00:00简介 01:00 3 Sheets 01:00 3张 02:26 Excel Tables 02:26 Excel表格 03:27 Named Ranges 03:27命名范围 05:34 Start the Order Form 05:34启动订单 06:21 Add the Headings 06:21添加标题 06:58 Product Drop Downs 06:58产品下拉 07:43 Price Lookup 07:43价格查询 08:59 Add VLOOKUP 08:59添加VLOOKUP 10:09 Row Total 10:09行总计 11:26 Grand Total 11:26总计 12:06 Add Formatting 12:06添加格式 13:01 Customer Drop Down 13:01客户下拉 13:49 Customer Lookup 13:49客户查找 15:15 Combined Lookup 15:15组合查询 17:44 Final Formatting 17:44最终格式化 18:34 Get the Sample File 18:34获取示例文件
获取书面说明 (Get Written Instructions)
If you prefer to read the instructions, instead of watching a video, you'll find those on the How to Create an Excel Order Form page, on my website.
假设您喜欢阅读说明，而不是观看视频，可以在我的网站的“如何创建Excel订单表”页面上找到这些说明。
That page has detailed instructions, and all the formulas, and screen shots for each step.
该页面提供了详细的说明，每个步骤的所有公式和屏幕截图。
获取完好的订单表格 (Get the Completed Order Form)
To see how the order form works, you can get the completed file from my Contextures site. The zipped file is in xlsx format, and does not contain any macros.
要查看订单的工作方式，您可以从Contextures网站上获取完好的文件 。 压缩文件为xlsx格式，不包含任何宏。
