NASA Award for Microsoft Excel Design
|
|
 |
|
EMAGENIT received an award
from
NASA for its
software design in Microsoft Excel and VBA for the Mars Rover. We provide training
for customers like AMGEN, General
Dynamics and Caterpillar. Read below to learn more about our
Beginning VBA Training. |
|
- Onsite, Self-Study,
Public, Webinar
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 open and close workbooks and text files
-
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 use Excel VBA to fill in Excel forms on the worksheet from text
file data and workbook data
-
How to manage Excel models, strategy and layout using Excel and 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-2010
-
Type: Business
Professionals
-
Platform: Windows
-
Training Materials:
Included, 1800+ page manual including our Excel
Add-Ins
-
Training Method: Hands-on
In this 2-day "hands-on"
workshop 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 load Excel forms on the worksheet
using loops and logic
-
Model management, layout and strategy
using Excel and VBA
-
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 and text files 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
|
EMAGENIT's Training Location (Public Workshops) |
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.
|
|
Training Schedule,
Enrollment, Self-Study |
-
Training manual
(1800+ pages) included with workshop
-
Repeat the workshop as many times a
you like.
Click here for details
-
Our
webinar (webcast)
is
broadcast live
exactly when the workshop is being taught. You
can talk directly to the teacher and see the
teacher's computer screen. It is hands-on
instruction
-
Read about
EMAGENIT
and our 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
|
