Beginning
Microsoft Excel VBA Training - Excel Macros
for Engineers &
Scientists
Duration:
2-day
Included: 1800 + page manual,
"hands-on" training,
free repeats

Beginning Microsoft Excel Macro
Training
Introduction
Our 2-day
"hands-on" Excel VBA training
shows engineers and scientists
the basics of using Excel and VBA to create time saving technical tools. Our training
shows you from an engineering & science perspective how to use
VBA to command Excel, control worksheet cells and ranges, control
worksheets and workbooks, process resizing data on worksheets, fill out
data forms, perform calculations, create
charts, create custom worksheet functions, build powerful models,
build basic dashboards and more.
Complete Outline and Signup
In our Beginning Microsoft Excel VBA training workshop you
will learn:
-
How to use the
Visual Basic Editor, its debugging tools and modules
-
A complete review of the VBA language
including variables, loops, logic, arrays, functions...etc
-
A complete review of how to put together a
program in VBA and use loops and logic to control it
-
How to control Microsoft
Excel objects, properties and methods
-
How to perform calculations in VBA using
worksheet functions, expressions (formulas) and VBA functions
-
How to control workbooks, worksheets and
ranges using VBA including formatting and naming
-
How to use VBA to fill data in forms
-
How to use VBA to analyze engineering and
scientific worksheet data and
automatically adjust to its changing size
-
How to move and reorganize data on the worksheet using VBA
-
How to construct basic dashboards for data
analysis and modeling purposes
-
How to use VBA to manipulate worksheet based
models and their formulas
-
How to construct custom worksheet functions (UDF's) using Excel
VBA (numerical analysis techniques discussion included)
-
How to automate basic Word and PowerPoint
features using Excel VBA for reporting purposes
-
How to automate technical chart
and pivot table construction using VBA
-
How to use the Macro Recorder
to obtain key Excel commands that are used in VBA
-
Basic
control of databases, workbooks and text files using ADO, DAO, SQL and VBA
 |