805.498.7162       805.728.5681
EMAGENIT Logo

Advanced Microsoft Excel VBA for Business Professionals

Business, Engineering and Science

Workshop Details

Type: Business Professionals

Platform: Windows

Versions: 97-2007

Training: Hands-On

Workshop Manual: Price and Buy

Public Training: Dates and Signup

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

Hotel: Thousand Oaks Inn

Onsite Training: Details

Web Cast Information (New): Details, Signup

*We review personal problems in our workshops.


What is Included in the Workshop

  • Our Excel Aided Business manual containing over 1600 pages of Excel and VBA instruction and hundreds of examples

  • If signup for the webcast, on-site or public holding of the workshop, you can retake the public offering of the workshop as many times as you wish, no date or repeat limit

*Detailed outline below


Workshop and Manual Overview

In this advanced Microsoft Excel VBA  3-day "hands-on" business workshop, you will learn:

  • 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
  • How to scan Windows filing system for workbook files and automatically open them
  • 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 dash board 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
  • Advanced VBA techniques for communicating with other languages and programs

Advanced Microsoft Excel VBA Introduction

The capability exists within Microsoft Excel VBA to construct sophisticated business tools that integrate seamlessly with the Microsoft Excel environment. Using advanced Microsoft Excel VBA programming techniques, sophisticated applications can be constructed in Microsoft Excel that:

  • Command, organize and analyze business data on worksheets
  • Automatically chart business data
  • Automatically generate reports in Microsoft Word and PowerPoint
  • Talk to other applications
  • Use dashboards to display data

Many companies are turning to constructing business applications in Excel due to the lower cost, lower development time and because of Excel's exceptional abilities.


Workshop Outline (Every part of our workshop is hands-on)

Day-1

  • Microsoft Excel VBA language overview
  • How to scan folders in Windows for workbooks and open them using VBA
  • How to read text files using VBA.
  • Advanced VBA data processing techniques for multi worksheet and multi workbook problems
  • Advanced summary worksheet construction 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
  • How to use and create event driven (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 and ADO in VBA
  • How to distribute your Excel programs
  • How to control other languages like Perl and C

 

Who Should Attend 

  • 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 Public Training Location

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

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.

EMAGENIT Webcast Workshops
Webcast training for Microsoft Excel VBA and Microsoft Excel

Advanced VBA for Business is being offered over the web via live webcast (Details, Signup). Our web cast workshops are:

  • Hands-on

  • Voice interactive

  • We use GoToMeeting, SKYPE and conference calling for customer integration. We can reach anywhere in the world that has an internet connection.

  • Our class sizes are limited to 10 attendees so you can discuss your particular problems.

We also provide on-site training using our web cast system. To learn more about our webcast workshops click here or call us at 805.498.7162.

 
EMAGENIT NASA Award

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
 
 
Call Us
Call EMAGENIT between the hours of 8:00 A.M. and 5 P.M. PST at 1.805.498.7162 or 805.728.5681 for more information about this workshop.
 
Email Us
Submit a question to us via email at advancedvba@emagenit.com
 

Information Request Form

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

 

Request information about our training, products or software design Read about our public training schedule, location and pricing Read about our web cast training schedule and pricing Read about our onsite training workshops Read about our self study manuals and pricing Read about our unique software design services for Windows and Excel Visit our product store for our latest software and manuals Download Excel VBA code for data processing, dashboards, automated charting...

 

 

 

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