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

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 business. Click here for engineering and science.

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

  • Type: Business Professionals

  • Platform: Windows

  • Training Materials: Included, 1800+ 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.

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.

Newsletter Contact Us Training Help
 

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