Microsoft Excel VBA Function Design for Business Professionals 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 to enhance your Excel modeling skills>>>

Call us at:   1.805.498.7162     1.805.558.9277--

Why Create VBA Functions?

Microsoft Excel VBA allows a business professional to make their own custom VBA function or custom worksheet function called User Defined Worksheet Functions or UDF's. The ability to make these functions allows a user to perform complex calculations 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 procedure libraries and distributed. This allows standardized analysis environments to be developed cheaply in Microsoft Excel. These functions can even communicate with databases and other applications like MS Word.

What You Learn at a Glance

This Microsoft Excel VBA workshop for business professionals 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 Worksheet Functions or UDF's. Covered are all the essentials for Excel VBA function design including:

• Excel VBA function 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 function

• How to create a custom worksheet function (UDF) that runs from your worksheet formulas

• How to create a custom worksheet function (UDF) that uses worksheet ranges like the Sum worksheet function

• How to create function libraries for mass distribution to your clients and work associates

• How to use Excel VBA functions to construct models

Workshop Training Options and Self-Study Pricing

Our Beginning Excel VBA workshop also covers the information presented in this workshop. For more information, consult the hyperlinks below.

*EMAGENIT contact and information request form at the bottom of this page. Our phone numbers are at the top of the page if you have any questions.

Workshop and Self-Study Manual Content

In this 2-day "hands-on" business workshop or self-study manual, you will learn:

Day-1

• Benefits of using Excel VBA functions and UDF's for business tasks

• 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 the worksheet and VBA functions to create business models

• Packaging and distributing VBA functions in Microsoft Excel workbook files

• Overview of Add-Ins

• Constructing/packaging/distributing function libraries via Microsoft Excel Add-Ins

Intended Audience

• Microsoft Excel VBA users with a basic knowledge of Microsoft Excel and the VBA language.

• It is intended for all types of business professionals.

EMAGENIT's Training Location

Public Location: Thousand Oaks, CA

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:

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