Beginning Microsoft Excel VBA Training for Business Professionals Workshop Outline

Our "workhorse" Microsoft Excel VBA workshop for business that shows you the basics of using VBA to command Excel, process and reconcile data, create charts, build dashboards, command Word and PowerPoint, manage models and more. 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 Excel VBA Training Focus

Microsoft Visual Basic for Applications (VBA, macros) can be used in conjunction with Microsoft Excel to construct automated business tools. VBA, a general purpose programming language, comes standard with Excel or Office. Using Microsoft Visual Basic with Excel, powerful business analysis tools can be developed quickly and with minimum cost. VBA can be used for business tasks like report generation, creating dashboards, communicating with business databases, analyzing business data, reconciling data, automating worksheet construction, business model calculations, creating charts, the list is endless. This workshop covers the fundamentals of using VBA programming and as well as how to apply it in real world situations.

What You Learn at a Glance
  • What is VBA?

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

  • Complete review of the VBA language (Subs, Functions, variables, arrays, loops, logic...etc)

  • How to command Microsoft Excel using VBA. Also discussed is how control Word and PowerPoint

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

  • How to open and close workbooks and text files

  • How to use Excel VBA to perform calculations on data

  • How to create summary sheets using VBA

  • How to create basic dashboards in Microsoft Excel using VBA

  • How to use Excel VBA to fill in Excel forms on the worksheet from text file data and workbook data

  • How to manage Excel models, strategy and layout using Excel and VBA

  • How to create and format single and multiple charts using VBA

  • Using VBA to create report generation tools in Microsoft Word and Microsoft PowerPoint using Excel VBA

  • How to use Excel VBA to build your own custom worksheet functions

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

  • How to download data from the web using VBA

  • How to automate the data analysis tool pack add-in using VBA

Workshop Details
  • 2-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

In this  2-day "hands-on" workshop 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

  • Excel macro language review (VBA) including variables, data types, constants, arrays, operators, expressions, loops, logic decisions and calling

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

  • How to analyze business data on single Excel worksheets using loops and logic.

  • How to load Excel forms on the worksheet using loops and logic

  • Model management, layout and strategy using Excel and VBA

  • How to create charts using VBA

Day 2

  • How to analyze data on multi worksheets and build summary sheets

  • How to access the Windows file and folder system to open and close workbooks and text files being processed

  • How to protect your code against errors

  • How to use Excel and VBA to create basic dash boards

  • How to create your own custom business worksheet functions in VBA

  • How to create basic report generation tools using Excel VBA, Microsoft Word and PowerPoint

  • How to use the Excel Visual Basic macro recorder to record Excel tasks in VBA and then interpret the code

  • How to download data (stock market report, historical tables...etc) from web pages automatically

  • How to automate the data analysis tool pack add-in like regression analysis using VBA

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

EMAGENIT's Training Location (Public Workshops)

Public Location: Thousand Oaks,CA, Directions/Thousand Oaks Info

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:

  • Los Angeles, CA

  • Palmdale, CA

  • Westwood, CA

  • Santa Barbara, CA

  • San Fernando Valley, CA

  • Santa Clarita, CA

  • Newbury Park, CA

  • Westlake Village, CA

  • Camarillo, CA

  • Calabasas, CA

  • Sherman Oaks, CA

  • Reseda, CA

  • Woodland Hills, CA

  • Hollywood, CA

  • Fillmore, CA

  • Ventura, CA

  • Moorpark, CA

  • Simi Valley, CA

  • Santa Monica, CA

  • Oxnard, CA

  • Pasadena, CA

  • Agoura, CA

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

Training Schedule, Enrollment, Self-Study

1
Public Signup Webinar Signup Self-Study

Schedule, Pricing, Enroll

Schedule, Pricing, Enroll

Self-Study Manual

  • Training manual (1800+ pages) included with workshop

  • Repeat the workshop as many times a you like. Click here for details

  • Our webinar (webcast) is broadcast live exactly when the workshop is being taught. You can talk directly to the teacher and see the teacher's computer screen. It is hands-on instruction

  • Read about EMAGENIT and our Customers

Typical Workshop Examples

Basic Programming Skills Using VBA and Excel

 

Data Processing in Excel Using VBA (Different Worksheet or Workbook Output)

 

Automated Chart Construction Using VBA

 

How to Create Summary Workbooks Analyzing Multi- Worksheets and Workbooks

 

Basic Dashboard Design Using VBA, Worksheets, Shapes, Cell Colors...etc

 

Basic VBA Techniques for Downloading Data from the Web and Databases

How to Command Microsoft PowerPoint and Microsoft Word Using VBA

 

 

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