Excel power users: Learn how to use Excel and Visual Basic for Applications (VBA) to create and run simulations of business processes for customer flow, queuing, and manufacturing. VBA exponentially extends the power of Excel, allowing you to control process flow and logic and add custom classes and variables. In this course, Curt Frye demonstrates how to build simulations of increasing complexity, which model the flow of customers through a multi-station process. Learn how to calculate arrival times, add customers, increase individual station capacity, and enable conditional station paths. At the end of the course, Curt shows how to convert output to an Excel table and analyze the results of your simulation.

Topics include:

Creating a class module in VBA

Defining class properties

Creating collections

Describing process flow and programming goals

Creating loops

Increasing capacity of a model

Running simulations

Analyzing simulation results

Homepage:

https://www.lynda.com/Excel-tutorials/Excel-VBA-Process-Modeling/2810942-2.html