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.