Workshop Details
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:
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
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.
|
|
EMAGENIT
NASA Award |
 |
|
EMAGENIT received an award
for its involvement with NASA JPL in helping redesign and integrate their
conceptual Rover mission
software in Microsoft Excel.
Click the picture above for more detail about our Rover
involvement. To learn more about the NASA mission to mars
click here. |
|
Awards & Customers |
|
Call Us |
|
Call EMAGENIT between the hours of 8:00 A.M. and 5 P.M. PST at
1.805.498.7162 or 805.728.5681 for more information about this
workshop. |
|
|