Advanced Excel VBA Engineers / Advanced Excel VBA Scientists Workshop Outline

• Onsite, Self-Study, Public, Webinar

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 and PERL

• System modeling discussion including how to use Solver with VBA

• How to integrate ActiveX controls and VBA with existing system models that are formula based

• Advanced VBA programming strategies for communicating with engineering and science oriented databases

• 3-day workshop

• Personal examples: Covered in-class

• Excel Versions: 2000-2010

• Type: Engineering or Science Professionals

• Platform: Windows

• Training Materials: Included, 1800+ page manual including our Excel Add-Ins

• Training Method: Hands-on

In this 3-day "hands-on" workshop you will learn:

Day-1

• Microsoft Excel VBA language overview for engineers and scientists

• Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA

• How to read text files using VBA

• Advanced VBA data entry, data processing and data summation techniques for multi worksheet and multi workbook problems

• Advanced techniques to reconcile data in Excel using Excel VBA

• Advanced VBA programming techniques for creating multiple charts from multiple data sheets

• How to control drawing shapes, ActiveX controls and Excel's coordinate system with VBA (Worksheet Form Construction)

• How to create VBA events for 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

• Advanced system model construction and interface integration with VBA and ActiveX controls

 Day-3

• Mixed language programming using VBA, FORTRAN, and VB ActiveX

• Advanced command of Microsoft Word and PowerPoint using Excel VBA (report generation tools)

• Large scale system modeling discussion

• How to command databases using DAO, ADO and OLE DB in VBA

• Introduction to using ADO OLE DB to query workbooks and text files

• Creating procedure libraries for rapid analysis and design environments

• How to provide Microsoft Excel VBA security using ActiveX technology

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

Public Location: Thousand Oaks,CA, Directions/Thousand Oaks Info

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.

Training Schedule, Enrollment, Self-Study

1

Public Signup	Webinar Signup	Self-Study
Schedule, Pricing, Enroll	Schedule, Pricing, Enroll	Self-Study Manual

• Training manual (1800+ pages) included with workshop

• Repeat the workshop as many times a you like. Click here for details

• Our webinar (webcast) is broadcast live exactly when the workshop is being taught. You can talk directly to the teacher and see the teacher's computer screen. It is hands-on instruction

• Read about EMAGENIT and our Customers

Advanced Multi Chart Construction, Microsoft PowerPoint Control and Microsoft Word Control Using VBA

Advanced Summary Workbook Construction, Data Processing and Windows Folder/File Access Using VBA

Advanced VBA Techniques for Downloading Data from the Web and Databases

Advanced System Model Construction Techniques and  Interface Integration Using ActiveX Controls, VBA, Pictures

Advanced Worksheet Form Construction Using ActiveX Controls, Worksheets, Charts and Shapes

Advanced Dashboard Construction Using Userforms, Shapes, Worksheets and ActiveX Controls