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