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

Our "workhorse" Microsoft Excel VBA workshop for engineering and science that shows you the basics of using VBA to command Excel, process and reconcile data, create charts, create functions, build powerful models, build dashboards and command Word and PowerPoint. Read below and see how our 14 years of Excel training and software design can help supercharge your Excel VBA skills >>>

Call us at:   1.805.498.7162     1.805.558.9277--

Learn about how we can help your company or yourself achieve your Microsoft Excel training or self-study goals Visit our free Microsoft Excel and Microsoft Excel VBA resource center Learn how we can help save your company money with our innovative software solutions Visit out VBA code center for code that can save your company money Learn about our Excel Add-In software that can save your company time and money View our customer list from our 12 years in business Phone numbers, request form and email address Learn about EMAGENIT View our training schedule for Microsoft Excel and Microsoft Excel VBA

NASA Award for Microsoft Excel Design

EMAGENIT received an award from NASA for its software design in Microsoft Excel and VBA for the Mars Rover. We provide training for customers like AMGEN, General Dynamics and Caterpillar. Read below to learn more about our Beginning VBA Training.

 

Workshop Availability

  • Onsite, Self-Study, Public, Webinar

Beginning Microsoft Excel VBA Training Focus

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.

What You Learn at a Glance
  • 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

Workshop Details
  • 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

Workshop Outline

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

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

EMAGENIT's Training Location (Public Workshops)

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:

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

Information Request

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

Typical Workshop Manual Examples

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

 

 

Additional Pages

Microsoft Excel Classes  Microsoft Excel VBA Courses  Microsoft Excel Training  Microsoft Excel Macros  Microsoft Excel VBA Consulting  Microsoft Excel Add-Ins

Copyright © 2002-2011 EMAGENIT All Rights Reserved