Advanced Microsoft Excel VBA
Training Focus
|
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.
This workshop discusses the
advanced uses of Excel VBA in the engineering and science
disciplines.
|
What You Learn at a Glance |
-
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
-
3-day workshop
-
Personal
examples: Covered
in-class
-
Excel Versions:
2000-2007
-
Type: Engineering or
Science
Professionals
-
Platform: Windows
-
Training Materials:
Included, 1600+ page manual including our Excel
Add-Ins
-
Training Method: Hands-on
|
Workshop Outline and Self-Study
Manual Content |
In this advanced Excel VBA 3-day "hands-on"
workshop or self-study manual, you will learn:
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
automation
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
|
Training Options, Signup and Self-Study |

|
EMAGENIT's Training Location |
Hotel: Thousand Oaks
Inn
EMAGENIT is based in Thousand Oaks,
CA 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 courses
on-site nation wide.
We also webcast (webinar) our public workshops, consult our
webcast page for more information.
Our public workshops are a short commute for those living in:
-
Los Angeles, CA
-
Palmdale, CA
-
Westwood, CA
-
Santa
Barbara, CA
-
San
Fernando Valley, CA
-
Santa Clarita,
CA
-
Newbury Park, CA
-
Westlake
Village, CA
-
Camarillo, CA
-
Calabasas,
CA
-
Sherman Oaks, CA
|
-
Reseda, CA
-
Woodland Hills,
CA
-
Hollywood, CA
-
Fillmore, CA
-
Ventura, CA
-
Moorpark, CA
-
Simi Valley, CA
-
Santa Monica, CA
-
Oxnard, CA
-
Pasadena, CA
-
Agoura, CA
|
For more information about our public workshops,
visit our public workshops page our call us at
805.498.7162.
Submit a question to us via email at
advvba@emagenit.com
Call EMAGENIT between the hours of 8:00 A.M. and 5 P.M. PST at
1.805.498.7162 or 805.558.9277 for more information about this
workshop.
|
|
EMAGENIT
NASA Award for Excel |
 |
|
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 |
|