Advanced Excel VBA Engineers / Advanced Excel VBA Scientists Workshop Outline

Newsletter	Contact Us	Training Help

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.

• 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

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

• 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.

• West coast dates, times and prices on Signup page. Use the Signup buttons above to view.

• For a complete outline, consult the Workshop Outline section below. Read about EMAGENIT and our Customers.

• Our webcast workshops are taught live with voice, hands-on and broadcast directly to your computer from our facility (details). We can reach anywhere that has internet broadband.

Public Location: Thousand Oaks, CA

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:

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.