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

Newsletter	Contact Us	Training Help

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

• 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-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 2-day "hands-on"  Microsoft Excel VBA (Visual Basic) workshop or self-study manual, 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

Day-2

• Automated chart construction using Excel and VBA

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

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

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