如何在EXCEL中创建库存清单

方法 1

方法 1 的 2:使用模板

WH.shared.addScrollLoadItem(‘1c47310a67d5c4fe3464a2a3fd03927a’)

WH.performance.clearMarks(‘image1_rendered’); WH.performance.mark(‘image1_rendered’);{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9a/Create-an-Inventory-List-in-Excel-Step-1-Version-4.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-1-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/9a/Create-an-Inventory-List-in-Excel-Step-1-Version-4.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-1-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
1
打开Excel软件。软件是深绿色的图标,上面有白色的“X”。
WH.performance.mark(‘step1_rendered’);

WH.shared.addScrollLoadItem(‘fd54064eb36313d3fa07be86fef3b896’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/88/Create-an-Inventory-List-in-Excel-Step-2-Version-4.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-2-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/88/Create-an-Inventory-List-in-Excel-Step-2-Version-4.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-2-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
2
点击搜索栏。搜索栏位于Excel窗口的顶部。
Mac电脑中,先点击左上角的“文件”,然后在下拉菜单中点击“从模板创建新文件…”。

WH.shared.addScrollLoadItem(‘eb692ee6797afb0dca94e3e5c2fbdbd4’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/ae/Create-an-Inventory-List-in-Excel-Step-3-Version-4.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-3-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/ae/Create-an-Inventory-List-in-Excel-Step-3-Version-4.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-3-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
3
搜索库存清单模板。在页面顶部的搜索栏输入库存清单,然后按回车键。这样将显示出用于库存管理的模板列表。

WH.shared.addScrollLoadItem(‘ab59254009720767be2e350d7413b3bf’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/19/Create-an-Inventory-List-in-Excel-Step-4-Version-4.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-4-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/19/Create-an-Inventory-List-in-Excel-Step-4-Version-4.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-4-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
4
选择一个模板。点击选择最符合自己需求的库存清单模板,将会打开预览页面。
每个库存清单模板的功能各不相同。如果你不喜欢所选的模板,按Esc 键可以返回模板列表页面。

WH.shared.addScrollLoadItem(‘a30b309e1ca4feb1ea0d70c0af162464’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6e/Create-an-Inventory-List-in-Excel-Step-5-Version-4.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-5-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6e/Create-an-Inventory-List-in-Excel-Step-5-Version-4.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-5-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
5
点击创建。这个按钮位于模板预览窗口的右侧。

WH.shared.addScrollLoadItem(‘b062c3d65786dd69c543aade06d39699’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4d/Create-an-Inventory-List-in-Excel-Step-6-Version-4.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-6-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/4d/Create-an-Inventory-List-in-Excel-Step-6-Version-4.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-6-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
6
等待模板加载。这可能需要几秒钟时间,模板打开后就可以继续了。

WH.shared.addScrollLoadItem(‘6a756217395a8be019c16ceb7ca0306b’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/94/Create-an-Inventory-List-in-Excel-Step-7-Version-4.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-7-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/94/Create-an-Inventory-List-in-Excel-Step-7-Version-4.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-7-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
7
输入库存信息。要修改预先填好的单元格,需双击该单元格,删除原来的数字或文字,然后输入你的库存信息。虽然选择的模板中有些选项可能略有不同,但每个清单都应包含以下选项:

货物编码 – 货物的库存(SKU,最小存货单位)编码。

货物名称 – 货物的描述性名称。

货物成本 – 单件货物的成本。

库存数量 – 某样货物的数量。

净值 – 某样货物库存的总价值。

WH.shared.addScrollLoadItem(’62dfdf7571287188772588d1ae4170c2′)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/7d/Create-an-Inventory-List-in-Excel-Step-8-Version-4.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-8-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/7d/Create-an-Inventory-List-in-Excel-Step-8-Version-4.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-8-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
8
保存所做的工作。保存方法如下:

Windows – 点击文件,点击另存为,双击本电脑,在窗口的左边点击选择一个保存位置,在“文件名”文本框中输入文件名称(例如“库存清单”),然后点击保存。

Mac – 点击文件,点击另存为…,在其栏内输入文件名称(例如“库存清单”), 点击“位置”并选中一个文件夹作为保存位置,点击保存。

WH.ads.addBodyAd(‘method_ad_1’)

广告

WH.ads.addBodyAd(‘mobilemethod_ad_1’)

方法 2

方法 2 的 2:重新创建

WH.shared.addScrollLoadItem(‘6fe05f8e7cf250eaf50942355b7e9284’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/19/Create-an-Inventory-List-in-Excel-Step-9-Version-3.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-9-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/19/Create-an-Inventory-List-in-Excel-Step-9-Version-3.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-9-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
1
打开Excel软件。该软件图标是一个里面有白色“X”的绿色盒子。

WH.shared.addScrollLoadItem(’04b5e2663584990d2f2fba7cc07e5d22′)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6d/Create-an-Inventory-List-in-Excel-Step-10.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-10.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6d/Create-an-Inventory-List-in-Excel-Step-10.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-10.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
2
点击空白工作簿。该选项位于窗口的左上角。
Mac中跳过这一步。

WH.shared.addScrollLoadItem(‘8a8bac10e5f43f90a3a750924228a608’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3c/Create-an-Inventory-List-in-Excel-Step-11.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-11.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/3c/Create-an-Inventory-List-in-Excel-Step-11.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-11.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
3
创建清单列表的标题。在以下单元格中输入如下标题:

A1 – 货物编码

B1 – 货物名称

C1 – 货物成本

D1 – 货物数量

E1 – 净值

WH.shared.addScrollLoadItem(‘3b8882fa8dc98730814237f0d4cde309’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/42/Create-an-Inventory-List-in-Excel-Step-12.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-12.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/42/Create-an-Inventory-List-in-Excel-Step-12.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-12.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
4
调整列宽。点击表格顶部两列(如A和B)之间的空间,然后将鼠标向右拖拽增加列宽。

WH.shared.addScrollLoadItem(‘2659fab5b4c1c717cf33cd52f4bf66f6’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8a/Create-an-Inventory-List-in-Excel-Step-13.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-13.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/8a/Create-an-Inventory-List-in-Excel-Step-13.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-13.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
5
输入货物的库存编码。点击A2单元格,输入货物的库存编码(例如:123456),然后按回车键。

WH.shared.addScrollLoadItem(‘b9bbd1babd7cc3ae5cecce9285002cb5’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/14/Create-an-Inventory-List-in-Excel-Step-14.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-14.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/14/Create-an-Inventory-List-in-Excel-Step-14.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-14.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
6
添加货物名称。点击B2单元格,输入货物的正式名称(例如:尼龙扎带)。

WH.shared.addScrollLoadItem(‘6b2fdca623bdad3c260f37c3bf89a150’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/79/Create-an-Inventory-List-in-Excel-Step-15.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-15.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/79/Create-an-Inventory-List-in-Excel-Step-15.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-15.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
7
确定每件货物的成本。点击C2单元格,然后输入货物的单独成本(例如 4.99)。

WH.shared.addScrollLoadItem(‘da2d4c3e7ab5ebe95e31ad31838139da’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/94/Create-an-Inventory-List-in-Excel-Step-16.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-16.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/94/Create-an-Inventory-List-in-Excel-Step-16.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-16.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
8
添加你拥有的货物总数。点击D2单元格,输入货物的库存数量(例如,假设你有80件尼龙扎带,就输入80)。

WH.shared.addScrollLoadItem(‘01618d5fe240db379c82e35dcd6b78f8’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/89/Create-an-Inventory-List-in-Excel-Step-17.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-17.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/89/Create-an-Inventory-List-in-Excel-Step-17.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-17.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
9
输入净值公式。点击E2单元格,输入=C2*D2并按回车键。你应该马上就能在单元格中看到计算出的净值。
你可以在“净值”一列中的每个单元格中重复这个通用公式——只要确保代替C2和D2的单元格输入正确(例如,假设要将C10和D10单元格里的数值相乘,需用这两个单元格替换C2和D2)。

WH.shared.addScrollLoadItem(‘146ad7e2d05d732b472e96c29361c996’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/71/Create-an-Inventory-List-in-Excel-Step-18.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-18.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/71/Create-an-Inventory-List-in-Excel-Step-18.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-18.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
10
将其他货物添加到货物清单中。将清单中的每样货物重复上述过程。每行填写一个货物直至填满列表。

WH.shared.addScrollLoadItem(‘2710a715ae098770a9be12c55768659e’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2f/Create-an-Inventory-List-in-Excel-Step-19.jpg/v4-460px-Create-an-Inventory-List-in-Excel-Step-19.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2f/Create-an-Inventory-List-in-Excel-Step-19.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-19.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
11
保存工作。保存方法如下:

Windows – 点击文件,点击另存为,双击本电脑,在窗口的左边点击选择一个保存位置,在“文件名”文本框中输入文件名称(例如“库存清单”),然后点击保存。

Mac – 点击文件,点击另存为…,在其栏内输入文件名称(例如“库存清单”), 点击“位置”并选中一个文件夹作为保存位置,点击保存。

广告

WH.ads.addBodyAd(‘mobilemethod_ad_2’)

发表评论

您的电子邮箱地址不会被公开。