|
Click here to return to our Excel
Aided Engineering home page.
Training Module Overview
- The following training
modules are offered for on-site or public instruction.
- All modules are
offered at public offerings of E.A.E.
- For on-site training,
modules may be mixed and matched.
For more information, please contact us at
1.805.498.7162 or 805.728.5681 or email us at
eae@emagenit.com.
Workshop Outline
Module #1: Excel Basics
for Engineers and Scientists
-
Introduction to Microsoft Excel, VBA, DLL’s and graphical user interfaces
- Excel program interface
review including how to use Excel on-line help
-
Workbook file command and control
Module #2: Excel and the
Engineering/Science Professional
-
Discusses how Excel can be used in the engineering and scientific process in
the areas of analysis, modeling, FORTRAN, C and VB integration, wizard
development, rapid design and analysis environments and team integration
Module #3: Engineering
Methodologies and Analysis on the Worksheet
-
Worksheet/cell command and control fundamentals
-
Engineering and scientific formula construction and editing techniques on the
worksheet
- How to name cells and
ranges and use them in engineering and scientific formulas
- How to design input and
output ranges on the worksheet
- How to use lookup, logical, reference and
database functions to create "smart" engineering and scientific worksheets
- How to
perform matrix algebra, dynamic system simulation, boundary value problem,
integration, differentiation and complex number solution techniques on the
worksheet
- How to use the conditional formatting and
data validation features in Excel to create interactive engineering and
scientific applications on the worksheet
- How to track engineering and scientific data
using the conditional formatting feature
- How to protect worksheets and workbooks
- How to create engineering and scientific
forms on the worksheet
- How to design data and
management task tracking applications in Excel using the conditional
formatting feature
- Single workbook
system model construction techniques
Module #4: Creating
Engineering and Scientific Charts and Reports in Excel
-
Engineering and scientific chart construction using Chart Wizard
-
Engineering and scientific chart editing and formatting techniques
-
Engineering and scientific curve fitting in Excel
- Data visualization in
Excel
-
Engineering and scientific carpet plot creation
-
Engineering and scientific report generation strategies in Excel
Module #5: VBA Editor
and Module Basics for Engineers and Scientists
-
Overview of how VBA can help the engineering and scientific process
- VBA editor overview
including VBA project, module and procedure overview
-
Controlling and typing in VBA modules
-
Referencing and integrating VBA projects
- Using the VBA debugger to
debug your code
Module #6: VBA Language Basics for Engineers
and Scientists
- VBA variables, constants and arrays
(declaring, scope and data typing)
- VBA operators (logical, arithmetic and
comparison)
- Control structures (loops and logic
decisions)
- Overview of Excel objects, properties and
methods
- How to identify and command Excel objects
using VBA
- How to use Excel/VBA on-line help
- How to use the VBA macro recorder to record
Excel tasks in VBA
- How to use the Object Browser
- How to error proof your VBA code
Module #7: Function
Procedure Design for Engineers and Scientists
-
Benefits of using Function procedures and User Defined Worksheet Functions (UDF's)
for engineering and scientific tasks
-
Function procedure and UDF differences
- How to declare Function
procedures and UDF’s in VBA
- How to create arguments
for Function procedures and UDF’s
- How to call
UDF’s from a worksheet formula
-
Calling Function procedures from other VBA procedures
-
Function procedure and UDF procedure interface design
- How to pass worksheet
ranges as arguments to UDF's
-
Returning scalar and array values from UDF’s to worksheet formulas
- Using VBA and Excel
Worksheet functions in your procedures
Module #8: Sub Procedure
Design for Engineers and Scientists
-
Benefits of using Sub procedures for engineering and scientific tasks
-
Declaring Sub procedures in VBA
-
Creating arguments for Sub procedures
-
Calling Sub procedures from other VBA procedures
-
Executing Sub procedures via the Macro dialog box
-
Executing Sub procedures via shortcut keys
-
Executing Sub procedures via engineering and scientific graphics
-
Executing Sub procedures via events
- Sub procedure interface
design
- Sub procedure design tips
for engineers and scientists
-
Property procedure overview
Module #9: Graphical User Interface Design
for Engineers and Scientists
- Developing engineering and science oriented
GUI's and applications in Excel
- Drawing engineering and science oriented
graphics on the worksheet
- Importing engineering and science oriented
graphics into Excel
- Creating graphics that display engineering
and scientific data on the worksheet
- Assigning VBA Sub procedures to worksheet
based graphics
- Using ActiveX and Form controls to create
engineering and scientific GUI’s on the worksheet
- Creating event procedures for controls placed
on a worksheet
- Controlling key Excel objects with VBA
- Wizard overview for engineers and scientists
- Using userforms to create wizards
- Creating userforms in Excel
- Creating controls and graphics on userforms
- Commanding userforms and controls with VBA
- Wizard design tips
- Creating toolbars and menus to control your
Excel engineering and scientific tools
- Controlling Excel’s toolbar and menu system
with VBA
- Automating engineering and scientific chart
construction with VBA
Module #10: FORTRAN/VBA
Mixed Language Programming
- Why should engineers and
scientists develop FORTRAN DLL’s
- How VBA locates and
communicates with a FORTRAN DLL
-
FORTRAN DLL calling conventions from VBA
- Why use Excel as a
pre/post processor for FORTRAN DLL's
-
FORTRAN DLL design tips (using old FORTRAN code and writing new code)
-
Designing VBA procedures to communicate with FORTRAN DLL's
- How to build a FORTRAN
DLL in Digital Visual FORTRAN
- How to debug a FORTRAN
DLL
- How to manage FORTRAN DLL
files
- Note C and ActiveX DLL
discussion included
- Note module 10 applies to
Excel 97 and
beyond
Module #11: Team Linking
in Excel
-
Integrating teams and information using workbook links
-
Creating/managing linked workbooks on a single computer and network
- Linked workbook
distribution techniques
-
Controlling linked workbooks with VBA
-
Engineering and scientific uses of Excel’s shared workbook feature
-
Construction techniques for shared workbooks
- Shared workbook
operational procedures
Module #12: Packaging
Applications in Excel
-
Storing and distributing Excel based tools in various Excel file types
-
Constructing verified, standardized engineering and scientific tools in Excel
-
Packaging/distributing engineering and scientific tools in workbook files
-
Engineering and scientific uses of Add-Ins and workbook templates
-
Constructing/packaging/distributing engineering and scientific tools in
templates
-
Constructing/packaging/distributing engineering and scientific tools in
Add-Ins
-
Distributing/maintaining Excel engineering and scientific tools on networks
-
Engineering and scientific procedure library design (i.e. rapid prototyping
and analysis)
-
Developing security for Excel based software
Module #13: Processing Engineering and
Scientific Data in Excel
- Creating and managing tables in Excel
- Sorting engineering and scientific data using
the auto filter, sort and data form tools
- Vital worksheet functions for engineering and
scientific information processing
- Importing engineering and scientific data
using the Text Import Wizard
- Integrating engineering and scientific
applications using Automation/Dynamic Data Exchange (DDE)
- Communicating with engineering and scientific
databases via MS Query and ODBC
- Commanding MS Query using DDE and VBA
- Communicating with engineering and scientific
databases using the ODBC functions
- Overview of using DAO to communicate with
engineering and scientific databases
Module 14: VBA / ActiveX DLL Programming
-
Object
and class review
-
Practical uses of objects
-
Object
method and properties overview
-
VB
project overview for ActiveX DLL's
-
How to
create an ActiveX DLL
-
Creating and naming your class modules
-
Designing object properties
-
Designing object methods
-
Designing object enums
-
Designing object hierarchies
-
How to
reference your ActiveX DLL's from a VBA or VB project and distribute them
-
How to
create and run your objects from Visual Basic
-
How to
create and run your objects from VBA via Microsoft Excel
-
How to
package and distribute your Active X DLLs
Module #15: Design
Optimization in Excel Using Solver
- Overview of design optimization
- How to layout an optimization problem in
Excel
- Command and control worksheet overview
- How to drive multiple workbooks using Solver
- How to run VBA and FORTRAN while using Solver
- How to use Solver in Microsoft Excel
Module #16: Constructing
Large System Models in Excel
- How to determine your model equations and how
they interact with each other
- Using Excel’s structure to organize system
teams
- Laying out the system model in Excel
- Library workbook introduction and design
- Single and multi-workbook system model layout
Module #17: Microsoft Excel
Updates
- Important upgrade and how to information for
Excel XP and 2003
Module #18: Windows On-Line
Help Design
- On-line help structure and content overview
- How to create the files necessary to create
on-line help
- How to compile a Windows help file
- How to display a Windows help file using VBA
|
|
