805.498.7162       805.728.5681
EMAGENIT Logo

Beginning Excel VBA (Visual Basic) Engineers / Beginning Excel VBA (Visual Basic) Scientists

Business, Engineering and Science

Workshop Details

Type: Engineers and Scientists

Platform: Windows

Versions: 97-2007

Workshop Manual: Price and Buy

Public Training: Dates and Signup

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

Hotel: Thousand Oaks Inn

Onsite Training: Details

Web Cast Information: Details, Signup


What is Included in the Workshop

  • Our Excel Aided Engineering manual containing over 1600 pages of Excel and VBA instruction and hundreds of examples

  • If signup for the webcast, on-site or public holding of the workshop, you can retake the public offering of the workshop as many times as you wish, no date or repeat limit

*Detailed outline below


Workshop and Manual Overview

In this 2-day "hands-on"  Microsoft Excel VBA (Visual Basic) workshop, you will learn:

  • 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

The Benefits of Using Microsoft Excel VBA in Engineering and Science

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.

Workshop Outline

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.

Who Should Attend

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

EMAGENIT's Public Training Location

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

Hotel: Thousand Oaks Inn

EMAGENIT is based in Thousand Oaks, California 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 on-site Microsoft Excel VBA courses nation wide. Our public workshops are a short commute for those living in the San Fernando Valley, Santa Clarita, Newbury Park, Camarillo, Calabasas, Sherman Oaks, Reseda, Woodland Hills, Hollywood, Fillmore, Ventura, Moorpark, Simi Valley, Santa Monica and Oxnard areas. For more information about our public workshops, visit our public workshops page our call us at the number above.

EMAGENIT Webcast Workshops
Webcast training for Microsoft Excel VBA and Microsoft Excel

Beginning VBA for Engineering is being offered over the web via live webcast (Details, Signup). Our web cast workshops are:

  • Hands-on

  • Voice interactive

  • We use GoToMeeting, SKYPE and conference calling for customer integration. We can reach anywhere in the world that has an internet connection.

  • Our class sizes are limited to 10 attendees so you can discuss your particular problems.

We also provide on-site training using our web cast system. To learn more about our webcast workshops click here or call us at 805.498.7162.

 
EMAGENIT NASA Award

EMAGENIT received an award for its involvement with NASA JPL in helping redesign and integrate their conceptual Rover mission software in Microsoft Excel. Click the picture above for more detail about our Rover involvement. To learn more about the NASA mission to mars click here.

Awards & Customers
 
 
Call Us
Call EMAGENIT between the hours of 8:00 A.M. and 5 P.M. PST at 1.805.498.7162 or 805.728.5681 for more information about this workshop.
 
Email Us
Submit a question to us via email at begvba@emagenit.com
 

Information Request Form

First Name:
Last Name:
Company:
Zip Code:
Country:
Work Number:
Ext:
e-mail
Information type:
Send me on-site information and pricing
Send your latest public workshop schedule and pricing
Contact me directly via the phone number provided
Keep me informed about EMAGENIT workshops and products
Privacy Policy

 

Request information about our training, products or software design Read about our public training schedule, location and pricing Read about our web cast training schedule and pricing Read about our onsite training workshops Read about our self study manuals and pricing Read about our unique software design services for Windows and Excel Visit our product store for our latest software and manuals Download Excel VBA code for data processing, dashboards, automated charting...

 

 

 



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-2008 EMAGENIT All Rights Reserved