805.498.7162       805.728.5681
EMAGENIT Logo

Microsoft Excel VBA Function Design for Engineers and Scientists

Business, Engineering and Science

Workshop Details

Type: Engineers and Scientists

Platform: Windows

Versions: 97-2007

Workshop Manual: Price and Buy

Public Training: Review Our Workshops

Onsite Training: Details

Web Cast Information: Review Our Workshops


Workshop and Manual Overview

This Microsoft Excel VBA 2-day "hands-on" 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:

  • 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

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.


Workshop Topics

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

Workshop Materials

  • The workshop manual contains helpful Microsoft Excel VBA programming topics and code in a user-friendly format.
  • The manuals illustrate Microsoft Excel VBA topics using state of the art screen shots and 3-D graphics.
  • Each workshop participant receives a comprehensive CD-ROM that contains the workshop examples and reading materials.

 

Who Should Attend 

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

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 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 vbaudf@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