Modeling and Simulation using Excel
Welcome
This page supplements my articles in The Chemical Engineer. Beginning in February 2023 (Issue 980), this series provides tips and tricks for modeling and simulation using Excel and Visual Basic for Applications (VBA).
For Further Reading
Basics
Now you can master both basic and advanced skills in Visual Basic for Applications (VBA), the programming language for Microsoft Office. VBA FOR MODELERS: DEVELOPING DECISION SUPPORT SYSTEMS WITH MICROSOFT OFFICE EXCEL, 5E teaches you how to automate common spreadsheet tasks as well as create the sophisticated management science applicat
Now you can master both basic and advanced skills in Visual Basic for Applications (VBA), the programming language for Microsoft Office. VBA FOR MODELERS: DEVELOPING DECISION SUPPORT SYSTEMS WITH MICROSOFT OFFICE EXCEL, 5E teaches you how to automate common spreadsheet tasks as well as create the sophisticated management science applications needed in business today. The first half of the book introduces you to the fundamentals of VBA for Excel. The second half of the book puts knowledge into action as it illustrates how to automate a number of management science models using VBA. You learn how to create user-friendly interfaces for inputs and results. This new edition improves code readability, introduces PowerPivot and the new Excel Data Model and shows you how to pass information between modules and user forms while avoiding the use of global variables. VBA FOR MODELERS, 5E offers insights you need to maximize your skills in VBA.
Advanced
Become a master of data analysis, modeling, and spreadsheet use with BUSINESS ANALYTICS: DATA ANALYSIS AND DECISION MAKING, 6E! This popular quantitative methods text helps you maximize your success with its proven teach-by-example approach, student-friendly writing style, and complete Excel 2016 integration. (It is also compatible with
Become a master of data analysis, modeling, and spreadsheet use with BUSINESS ANALYTICS: DATA ANALYSIS AND DECISION MAKING, 6E! This popular quantitative methods text helps you maximize your success with its proven teach-by-example approach, student-friendly writing style, and complete Excel 2016 integration. (It is also compatible with Excel 2013, 2010, and 2007.) The text devotes three online chapters to advanced statistical analysis. Chapters on data mining and importing data into Excel emphasize tools commonly used under the Business Analytics umbrella -- including Microsoft Excel’s “Power BI” suite. Up-to-date problem sets and cases demonstrate how chapter concepts relate to real-world practice. In addition, the Companion Website includes data and solutions files, PowerPoint slides, SolverTable for sensitivity analysis, and the Palisade DecisionTools Suite (@RISK, BigPicture, StatTools, PrecisionTree, TopRank, RISKOptimizer, NeuralTools, and Evolver).
My Excel Series
My Excel Series
You may notice from the Rules of Thumb articles I have been writing that I often incorporate in my work calculations that I develop in Microsoft Excel and its scripting language Visual Basic for Applications (VBA). Engineers have many powerful software platforms and programming languages available such as MATLAB, Aspen and Python. I pers
You may notice from the Rules of Thumb articles I have been writing that I often incorporate in my work calculations that I develop in Microsoft Excel and its scripting language Visual Basic for Applications (VBA). Engineers have many powerful software platforms and programming languages available such as MATLAB, Aspen and Python. I personally use Excel whenever it is capable of solving my problems. It is seemingly installed on everyone’s computer, there is a huge support community, it handles inputs and outputs through a simple interface (ie no programming) and it is fun to use.