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格式，不包含任何宏。
翻译自: https://contexturesblog.com/archives/2019/02/07/how-to-make-an-order-form-in-excel/
excel制作订单管理系统
