video tutorial for excel 2013 free download

If you want to customize Oder-Matic to your needs may I suggest that you go through the tutorials and get this working as I have created it and then customize the project? You will have better success if you first understand how the application is pieced together. To help with the learning process I have added videos to show the steps involved. The template for order and inventory management (Order-Matic) is available for download below and all of the code will be included in the article. The calender is also included in the template. I have left the data in so that you will have something to work with as you proceed with the project. The 6 sheets are shown in this illustration describing their function. Here are all of the worksheets in the template I have not included charting for the filtered results this however this would be an easy aspect to include. The key feature of this application is the ability to filter and view orders by any criteria or time.

It is designed for training purposes but could be modified to suit your individual needs. Order-Matic: Order and Inventory Management in Excel will enable you to add your orders and instantly see if the stock exists to cover the order. I have had requests for an application like this when I released the Invoice Generator. This application will work in Microsoft Excel 2003 / 2007 / 2010 / 2013.

Order and Inventory Management: May I take your order? Part 6.

Order and Inventory Management: May I take your order? Part 5.

Order and Inventory Management: May I take your order? Part 4.

Order and Inventory Management: May I take your order? Part 3.

Order and Inventory Management: May I take your order? Part 2.

Here are all of the worksheets in the template.

Order and Inventory Management: May I take your order? Part 1.

Video tutorial for excel 2013 free download