Type: Engineers and Scientists

Platform: Windows

Versions: 97-2007

Workshop Manual: Price and Buy

Public Training: Review Our Workshops

Onsite Training: Details

Web Cast Information (New): Review Our Workshops

Workshop and Manual Overview

Microsoft Excel-Aided Engineering is a 1-5 day "hands-on" Microsoft Excel training workshop for engineers and scientists that covers critical Microsoft Excel, VBA, FORTRAN and ActiveX engineering topics. Covered in the workshop are Microsoft Excel engineering topics like:

• Microsoft Excel worksheet fundamentals
• Engineering formula design on the Microsoft Excel worksheet including array and complex numbers operations
• How to use logic and database functions to create "smart" adaptive engineering worksheets
• How to use the conditional formatting and data validation features in Microsoft Excel to monitor system requirements and create project alert displays
• Developing dynamic interlinked system models in Microsoft Excel using single and multi-team workbooks
• Matrix algebra, dynamic system simulation, boundary value problem, integration, differentiation and complex number solution techniques on the Microsoft Excel worksheet
• How to create engineering charts and generate engineering reports in Microsoft Excel
• How to develop carpet plots and perform trade studies using Microsoft Excel
• Complete Microsoft Excel VBA and object oriented programming review for engineers and scientists
• How to use Microsoft Excel VBA to design your own engineering functions for the worksheet and how to distribute them to teams
• How to use ActiveX controls to create engineering GUI's on the Microsoft Excel worksheet
• How to create event driven Microsoft Excel engineering applications using VBA
• How to create and manage engineering databases in Microsoft Excel and link with external databases using Excel's built-in features and VBA
• How to automatically create engineering charts using VBA
• How to integrate design teams in Microsoft Excel over a network
• Using Microsoft Excel for data analysis tasks
• How to access engineering databases from Microsoft Excel
• Engineering design optimization in Microsoft Excel using single and multi-workbook based models
• How to monitor system requirements while performing design optimization
• How to use Microsoft Excel and VBA to control and integrate other engineering programs written in FORTRAN,  C and VB
• How to design rapid prototyping and analysis environments in Microsoft Excel
• How to design engineering wizards using VBA userforms in Excel
• How to provide navigation for your engineering applications in Microsoft Excel
• How to package and provide security for engineering applications in Microsoft Excel (Add-In's, templates and workbooks)
• How to construct verified team tools in Microsoft Excel
• How to construct and use VB ActiveX DLL's with Microsoft Excel
• How to use Microsoft Excel as a command and control center integrating other engineering application data

Click here to view the full workshop outline.

It covers vital Microsoft Excel VBA skills that allow engineers and scientists to exploit the full power of Microsoft Excel.

Microsoft Excel-Aided Engineering Workshop Particulars

Our Excel-Aided Engineering workshop is our next generation modular Microsoft Excel integrated training system consisting of 20 educational modules that cover basic to advanced Microsoft Excel engineering tasks. E.A.E covers Excel 97 and beyond for Windows and Macintosh and can be taught on-site as a 1-5 day modular workshop (your company chooses what it wants) or publicly as a 5-day workshop. E.A.E is taught "hands-on" via SVGA computer projection using integrated Microsoft Excel engineering examples. E.A.E was developed from consulting and training with customers such as:

• NASA

• Solar Turbines

• Verizon

• The US Air Force

• NORTHROP GRUMMAN

• Delphi Steering

• Rand

• Center for Naval Analysis

• Shell Energy

Workshop Materials 

• In its entirety, Excel-Aided Engineering contains over 1800 pages of helpful Excel and Visual Basic for Applications tips, strategies and procedures in a user friendly format.
• It illustrates Excel engineering and Visual Basic for Applications topics using state of the art screen shots and 3-D graphics.
• Each workshop participant receives a comprehensive CD-ROM that contains the workshop examples, supplementary examples and reading materials.

Who Should Attend 

• Excel-Aided Engineering was designed to accommodate the Excel beginner as well as the advanced developer.
• It is intended for all types of engineering professionals. 

EMAGENIT's Public Training Location

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

Hotel: Thousand Oaks Inn

EMAGENIT is based in Thousand Oaks, California which is in the vicinity of Los Angeles county (LA County), Ventura county, Santa Barbara county and San Diego county. We hold all of our on-site Microsoft Excel VBA courses nation wide. Our public workshops are a short commute for those living in the San Fernando Valley, Santa Clarita, Newbury Park, Camarillo, Calabasas, Sherman Oaks, Reseda, Woodland Hills, Hollywood, Fillmore, Ventura, Moorpark, Simi Valley, Santa Monica and Oxnard areas. For more information about our public workshops, visit our public workshops page our call us at the number above.