Engineering Systems Modeling With Excel/VBA Training
Engineering Systems Modeling With Excel/VBA Training Course Description
This 3- to 5-day Engineering Systems Modeling With Excel/VBA Training is designed to have an immediate impact on the way that Excel Spreadsheets are used in the engineering process. The course length and topics are customized for onsite presentations to provide the best value based on the customer’s requirements. This workshop is designed to have an immediate impact on the way that Excel Spreadsheets are used in the engineering process. The underlying key to this change is for the user to gain experience and knowledge on the use of Visual Basic for Applications (VBA) in Excel. Extensive use of VBA is the key to unlocking all the features of Excel, and moving away from attempting to program on worksheets. Those who attend this intensive hands-on workshop experience a dramatic change in their use of Excel and VBA. Benefits include increased productivity, automation of tedious tasks, increased use of XLToolboxes and Add-ins, development of re-usable functions, forms and templates, improved documentation and configuration management, and improved team interaction and parameter sharing.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 other course, book, or other resource are revealed. Step-bystep implementation, instructor-led interactive examples, and integrated participant exercises solidify the concepts introduced. Application examples are demonstrated from the instructor’s experience in unmanned underwater vehicles, LEO spacecraft, cryogenic propulsion systems, aerospace & military power systems, avionics thermal management, and other projects.
• Exploit the full power of Excel for building thermal & fluid 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.
With onsite Training, courses can be scheduled on a date that is convenient for you, and because they can be scheduled at your location, you don’t incur travel costs and students won’t be away from home. Onsite classes can also be tailored to meet your needs. You might shorten a 5-day class into a 3-day class, or combine portions of several related courses into a single course, or have the instructor vary the emphasis of topics depending on your staff’s and site’s requirements.
Excel/VBA Review. Excel capabilities. Visual Basic for Applications (VBA). Input/output (I/O) basics. Integrating functions & subroutines.
Identifying Scope & Capabilities. Defining model requirements. Project scope. User inputs. Model outputs.
Quick Prototyping. Creating key functions. Testing I/O & calculations. Confirming overall approach.
Defining Model Structure. Refining model architecture. Identifying input mechanisms. Defining output data & graphics.
Designing Graphical User Interfaces. Using ActiveX controls. Custom user-forms. Creating system diagrams & other graphics. Model navigation.
Building & Tuning the VBA Engine. Programming techniques. VBA integrated development environment. Best practices for performance.
Customizing Output Results. Data tables. Plots. Interactive output.
Exploiting Built-in Excel Functions. Advanced math functions. Data handling.
Integrating External Data. Retrieving online data. Array handling. Curve fitting.
Adding Interdisciplinary Capabilities. Integrating other technical analyses. Financial/cost models.
Unleashing GoalSeek & Solver. Single variable, single target using GoalSeek. Multivariable optimization using Solver.
Incorporating Scenarios. Comparing multiple designs. Tradeoff comparisons. Parameter sensitivities. Quick what-if evaluations.
Documentation, References, & Links. Documenting inputs, methodology, and results. Incorporating references. Adding links to files & online data.
Formatting & Protection. Optimizing formatting for reporting. Protecting algorithms & proprietary data. Distribution tips.
Flexibility, Standardization, & Configuration Control. Building user flexibility and extensibility. Standardizing algorithms. Version & configuration control.
Other Useful Tips & Tricks. Practical hands-on techniques & tips.
Application Topics. Tailored to participant interests.
Whether you are looking for general information or have a specific question, we want to help
Request More Information