Advanced Microsoft Excel VBA Training for Business Professionals Workshop Outline

Our "premier" Microsoft Excel VBA workshop for business that shows you how to construct complex dashboard driven analysis and data integration business tools in Excel. It shows not only how to use Excel for this task but how to use VBA to tie into other programs, databases and computer languages as well. 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

Advanced Excel VBA Training Focus

The capability exists within Microsoft Excel and VBA to construct complex dashboard driven analysis and data processing business tools. These business tools can go far beyond simple macros becoming actual applications. Excel has a vast array of automated features like graphics, ActiveX controls, worksheets, userforms and cell ranges that when combined together allow these dashboard driven programs to be created. When you tie other programs and computer languages to Excel through VBA like Word, PowerPoint, Access, SQL Server, Lotus Notes, C and VB .Net, Excel VBA can tap into these environments obtaining the functionality it does not have. This workshop focuses on using all of these elements to construct sophisticated data processing and analysis programs in Microsoft Excel.

What You Learn at a Glance
  • What is VBA?

  • An advanced review of the Excel VBA language

  • Advanced VBA data processing techniques for multi worksheets and multi workbooks

  • Advanced summary worksheet construction in Excel using Excel VBA

  • Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA

  • How to read text files using VBA.

  • Advanced VBA programming techniques for creating multiple charts from multiple data sheets

  • How to create advanced business user interfaces on worksheets using ActiveX controls, VBA and graphics

  • Advanced excel dashboard construction

  • How to create and use userforms in VBA (wizards)

  • How to create event driven programs using VBA

  • Advanced VBA error protection techniques

  • How to create custom toolbars and menus to run your VBA code

  • How to communicate with databases using DAO and ADO in VBA and how to download data from the web using VBA

  • Advanced VBA techniques for communicating with other languages and programs

 

Workshop Details
  • 3-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 3-day "hands-on" workshop you will learn:

Day-1

  • Microsoft Excel VBA language overview

  • Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA

  • How to read text files using VBA.

  • Advanced VBA data entry, data processing and data summation techniques for multi worksheet and multi workbook problems

  • Advanced techniques to reconcile data in Excel using Excel VBA

  • Advanced VBA programming techniques for creating multiple charts from multiple data sheets

  • How to control drawing shapes, ActiveX controls and Excel's coordinate system with VBA (Worksheet Form Construction)

  • How to create VBA events for action driven applications in Microsoft Excel

Day-2

  • How to develop business user interfaces on the worksheet using ActiveX controls and Excel VBA

  • VBA wizard overview

  • Overview of using userforms to create business wizards

  • How to create userforms in VBA

  • How to create controls and graphics on userforms

  • How to command userforms and their ActiveX controls with VBA

  • Excel VBA wizard design tips

  • How to create toolbars and menus to control your VBA wizards

  • How to control Excel’s toolbar and menu system with VBA

 Day-3

  • How to use graphics, userforms, drawing shapes, ActiveX controls and Excel VBA to create advanced dashboards in Excel

  • Advanced command of Microsoft Word and PowerPoint using Excel VBA (report generation tools)

  • How to command databases using DAO, ADO and OLE DB in VBA

  • Introduction to using ADO OLE DB to query workbooks and text files

  • How to distribute your Excel programs

  • How to control other languages like Perl and C

Intended Audience
  • Microsoft Excel VBA users with a good knowledge of Microsoft Excel and basic understanding of the VBA language.

  • It is intended for all types of business professionals.

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

Advanced Summary Workbook Construction, Data Processing and Windows Folder/File Access Using VBA

 

Advanced Multi Chart Construction, Microsoft PowerPoint Control and Microsoft Word Control Using VBA

 

Advanced VBA Techniques for Downloading Data from the Web and Databases

Advanced Worksheet Form Construction Using ActiveX Controls, Worksheets and Shapes

 

Advanced Dashboard Construction Using Userforms, Shapes, Worksheets and ActiveX Controls

 

 

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