How to Manage Inventory on Excel (With VBA) Part 2
How to Manage Inventory on Excel (With VBA) Part 2
This is the Part two Video Tutorial on our New Inventory Management Template. This Template was designed for a Subscriber in the Marine Industry. They had challenges in managing the Spare Parts used to maintain and repair their Vessels, Machines & Vehicles and also to track the availability if these spare parts and other Inventory consumables.
With this Template, you can perform the following;
1. Manage over 20,000 Inventory Items with various reports and Pivot Table Filter.
2. Set the R-Order Level
3. Receive Inventory, Issue Inventory & Track the Available Inventory
4. Maintain a Supplier Database
5. Maintain Assets Maintenance database
6. Generate Average Unit Cost of items on monthly and yearly basis
7. Automated Inventory Status
8. Generate Various reports for Accounts and Management
9. Manage Inventory Physical Count Report
10. Set Staff users and restrict users to some Sheets and Lot's more. The videos tells is all!
This Template can be automated to suit your Organization and Inventory Needs. This Template is not available on our Free Template Page, but you can request for a Demo by visiting our CONTACT PAGE http://www.theaccountsolutions.com/p/contact-us.html or request for a Customized Excel Template by visiting http://www.theaccountsolutions.com/p/customize.html.
Ensure that you see the Part 1 Video Demo before this Part 2. This is the link to the Part 1; https://www.youtube.com/watch?v=FECSVgXB5rg
Видео How to Manage Inventory on Excel (With VBA) Part 2 канала TheAccountSolutions
This is the Part two Video Tutorial on our New Inventory Management Template. This Template was designed for a Subscriber in the Marine Industry. They had challenges in managing the Spare Parts used to maintain and repair their Vessels, Machines & Vehicles and also to track the availability if these spare parts and other Inventory consumables.
With this Template, you can perform the following;
1. Manage over 20,000 Inventory Items with various reports and Pivot Table Filter.
2. Set the R-Order Level
3. Receive Inventory, Issue Inventory & Track the Available Inventory
4. Maintain a Supplier Database
5. Maintain Assets Maintenance database
6. Generate Average Unit Cost of items on monthly and yearly basis
7. Automated Inventory Status
8. Generate Various reports for Accounts and Management
9. Manage Inventory Physical Count Report
10. Set Staff users and restrict users to some Sheets and Lot's more. The videos tells is all!
This Template can be automated to suit your Organization and Inventory Needs. This Template is not available on our Free Template Page, but you can request for a Demo by visiting our CONTACT PAGE http://www.theaccountsolutions.com/p/contact-us.html or request for a Customized Excel Template by visiting http://www.theaccountsolutions.com/p/customize.html.
Ensure that you see the Part 1 Video Demo before this Part 2. This is the link to the Part 1; https://www.youtube.com/watch?v=FECSVgXB5rg
Видео How to Manage Inventory on Excel (With VBA) Part 2 канала TheAccountSolutions
Комментарии отсутствуют
Информация о видео
7 декабря 2017 г. 18:23:54
00:33:23
Другие видео канала