Workshop Details
Type: Engineers and Scientists
Platform: Windows
Versions: 97-2007
Workshop Manual:
Price and Buy
Public Training:
Dates and Signup
Hotel: Thousand Oaks
Inn
Onsite Training:
Details
Web Cast Information: Details,
Signup
What is Included in the Workshop
-
Our Excel Aided Engineering manual
containing over 1600 pages of Excel and VBA instruction
and hundreds of examples
-
If signup for the webcast, on-site
or public holding of the workshop, you can retake the public
offering of the workshop as many times as you wish, no date or
repeat limit
*Detailed outline below
Workshop and Manual Overview
In this advanced Excel VBA 3-day "hands-on"
workshop, you will learn:
- Advanced data analysis
techniques for engineers and scientists using VBA and Excel
- Advanced Excel VBA programming
techniques for automated chart construction in Microsoft
Excel
- Advanced dashboards using
Excel and VBA for engineers and scientists
- Advanced interface
construction using ActiveX controls and userforms
- Advanced Microsoft Excel VBA programming
techniques for creating event driven
engineering and scientific applications in Microsoft Excel
- Advanced VBA error trap
construction for engineers and scientists
- How to create Excel menu bars
and toolbars
- Advanced Excel VBA programming
tips for communicating with FORTRAN, VB ActiveX DLLs, PERL and C
- System modeling discussion
including how to use Solver with VBA
- Advanced VBA programming
strategies for communicating with engineering and science oriented databases
Advanced Excel
VBA Overview
The capability exists within Microsoft Excel VBA to construct
sophisticated engineering and scientific tools that integrate seamlessly with the Microsoft
Excel environment. Using advanced Microsoft Excel VBA
programming techniques, sophisticated
applications can be constructed in Microsoft Excel that
command, organize and analyze engineering and scientific data, automatically chart engineering and scientific data, generate
reports, talk to other applications integrating their data,
perform engineering and scientific modeling, integrate FORTRAN
routines... the list is endless. Many companies are turning to
constructing engineering and scientific applications in Excel due to the lower
cost, lower development time and because of Excel's exceptional
abilities.
Workshop Outline
Day-1
- Microsoft Excel VBA language overview
for engineers and scientists
- Advanced VBA techniques for
analyzing data on the Microsoft Excel worksheet (parsing, seeking,
importing files)
- Advanced chart generation
techniques using VBA (multi datasheet analysis)
- How to use Microsoft Excel's
drawing tools, ActiveX controls, picture capabilities and charting
abilities to create dashboards on the Microsoft Excel worksheet
- How to use and create event
driven (i.e. action driven) applications in Microsoft Excel
Day-2
- Excel VBA wizard overview
for engineering and science
- Overview of using
userforms to create engineering and scientific wizards
- How to create
userforms in Excel VBA
- How to create
controls and graphics on userforms
- How to command
userforms and their controls with VBA
- Excel VBA wizard design
tips
- How to create toolbars
and menus to control your Excel VBA wizards
- How to control Microsoft
Excel’s toolbar and menu system with Excel VBA
Day-3
- Advanced system modeling
discussion including how to use Solver with VBA
- Mixed language
programming using VBA, FORTRAN, C and VB ActiveX
- How to command
engineering and science oriented databases using VBA (ODBC, DAO and ADO usage)
- How to command
other applications using VBA (Word and PowerPoint)
- Creating
procedure libraries for rapid analysis and design
environments
- How to provide Microsoft
Excel VBA security
using ActiveX technology
- How to package
your Microsoft Excel VBA applications for distribution
Who Should Attend
- Intermediate
Excel VBA
users with a basic knowledge of Microsoft Excel and the VBA language.
- It is
intended for all types of engineering and science 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
Webcast Workshops |
 |
|
Advanced VBA for
Engineering is being offered over the web via live
webcast (Details,
Signup). Our web cast workshops are:
-
Hands-on
-
Voice interactive
-
We use
GoToMeeting,
SKYPE and
conference calling for customer integration. We
can reach anywhere in the world that has an
internet connection.
-
Our class sizes are
limited to 10 attendees so you can discuss your particular
problems.
We also
provide on-site training using our web cast system. To
learn more about our webcast workshops
click here
or call us at 805.498.7162. |
|
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. |
|
|