Excel VBA
Essentials Training
Focus
|
Microsoft Visual Basic for
Applications (VBA, macros) can be used in conjunction with Microsoft Excel to
automate common everyday Excel tasks and to construct automated data
processing tools. VBA, a general purpose programming
language, comes standard with Excel or Office.
This workshop covers the
fundamentals of using VBA programming and as well as how to apply it to
common Excel and data processing tasks.
|
What You Learn at a Glance |
-
What is VBA?
-
How to use the Visual Basic
(VBA) Editor and its debugging tools
-
Excel macro language review (Subs, Functions, variables, arrays, loops,
logic...etc)
-
How to command Microsoft Excel
using VBA
-
How to use Microsoft Excel VBA to analyze
and reconcile data
on worksheets
-
How to use Excel
visual basic (VBA) to perform calculations
on data
-
How to create summary sheets
using VBA
-
How to create charts using VBA
-
How to use the Visual Basic Macro
Recorder and interpret its recordings
-
1-day workshop
-
Personal
examples: Covered
in-class
-
Excel Versions:
2000-2007
-
Type: Business
Professionals
-
Platform: Windows
-
Training Materials:
Included, 1600+ page manual including our Excel
Add-Ins
-
Training Method: Hands-on
|
Workshop Outline and Self-Study
Manual Content |
In this introduction to Excel macros 1-day "hands-on"
business workshop or self-study manual, 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
-
Review of the VBA
macro language including variables, data types, constants, arrays, operators,
expressions, loops, logic decisions and calling
-
How to use Excel worksheet functions in
your macros to speed them up and increase their power
-
Overview of commanding Excel
and its parts using VBA including a discussion of objects, properties and methods
-
How to
reconcile business data on
single and multiple Excel worksheets using loops and logic
-
How to create charts using
VBA
|
Training Options, Signup and Self-Study |

|
EMAGENIT's 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.
Submit a question to us via email at
introvba@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.
|
|
EMAGENIT
NASA Award for Excel |
 |
|
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 |
Typical Workshop
Examples

Basic Programming
Skills Using VBA and Excel

Data Processing in Excel Using VBA (Reconciling Data)

How to Create Charts
Using VBA

How to Create
Summary Workbooks Analyzing Multi- Worksheets
and Workbooks
|