Process Modeling with Excel VBA

Excel VBA: Process Modeling

Excel power users: Learn how to use Excel and VBA to create and run simulations on business processes for customer flow, queuing, and manufacturing. Visual Basics for Applications exponentially extends Excel's power, allowing you to control process flow and logic and add custom classes and variables. In this exercise-centered training, We build simulations of increasing complexity, which model the flow of customers through checkout stations. You'll learn how to calculate arrival and transaction times, add customers, and increase individual station capacity, and find out when you need to add more stations. At the end of the course, We show 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
•  
•  
• Reach out to us for more details on outreach@opencastlabs-africa.com