Beginning Excel VBA for Engineers / Beginning Excel VBA Scientists Workshop Outline

• Onsite, Self-Study, Public, Webinar

Visual Basic for Applications (VBA) can be used in conjunction with Microsoft Excel to construct automated engineering and science tools. VBA, a general purpose programming language, comes standard with Excel or Office. Using VBA with Excel, engineers and scientists can develop analysis tools quickly with minimum cost. VBA can be used for engineering and scientific tasks like analyzing data, automating chart construction, building report generation tools, communicating with databases, constructing dashboards, system models the list is endless. This workshop discusses the basics of using Excel VBA in the engineering and science disciplines.

• How engineers and scientists can use the Microsoft Excel Visual Basic Editor's debugging tools for their purposes

• How to use Visual Basic for Applications (VBA) for engineering and scientific purposes

• How to use the VBA language including variables, loops, logic, arrays, functions...etc

• How to control key Microsoft Excel program elements using VBA (Visual Basic)

• How engineers and scientists cans use VBA to analyze engineering and scientific data on the Microsoft Excel worksheet

• How to construct workbooks for use with VBA when creating large scale models

• Basic dashboards design for engineers and scientists using Excel and VBA

• How engineers and scientists can construct their own worksheet functions (UDF's) using Excel Visual Basic (numerical analysis techniques discussion included)

• How engineers and scientists can automate chart construction using Excel VBA

• How to use the Macro Recorder to record engineering and scientific tasks in Microsoft Excel

• 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 2-day "hands-on" workshop you will learn:

Day-1

• Overview of how VBA is used in engineering and science

• VBA Editor review including VBA debugger, VBA project, module and procedure overview

• Overview of the VBA language including variables, data types, constants, arrays, operators, expressions, loops and logic decisions

• Overview of objects, properties and methods

• How to command key Microsoft Excel elements with VBA that are used in the engineering and science

• Constructing data analysis tools for engineering and science using VBA

• Automated chart construction using Excel and VBA

Day-2

• How to use drawing shapes and ActiveX controls to construct basic dashboards

• How to create your own engineering and scientific worksheet functions in VBA (system modeling and numerical methods discussion)

• How to construct workbooks for use with VBA when creating large scale system models

• How to use the VBA macro recorder to understand commanding Excel with VBA

• How to create data analysis tools that use multiple worksheets

• How to construct report generation tools using Excel VBA, Microsoft Word and Microsoft PowerPoint

• Engineering and science professionals with a solid understanding of how Microsoft Excel works.

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 begvba@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

Basic Programming Skills Using VBA and Excel

Data Processing in Excel Using VBA (Different Worksheet or Workbook Creation)

Automated Chart Construction Using VBA

How to Create Custom Worksheet Functions for Use in Data Analysis and System Modeling

Basic Dashboard Design Using VBA, Worksheets, Shapes, Cell Colors...etc

Basic VBA Techniques for Downloading Data from the Web and Databases Like MS Access

How to Command Microsoft PowerPoint and Microsoft Word Using VBA