Beginning Excel
VBA Training
Focus
|
Microsoft 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, reconciling data, automating worksheet
construction, business model calculations, creating charts, the list is endless.
This workshop covers the
fundamentals of using VBA programming and as well as how to
apply it in real world situations.
|
What You Learn at a Glance |
-
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
dashboards 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
-
How to download data from the web using VBA
-
How to automate the data analysis tool pack add-in using VBA
-
2-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 beginning Excel VBA 2-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
-
Excel macro language review (VBA)
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 access the Windows file and
folder system to open and close workbooks being processed
-
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
-
How to download data (stock market
report, historical tables...etc) from web pages automatically
-
How to automate the data analysis tool
pack add-in like regression analysis using VBA
|
Training Options, Signup and Self-Study |
|
EMAGENIT's Training Location |
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.
Submit a question to us via email at
begvba@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 (Different Worksheet or Workbook
Output)

Automated Chart
Construction Using VBA

How to Create
Summary Workbooks Analyzing Multi- Worksheets
and Workbooks

Basic Dashboard
Design Using VBA, Worksheets, Shapes, Cell
Colors...etc

Basic VBA Techniques for
Downloading Data from the Web and Databases

How to Command Microsoft PowerPoint and
Microsoft Word Using VBA
|