Microsoft Excel VBA Essentials Training for Business Professionals Workshop Outline

Our "data processing essentials" Microsoft Excel VBA workshop for business that shows you the basics of using VBA to streamline troublesome Excel tasks, process and reconcile business data and create charts all in one day. Read below and see how our 12+ years of Excel training can help supercharge your Excel 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

Newsletter Contact Us Training Help

Excel VBA Essentials Training Focus

Microsoft Visual Basic for Applications (VBA, macros) can be used in conjunction with Microsoft Excel to automate common everyday Excel tasks and to construct automated data processing tools. VBA, a general purpose programming language, comes standard with Excel or Office. This workshop covers the fundamentals of using VBA programming and as well as how to apply it to common Excel and data processing tasks.

What You Learn at a Glance

  • What is VBA?

  • How to use the Visual Basic (VBA) Editor and its debugging tools

  • Excel macro language review (Subs, Functions, variables, arrays, loops, logic...etc)

  • How to command Microsoft Excel using VBA

  • How to use Microsoft Excel VBA to analyze and reconcile data on worksheets

  • How to use Excel visual basic (VBA) to perform calculations on data

  • How to create summary sheets using VBA

  • How to create charts using VBA

  • How to use the Visual Basic Macro Recorder and interpret its recordings

Workshop Details

  • 1-day workshop

  • Personal examples: Covered in-class

  • Excel Versions: 2000-2007

  • Type: Business Professionals

  • Platform: Windows

  • Training Materials: Included, 1600+ page manual including our Excel Add-Ins

  • Training Method: Hands-on

Workshop Outline and Self-Study Manual Content

In this introduction to Excel macros 1-day "hands-on" business workshop or self-study manual, you will learn:

Day 1

  • Overview of how Microsoft Visual Basic (VBA) and Excel are used in business problems

  • VBA Editor review including using the VBA debugger and the purposes of VBA projects, modules and procedures

  • Review of the VBA macro language including variables, data types, constants, arrays, operators, expressions, loops, logic decisions and calling

  • How to use Excel worksheet functions in your macros to speed them up and increase their power

  • Overview of commanding Excel and its parts using VBA including a discussion of objects, properties and methods

  • How to reconcile business data on single and multiple Excel worksheets using loops and logic

  • How to create charts using VBA

Intended Audience

  • Business professionals with a solid understanding of how Microsoft Excel works.

Training Options, Signup and Self-Study

   

  • West coast dates, times and prices on Signup page. Use the Signup buttons above to view.

  • For a complete outline, consult the Workshop Outline section below. Read about EMAGENIT and our Customers.

  • Our webcast workshops are taught live with voice, hands-on and broadcast directly to your computer from our facility (details). We can reach anywhere that has internet broadband.

EMAGENIT's Training Location

Public Location: Thousand Oaks, CA

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 courses nation wide. Our public workshops are a short commute for those living in the Santa Barbara, 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.

Information Request

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

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
EMAGENIT NASA Award for Excel

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
 

Typical Workshop Examples

Basic Programming Skills Using VBA and Excel

Data Processing in Excel Using VBA (Reconciling Data)

How to Create Charts Using VBA

How to Create Summary Workbooks Analyzing Multi- Worksheets and Workbooks

 

 

 

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