|
Workshop Details
Type: Business
Professionals
Platform: Windows
Versions: 97-2007
Training: Hands-On
Workshop Manual:
Price and Buy
Public Training:
Dates and Signup
Hotel: Thousand Oaks
Inn
Onsite Training:
Details
Web Cast Information: 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 beginning Microsoft
Excel VBA 2-day "hands-on"
business workshop, you will learn:
-
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 use Excel VBA to perform calculations
on data
- How to create summary sheets
using VBA
- How to create basic
dash boards in Microsoft Excel using 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
The Benefits
of Using Microsoft Excel VBA in Business
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, automating worksheet
construction, business model calculations, creating charts, the list is endless.
Workshop Outline (Every part
of our workshop is hands-on)
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
- Overview of the VBA language
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 create charts using
VBA
Day 2
- How to analyze data on multi
worksheets and build summary sheets
- 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
Who Should Attend
- Business
professionals with a solid understanding of how Microsoft Excel
works.
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 |
 |
|
Beginning 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. |
|
|