Microsoft Excel VBA Function Design for Engineers and Scientists Workshop Outline

Our "custom worksheet function"  Excel VBA workshop covers how to design custom worksheet functions using VBA that can do hundreds of calculations or sophisticated numerical routines and return the result to a single cell. 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 VBA covers the same basic material in a less focused format. Click here for engineering and science.

Why Create VBA Functions?

Microsoft Excel VBA allows an engineer or scientist to make their own custom VBA functions or custom worksheet function called User Defined Functions or UDF's. The ability to make these functions allows a user to perform complex calculations or run numerical analysis routines in a single worksheet cell. These functions can be used over and over again not only in VBA but also on the worksheet avoiding the dreaded mega formula and mistyping of formulas. VBA functions can also be packaged into libraries and distributed. This allows standardized rapid analysis environments to be developed cheaply in Microsoft Excel. These functions can even communicate with databases, other computer languages and other applications like MS Word.

What You Learn at a Glance

This Microsoft Excel VBA workshop for engineers and scientists shows how to develop VBA functions for use in Excel VBA and on the Excel worksheet. When VBA functions are designed to be used on the worksheet they are called User Defined Functions or UDF's. Covered are all the essentials for Excel VBA function design including:

  • What is VBA?
  • Excel VBA functions syntax
  • Excel VBA function argument design
  • How to return multiple values (arrays) from VBA functions
  • How to use Microsoft Excel's built-in worksheet functions in your VBA functions
  • How to create a custom worksheet function (UDF) that runs from your worksheet formulas
  • How to create a custom worksheet function (User Defined Function) that uses worksheet ranges like the Sum, VLookup, CountIF worksheet function
  • How to create function libraries for a rapid analysis environment
  • How to use Excel VBA functions to construct engineering and scientific system models
Workshop Details
  • 2-day workshop

  • Personal examples: Covered in-class

  • Excel Versions: 2000-2010

  • Type: Engineering and 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

  • Benefits of using Excel VBA functions and UDF's for engineering and science
  • How to use the VBA function statement in your code
  • How to create an argument list for a VBA function
  • General design rules for the inner workings of a VBA function and UDF
  • How to run a UDF from a worksheet formula
  • How to run a VBA function from other VBA procedures
  • How to use Microsoft Excel worksheet ranges in your UDF's
  • How to return single and multiple values from VBA functions
  • How to use VBA and Microsoft Excel Worksheet functions in your VBA functions

Day-2

  • Using numerical analysis in your VBA functions
  • Using the worksheet and VBA functions to create system models
  • Overview of Add-Ins
  • Constructing/packaging/distributing function libraries via Microsoft Excel Add-Ins

Intended Audience
  • Intermediate Excel/VBA users with a good understanding of VBA's core language (variables, loops, logic decisions) and Microsoft Excel.
  • It is intended for all types of engineering and science professionals.
Information Request

Submit a question to us via email at vbaudf@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.

Newsletter Contact Us Training Help
 

 

 

 

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