Engineering Analysis & Modeling With Excel-vba: Course Notes

These course notes are for engineers, scientists, and others interested in developing custom engineering system models. Principles and practices are established for creating integrated models using Excel and its built-in programming environment, Visual Basic for Applications (VBA). Real-world techniques and tips not found in any course, book, or other resource are revealed. Step-by-step implementation, engineering application examples, and integrated problem exercises solidify the concepts introduced. LEARN HOW TO: Exploit the full power of Excel for building engineering models. Master the built-in VBA programming environment. Implement advanced data I/O, manipulation, analysis, and display. Create full featured graphical interfaces and interactive content. Optimize performance for multi-parameter systems and designs. Integrate interdisciplinary and multi-physics capabilities. TESTIMONIALS: "I worked through the course materials of 'Engineering Analysis & Modeling w/Excel/VBA' and would highly recommend it to other engineers.", Maury DuPont, University of Cincinnati "...the exercises were very easy to understand... followed extremely well after the learning slides that came before them. The instructions were detailed enough to understand, but still left enough leeway for individual learning", Monica Guzik, Rose-Hulman Institute of Technology €œGood introduction and quick functioning using VBA was enabled by this course€, Michael R. Palis, Hybricon Corporation €œGave me a lot to work with. Very helpful and hands on. [My favorite parts?]... It was all good€, Dale Folsom, Battelle €œReally enjoyed how much info was passed along in such a short and easily understandable method€, Will Rehlich, Noren Products €œExcellent€¦ Good overview of VBA programming€¦€, John Yocom, General Dynamics €œLots of useful information, and a good combination of lecture and hands-on€, Brent Warner, Goddard Space Flight Center €œI€ve been looking for a course like this for years! Matt was very knowledgeable and personable and walked his talk€, James McDonald, Crown Solutions €œGreat detail€¦ informative and responsive to questions. Offered lots of useful info to use beyond the class€, Sheleen Spencer, Naval Research Laboratory