top header
top gradation HOME top vertical line top vertical line top vertical line top vertical line top vertical line top vertical line top vertical line menu gray
black line 2
menu gray tab More About ATI
menu blue ATI — Who We Are
white line
menu blue Contact ATI Courses
white line
menu blue List Of ATI Courses
white line
menu blue Attendees Testimonials
white line
menu blue The ATI FAQ Sheet
white line
menu blue Suggestions/Wait List
white line
menu blue New Courses
white line
menu blue Become an ATI Instructor
menu gray tab site resources
menu blue Acoustics & Sonar
white line
menu blue Rockets & Space
white line
menu blue GPS Technology
white line
menu blue ATI Blog
white line
menu blue ATI Space News
white line
menu blue ATI Site Map
white line
menu blue ATI Staff Tutorials
white line
menu blue ATI Sampler Page
white line
menu gray tab bar
menu gray tab courses
white line
menu blue Current Schedule
white line
menu blue Onsite Courses
white line
menu blue Register Online
white line
menu blue Request Brochure
white line
menu blue Free On-Site Price Quote
white line
menu blue Download Catalog
white line
menu blue Distance Learning
black line  

ATI's Spreadsheet Aided Engineering course
with Visual Basic and Engineering xlToolboxes

Share |


    Technical Training Short On Site Course Quote

      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.



      Matthew E. Moran, PE is a Senior Engineer at NASA, and an instructor in the graduate school at Walsh University. He has 27 years experience developing products and systems for aerospace, electronics, military, and power generation applications. He has created Excel/VBA thermal & fluid system models for the Air Force, Office of Naval Research, Missile Defense Agency, NASA, and other organizations. Matt is Professional Engineer (Ohio), with a B.S. & graduate work in Mechanical Engineering, and an MBA in Systems Management. He has published 37 papers, and has 2 patents and 3 patents pending, in the areas of thermal systems, cryogenics, MEMS/microsystems, power generation systems, and electronics cooling.

      Contact this instructor (please mention course name in the subject line)

    What you will learn:
    • Create engineering information tables
    • Develop re-useable functional models
    • Monitor the impact of key variables
    • Monitor performance functions
    • Deal with implicit functions
    • Develop and use VBA Add-Ins
    • Use XLToolboxes to support modeling
    • Solve systems of rules
    • Dynamic system simulation
    • Do system optimization using Solver
    • Monitor System Requirements
    • Setup system sensitivity maps
    • Do system optimization
    • Develop graphic user
    • Setup system modeling teams
    • Control Fortran modules from VBA
    • Control MATLAB models in Excel
    Course Outline:
    1. Overview of ExcelTM Environment: The central role of VBA in Excel & Office, The Excel VBA application object library, Excel menus and toolbar objects, Setting application level preferences, Excel internal function library, Inverting functions- Goal Seeker, Iteration and circular references, Linked worksheets and workbooks, Excel Add-Ins - Solver & Analysis Toolpaks, Forms for simple worksheet user interface, Using the VBA Recorder, XLManager and XLToolboxes
    2. Structured Spreadsheets & Documentation: Structured worksheet layout and design, nput-output field structures, Input design parameter field structure, Defined names for input arrays, Output field structures, VBA user defined functions (UDF), Time varying output fields
    3. Visual Basic for Applications (VBA): The computational side of VBA, Visual Basic Editor, VBA projects and modules, VBA user defined function procedures, VBA sub procedures, Declaration statements, Debugging VBA code, Data types and naming conventions, Function design for worksheet topology, Naming Excel objects & VBA variables ,Vectors, matrices and arrays, VBA logic and control structures
    4. Building VBA Function Libraries: Exporting VBA modules to BAS library, Building Excel Add-Ins, Using Add-Ins in Excel, Referencing Add-Ins in VBA, Documentation support .
    5. Object Oriented Programming in Excel: VBA Object Browser, Object libraries & Excel's object library, Excel object properties & methods, Object collections, Properties that return objects, Range object properties and methods, Object events & VBA event code, Drawing objects with VBA, Animation using VBA
    6. Userforms & ActiveX for Project Control: User interface: an overview, Userform driven design, Creating user interfaces, How to design Userforms as GUIs , Designing Userforms with graphics
    7. Solving System Rules & Optimization: Formulating system rules, Objective functions, Constraint functions, Design & decision variables, Structured optimization sheets, Using solver for solving rules, Configuration trade-off studies
    8. Charting and Chart Automation: Charting VBA object structure, XLQwikplot & XLProplot, Using VBA for chart automation,
    9. Data Storage, Retrieval & Analysis: Importing data into Excel worksheets, Importing data into VBA, Enumeration and lookup functions, Filtering and smoothing data, Interpolation and extrapolation, Linear regression, Linear surface regression, non-linear regression.
    10. Numerical Methods for System Modeling: Application of XLNumerical Toolbox ,Roots of nonlinear functions, Linear & nonlinear algebraic systems, Numerical integration & differentiation, System sensitivity maps
    11. Dynamic System Simulation: Application of XLSimulation Toolbox, State variable system modeling, State forecasting methods
    12. Interfacing VBA, FORTRAN & C: Dynamic Link Libraries (DLLs), Computationally intensive analysis, Converting existing code to DLLs, Interfacing VBA and DLLs, Creating FORTRAN DLLs
    13. Automation of Applications Using VBA: Key automation properties & methods, Controlling MATLAB, Controlling Word, PowerPoint, etc.
    14. Developing On-Line Documentation: HTML help system, Elements of documentation, Linking help to VBA functions
      Free Membership: Attendees receive 5-year free SpreadsheetWorld Membership which includes all SpreadsheetWorld developed engineering XLToolboxes for 5 years including xlQwikplot, xlNumerical Methods, xlSimulation, xlThermal Fluids, xlHeat Transfer and many more.


      Tuition for this five-day course is $2495 per person at one of our scheduled public courses. Onsite pricing is available. Please call us at 410-956-8805 or send an email to