Microsoft Excel and
Microsoft Excel VBA Public and Webcast Workshop Schedule and
Enrollment
|
|
 |
 |
|
In our Microsoft
Excel
Public and Webcast
workshops,
we can train you in Thousand Oaks, CA or over the web
via a live broadcast.
All of our workshops are "hands-on" and we customize the
workshop to the needs of the attendees.
You can find the location, pricing and enrollment
buttons below in each class section>>> |
|
Call us at: 1.805.498.7162
1.805.558.9277--
|
Microsoft Excel
and Microsoft Excel VBA (Macros) Workshop Index
|
Microsoft Excel and Microsoft Excel VBA Public
and Webcast Business Workshops
|
 |
Our "basic"
Microsoft Excel business workshop shows you the fundamentals of
Excel like entering data, formatting, copying and
pasting, basic formula construction, auto summing and
more. It not only teaches you the basics of Microsoft
Excel but the thinking and mechanics of how to apply it
to your everyday problems.
Public enrollment and
schedule below>>>
Questions? Call us at: 1.805.498.7162
1.805.558.9277--
|
Beginning Excel Training
Focus
Our "hands-on" beginning Excel
training shows you the fundamentals of
Excel like entering data, formatting, copying and
pasting, basic formula construction, auto summing and
more. It not only teaches you the basics of Microsoft
Excel but the thinking and mechanics of how to apply it to
your everyday problems. In all of our workshops, we evaluate our
clienteles' knowledge level, their problems
and adjust our curriculum to their specific
needs. For a complete outline, click
the Workshop Outline
button below.
|
Workshop
Details
-
About
EMAGENIT. Our
Customers.
-
Personal
examples: Covered
in-class
-
Excel Versions:
2000-2007
-
Type: Business
Professionals
-
Platform: Windows or Mac
-
Training Materials:
Included, 1600+ page manual including our Excel
Add-Ins
-
Training Method: Hands-on,
interactive
-
Repeat this
workshop for free as many times as you want.
View offer details
|
|
What You Learn at a Glance
-
Basic data entry
-
Number formatting
-
Basic formula construction
-
How to use SUM, Max and
Min
-
Coping and pasting
-
Sorting and filtering
data
-
Basic worksheet
formatting like bolding, aligning, row/column
adjustments
|
Self-Study Manual Purchase
(Manual Included with Workshop)
Our Microsoft
Excel manuals
support business, engineering and science
professionals depending on the version ordered. We design our Excel self study and
Excel Visual Basic self study manuals around real
world problems facing business professionals, engineers
and scientists.
 |
 |
Beginning Microsoft Excel Training for Business
Public Meeting Signup |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
Mar closed |
|
|
Thousand Oaks, CA |
$190.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00 P.M. PST |
|
04/13/10 |
|
|
Thousand Oaks, CA |
$190.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00 P.M. PST |
|
05/03/10 |
|
|
Thousand Oaks, CA |
$190.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00 P.M. PST |
|
06/08/10 |
|
|
Thousand Oaks, CA |
$190.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00 P.M. PST |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162.
Also, military and government
discounts available.
Contact us directly for more
details. |
 |
Our "data
processing and
formulas"
Microsoft Excel business workshop
that shows you how to build power
formulas using VLOOKUP, IF, SUMIF...etc, build pivot tables, process text files,
process and analyze worksheet data, link to Word and
PowerPoint and
more.
Public and
Webcast enrollment and
schedule below>>>
Questions? Call us at: 1.805.498.7162
1.805.558.9277--
|
Intermediate Excel Training
Focus
Our "hands-on"
intermediate Excel training focuses on
useful formula design for data processing
and modeling, using Excel's built-in range
features like Data Validation, useful worksheet functions
like VLookup
and applying Excel's built-in data
processing tools and worksheet functions to
analyze and clean text files and worksheet
tables. We
teach you how to develop analysis and data
processing problems on the worksheet then
how to determine the proper Excel tools to create a
unique solution. In all of our workshops, we evaluate our
clienteles' knowledge level, their problems
and adjust our curriculum to their specific
needs. For a complete outline, click
the Workshop Outline
button below.
 |
Workshop
Details
-
About
EMAGENIT. Our
Customers.
-
Personal
examples: Covered
in-class
-
Excel Versions:
2000-2007
-
Type: Business
Professionals
-
Platform: Windows or Mac
-
Training Materials:
Included, 1600+ page manual including our Excel
Add-Ins
-
Training Method: Hands-on,
interactive
-
Repeat this
workshop for free as many times as you want.
View offer details
|
|
What You Learn at a Glance
-
Filtering
data using Auto Filter and Advanced Filter
-
Working
with text files using Text Wizard and Text to Columns
-
Cleaning and restoring text
in files using the Left, Right, Mid, Substitute, Clean
and Trim worksheet functions
-
Using
Data Validation and Conditional Formatting
-
Perform table lookups using
VLookup and HLookup, Match, Index and Indirect
-
Build summary/pricing
worksheets
-
Build pricing sheets that
can toggle between pricing tables
-
Build array formulas using
VLookup, HLookup, CountIf, Match and SumIf...etc
-
Use logic in formulas
(IF, And, Or)
-
Name cells and ranges
-
Create dynamic ranges in
formulas that adjust to data
-
Link Excel to Word and
PowerPoint for reports
-
Build basic pivot tables
|
Self-Study Manual Purchase
(Manual Included with Workshop)
Our Microsoft
Excel manuals
support business, engineering and science
professionals depending on the version ordered. We design our Excel self study and
Excel Visual Basic self study manuals around real
world problems facing business professionals, engineers
and scientists.
 |
 |
Intermediate
Microsoft Excel Training for Business Public
Meeting Signup
|
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
Mar Closed |
|
|
Thousand Oaks, CA |
$190.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00 P.M. PST |
|
04/14/10 |
|
|
Thousand Oaks, CA |
$190.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00 P.M. PST |
|
05/04/10 |
|
|
Thousand Oaks, CA |
$190.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00 P.M. PST |
|
06/09/10 |
|
|
Thousand Oaks, CA |
$190.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00 P.M. PST |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162.
Also, military and government
discounts available.
Contact us directly for more
details. |
 |
Intermediate
Microsoft Excel Training for Business West Coast Webcast Signup
(PST) |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
| Mar
Webcast closed |
|
|
Webcast Simulcast |
$150.00 |
What is a Webcast? |
8:30 A.M.-4:00 P.M. PST |
|
04/14/10 |
|
|
Webcast Simulcast |
$150.00 |
What is a Webcast? |
8:30 A.M.-4:00 P.M. PST |
|
05/04/10 |
|
|
Webcast Simulcast |
$150.00 |
What is a Webcast? |
8:30 A.M.-4:00 P.M. PST |
|
06/09/10 |
|
|
Webcast Simulcast |
$150.00 |
What is a Webcast? |
8:30 A.M.-4:00 P.M. PST |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162.
Also, military and government
discounts available.
Contact us directly for more
details. |
 |
Our "advanced
solutions"
Microsoft Excel business workshop
that focuses
on creating sophisticated Excel analysis and data
processing tools using advanced formulas, ActiveX
controls, dashboards, database queries, pivot tables,
charts and integrating Excel with Word /
PowerPoint. It also provides an introduction to macros
(VBA). We teach you how to develop these advanced
solutions on the worksheet then how to assemble the
proper Excel tools in ways you have never thought of
before. Public
and webcast enrollment and
schedule below>>>
Questions? Call us at: 1.805.498.7162
1.805.558.9277--
|
Advanced Excel Training Focus
Our "hands-on" advanced Excel
training that focuses on creating sophisticated Excel
analysis and data processing tools using advanced
formulas, ActiveX controls, dashboards, database queries,
pivot tables, charts and integrating Excel with MS Word and
MS PowerPoint. We teach you how to develop these advanced
solutions on the worksheet then how to assemble the proper
Excel tools in ways you have never thought of before. It
also provides an introduction to macros (VBA). In the
workshop, we teach our clients how to develop a complete
Excel strategy for a complex problem. In all of our
workshops, we evaluate our clienteles' knowledge level,
their problems and adjust our curriculum to their specific
needs. For a complete outline, click
the Workshop Outline
button below.
 |
Workshop
Details
-
About EMAGENIT.
Our Customers.
-
Personal
examples: Covered
in-class
-
Excel Versions:
2000-2007
-
Type: Business
Professionals
-
Platform: Windows or Mac
-
Training Materials:
Included, 1600+ page manual including our Excel
Add-Ins
-
Training Method: Hands-on,
interactive
-
Repeat this
workshop for free as many times as you want.
View offer details
|
|
What You Learn at a Glance
-
Building forms using ActiveX
controls
-
Advanced formula construction
-
Building dashboards using array
formulas, charts and drawing shapes
-
Querying databases
-
Advanced data filtering
-
Advance pivot
table construction
-
Linking
Excel with other programs like Word
-
Macro
recording
|
Self-Study Manual Purchase
(Manual Included with Workshop)
Our Microsoft
Excel manuals
support business, engineering and science
professionals depending on the version ordered. We design our Excel self study and
Excel Visual Basic self study manuals around real
world problems facing business professionals, engineers
and scientists.
|
 |
Advanced
Microsoft Excel Training for Business Public
Meeting Signup |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
03/10/10 |
|
|
Thousand
Oaks, CA
|
$190.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00 P.M. PST |
|
04/15/10 |
|
|
Thousand
Oaks, CA
|
$190.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00 P.M. PST |
|
05/05/10 |
|
|
Thousand
Oaks, CA
|
$190.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00 P.M. PST |
|
06/10/10 |
|
|
Thousand
Oaks, CA
|
$190.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00 P.M. PST |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162.
Also, military and government
discounts available.
Contact us directly for more
details. |
 |
Advanced
Microsoft Excel Training for Business West Coast Webcast
Signup (PST) |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
Mar Webcast Closed |
|
|
Webcast Simulcast |
$150.00 |
What is a
Webcast? |
8:30 A.M.-4:00 P.M. PST |
|
04/15/10 |
|
|
Webcast Simulcast |
$150.00 |
What is a
Webcast? |
8:30 A.M.-4:00 P.M. PST |
|
05/05/10 |
|
|
Webcast Simulcast |
$150.00 |
What is a
Webcast? |
8:30 A.M.-4:00 P.M. PST |
|
06/10/10 |
|
|
Webcast Simulcast |
$150.00 |
What is a
Webcast? |
8:30 A.M.-4:00 P.M. PST |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162.
Also, military and government
discounts available.
Contact us directly for more
details. |
|
 |
Our "data
processing essentials"
Microsoft Excel VBA workshop for business
that shows you the basics of using
VBA to
streamline troublesome Excel tasks, process and reconcile
business data and create charts all in one day.
Enrollment and
schedule below>>>
Questions? Call us at: 1.805.498.7162
1.805.558.9277--
|
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. For a complete outline, click
the Workshop Outline
button below.

|
Workshop
Details
-
About
EMAGENIT. Our Customers.
-
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, taught
by an actual software developer
-
Repeat this
workshop for free as many times as you want.
View offer details
|
|
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
streamline tasks in 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
(reconcile data)
using VBA
-
How to create charts using 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
|
Self-Study Manual Purchase
(Manual Included with Workshop)
Our Microsoft
Excel manuals
support business, engineering and science
professionals depending on the version ordered. We design our Excel self study and
Excel Visual Basic self study manuals around real
world problems facing business professionals, engineers
and scientists.
 |
 |
Microsoft Excel VBA
Essentials for Business
Public Meeting Signup
|
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
Mar closed |
|
|
Thousand Oaks, CA
|
$275.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00
P.M. PST |
|
04/16/10 |
|
|
Thousand Oaks, CA
|
$275.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00
P.M. PST |
|
05/06/10 |
|
|
Thousand Oaks, CA
|
$275.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00
P.M. PST |
|
06/11/10 |
|
|
Thousand Oaks, CA
|
$275.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00
P.M. PST |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162.
Also, military and government
discounts available.
Contact us directly for more
details. |
 |
Microsoft Excel VBA
Essentials for Business
West Coast
Webcast Signup (PST) |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
| Mar
closed |
|
|
Webcast Simulcast |
$225.00 |
What is a Webcast? |
8:30 A.M.-4:00
P.M. PST |
| 04/16/10 |
|
|
Webcast Simulcast |
$225.00 |
What is a Webcast? |
8:30 A.M.-4:00
P.M. PST |
| 05/06/10 |
|
|
Webcast Simulcast |
$225.00 |
What is a Webcast? |
8:30 A.M.-4:00
P.M. PST |
| 06/11/10 |
|
|
Webcast Simulcast |
$225.00 |
What is a Webcast? |
8:30 A.M.-4:00
P.M. PST |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162.
Also, military and government
discounts available.
Contact us directly for more
details. |
|
 |
Our "workhorse"
Microsoft Excel VBA workshop for business
that shows you the basics of using
VBA to command Excel, process and reconcile data, create
charts, build basic dashboards, command Word and PowerPoint and more.
Public and
webcast enrollment and
schedule below>>>
Questions? Call us at: 1.805.498.7162
1.805.558.9277--
|
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. For a complete outline, click
the Workshop Outline
button below.

|
Workshop
Details
-
About
EMAGENIT. Our Customers.
-
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, taught
by an actual software developer
-
Repeat this
workshop for free as many times as you want.
View offer details
|
|
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
|
Self-Study Manual Purchase
(Manual Included with Workshop)
Our Microsoft
Excel manuals
support business, engineering and science
professionals depending on the version ordered. We design our Excel self study and
Excel Visual Basic self study manuals around real
world problems facing business professionals, engineers
and scientists.
 |
 |
Beginning Microsoft Excel VBA Training for Business
Public Meeting Signup
|
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
03/15/10-03/16/10 |
|
|
Thousand Oaks, CA
|
$695.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00
P.M. PST |
|
04/19/10-04/20/10 |
|
|
Thousand Oaks, CA
|
$695.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00
P.M. PST |
|
05/10/10-05/11/10 |
|
|
Thousand Oaks, CA
|
$695.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00
P.M. PST |
|
05/10/10-05/11/10 |
|
|
Thousand Oaks, CA
|
$695.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00
P.M. PST |
|
06/24/10-06/25/10 |
|
|
Thousand Oaks, CA
|
$695.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00
P.M. PST |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162.
Also, military and government
discounts available.
Contact us directly for more
details. |
 |
Beginning Microsoft Excel VBA
Training for Business
West Coast
Webcast Signup (PST)
*East coast times and dates in next
section down |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
03/15/10-03/16/10 |
|
|
Webcast Simulcast |
$595.00 |
What is a Webcast? |
8:30 A.M.-4:00
P.M. PST |
|
04/19/10-04/20/10 |
|
|
Webcast Simulcast |
$595.00 |
What is a Webcast? |
8:30 A.M.-4:00
P.M. PST |
|
05/10/10-05/11/10 |
|
|
Webcast Simulcast |
$595.00 |
What is a Webcast? |
8:30 A.M.-4:00
P.M. PST |
|
06/24/10-06/25/10 |
|
|
Webcast Simulcast |
$595.00 |
What is a Webcast? |
8:30 A.M.-4:00
P.M. PST |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162.
Also, military and government
discounts available.
Contact us directly for more
details. |
 |
Beginning Microsoft Excel VBA Training for
Business East Coast
Webcast Signup (EST) |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
04/26/10-04/27/10 |
|
|
Webcast |
$595.00 |
What is a
Webcast? |
9:00 A.M.-4:00 P.M.
EST |
|
06/03/10-06/04/10 |
|
|
Webcast |
$595.00 |
What is a
Webcast? |
9:00 A.M.-4:00 P.M.
EST |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162.
Also, military and government
discounts available.
Contact us directly for more
details. |
 |
Our "premier"
Microsoft Excel VBA workshop for business that shows you
how to construct complex dashboard driven analysis and
data processing business tools in Excel. It shows not
only how to use Excel for this task but how to use VBA
to tie into other programs, databases and computer
languages as well.
Public and
webcast enrollment and
schedule below>>>
Questions? Call us at: 1.805.498.7162
1.805.558.9277-- |
Advanced Excel VBA Training
Focus
The capability exists within Microsoft Excel and VBA to construct
complex dashboard driven analysis and data processing business tools.
These business tools can go far beyond simple macros becoming
actual applications. Excel has a vast array of
automated features like graphics, ActiveX controls, worksheets, userforms
and cell ranges
that when combined together
allow these dashboard driven programs to be
created.
When you tie other programs and computer languages to Excel
through VBA like Word, PowerPoint, Access, SQL Server, Lotus
Notes, C and VB .Net, Excel VBA can tap into these environments obtaining
the functionality it does not have. This workshop focuses on
using all of these elements to construct sophisticated data
processing and analysis programs in Microsoft Excel.
For a complete outline, click the Workshop Outline
button below.

|
Workshop
Details
-
About
EMAGENIT. Our Customers.
-
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,
taught by an actual software developer
-
Repeat this
workshop for free as many times as you want.
View offer details
|
What You Learn at a Glance
-
What
is VBA?
-
An advanced review of the
Excel VBA language
-
Advanced VBA data processing
techniques for multi worksheets and multi workbooks
-
Advanced summary worksheet
construction in Excel using Excel VBA
-
Advanced techniques for scanning Windows folders for workbooks and then
opening them using VBA
-
How to read text files using
VBA.
-
Advanced VBA programming
techniques for creating multiple charts from multiple data sheets
-
How to create advanced
business user interfaces on worksheets using ActiveX controls, VBA and
graphics
-
Advanced
excel dashboard
construction
-
How to create and use
userforms in VBA (wizards)
-
How to create event driven
programs using VBA
-
Advanced VBA error protection
techniques
-
How to create custom
toolbars and menus to run your VBA code
-
How to communicate with
databases using DAO and ADO in VBA and how to download data from the web
using VBA
-
Advanced VBA techniques for
communicating with other languages and programs
|
Self-Study Manual Purchase
Our Microsoft
Excel manuals
support business, engineering and science
professionals depending on the version ordered. We design our Excel self study and
Excel Visual Basic self study manuals around real
world problems facing business professionals, engineers
and scientists.
 |
 |
Advanced Microsoft Excel VBA Training for Business
Public Meeting Signup
|
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
03/17/10-03/19/10 |
|
|
Thousand
Oaks, CA |
$950.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00 P.M.
PST |
|
05/12/10-05/14/10 |
|
|
Thousand
Oaks, CA |
$950.00 |
Thousand Oaks Inn,
Directions |
8:30 A.M.-4:00 P.M.
PST |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162.
Also, military and government
discounts available.
Contact us directly for more
details. |
 |
Advanced Microsoft Excel VBA Training for Business
West Coast
Webcast Signup (PST)
*East coast times and dates in next
section down |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
| Mar. TBA |
|
|
Webcast Simulcast |
$850.00 |
What is a Webcast? |
8:30 A.M.-4:00 P.M.
PST |
|
05/12/10-05/14/10 |
|
|
Webcast Simulcast |
$850.00 |
What is a Webcast? |
8:30 A.M.-4:00 P.M.
PST |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162.
Also, military and government
discounts available.
Contact us directly for more
details. |
 |
Advanced Microsoft Excel VBA Training for Business
East Coast Webcast Signup (EST)
|
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
03/29/10-03/31/10 |
|
|
Webcast |
$850.00 |
What is a
Webcast? |
9:00 A.M.-4:00
P.M. EST |
|
05/24/10-05/26/10 |
|
|
Webcast |
$850.00 |
What is a
Webcast? |
9:00 A.M.-4:00
P.M. EST |
|
06/28/10-06/30/10 |
|
|
Webcast |
$850.00 |
What is a
Webcast? |
9:00 A.M.-4:00
P.M. EST |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162.
Also, military and government
discounts available.
Contact us directly for more
details. |
|
Microsoft Excel and Microsoft Excel VBA Public and
Webcast Engineering & Science Workshops
|
|
 |
Our "workhorse"
Microsoft Excel VBA workshop for engineering and science
that shows you the basics of using
VBA to command Excel, process and reconcile data, create
charts, create functions, build powerful models, build dashboards and more.
Public and
webcast enrollment and
schedule below>>>
Questions? Call us at: 1.805.498.7162
1.805.558.9277-- |
Beginning Excel VBA Training
Focus
Visual Basic for Applications (VBA)
can be used in conjunction with Microsoft Excel to construct
automated engineering and science tools. VBA, a general purpose programming language, comes standard with Excel or Office. Using VBA with Excel,
engineers and scientists can develop analysis tools quickly with minimum cost. VBA can be
used for engineering and scientific tasks like analyzing data, automating
chart construction, building report generation tools, communicating with databases,
constructing dashboards, system models the list is endless. This workshop
discusses the basics of using Excel VBA in the engineering and
science disciplines.
For a complete outline, click the Workshop Outline
button below.

|
Workshop
Details
-
About
EMAGENIT. Our Customers.
-
Personal
examples: Covered
in-class
-
Excel Versions: 2000-2007
-
Type: Engineers and Scientists
-
Platform: Windows
-
Training Materials:
Included, 1600+ page manual including our Excel
Add-Ins
-
Training Method: Hands-on, taught
by an engineer / software developer
-
Repeat this
workshop for free as many times as you want.
View offer details
|
What You Learn at a Glance
-
What
is VBA?
-
How engineers and scientists can use the
Microsoft Excel Visual Basic Editor's debugging tools for their purposes
-
How to use Visual Basic for
Applications (VBA)
for engineering and scientific purposes
-
How to use the VBA language
including variables, loops, logic, arrays, functions...etc
-
How to control key Microsoft
Excel program elements using VBA (Visual Basic)
-
How engineers and scientists
cans use VBA to analyze engineering and
scientific data on the Microsoft Excel worksheet
-
Basic dashboards design for
engineers and scientists using Excel and VBA
-
How engineers and scientists
can construct their own worksheet functions (UDF's) using Excel Visual Basic
(numerical analysis techniques discussion included)
-
How engineers and scientists
can automate chart
construction using Excel VBA
-
How to use the Macro Recorder
to record engineering and scientific tasks in Microsoft Excel
|
Self-Study Manual Purchase
Our Microsoft
Excel manuals
support business, engineering and science
professionals depending on the version ordered. We design our Excel self study and
Excel Visual Basic self study manuals around real
world problems facing business professionals, engineers
and scientists.
 |
 |
Beginning Microsoft
Excel VBA Training for Engineers & Scientists
Public
Meeting Signup |
 |
Beginning Microsoft
Excel VBA Training for Engineers & Scientists
West
Coast Webcast Signup (PST) |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
Feb closed |
|
|
Webcast
Simulcast |
$595.00 |
What is a Webcast? |
8:30 A.M.-4:00
P.M. PST |
|
04/22/10-04/23/10 |
|
|
Webcast
Simulcast |
$595.00 |
What is a Webcast? |
8:30 A.M.-4:00
P.M. PST |
|
06/14/10-06/15/10 |
|
|
Webcast
Simulcast |
$595.00 |
What is a Webcast? |
8:30 A.M.-4:00
P.M. PST |
|
EMAGENIT staff will contact you within one business day of
enrollment. If you have any questions, please call us at
1.805.498.7162.
Also, military and
government discounts available.
Contact us directly for more
details. |
|
 |
Our "premier"
Microsoft Excel VBA workshop for engineering and science
that shows you how to create
amazing software that can save your company ten's of
thousands of dollars and countless wasted hours.
Public and
webcast enrollment and
schedule below>>>
Questions? Call us at: 1.805.498.7162
1.805.558.9277-- |
Advanced Excel VBA Training
Focus
The capability exists within Microsoft Excel VBA to construct
sophisticated engineering and scientific tools that integrate seamlessly with the Microsoft
Excel environment. Using advanced Microsoft Excel VBA
programming techniques, sophisticated
applications can be constructed in Microsoft Excel that
command, organize and analyze engineering and scientific data, automatically chart engineering and scientific data, generate
reports, talk to other applications integrating their data,
perform engineering and scientific modeling, integrate FORTRAN
routines... the list is endless. Many companies are turning to
constructing engineering and scientific applications in Excel due to the lower
cost, lower development time and because of Excel's exceptional
abilities.
This workshop discusses the
advanced uses of Excel VBA in the engineering and science
disciplines.

|
Workshop
Details
-
About
EMAGENIT. Our Customers.
-
Personal
examples: Covered
in-class
-
Excel Versions: 2000-2007
-
Type: Engineers and Scientists
-
Platform: Windows
-
Training Materials:
Included, 1600+ page manual including our Excel
Add-Ins
-
Training Method: Hands-on, taught
by an engineer / software developer
-
Repeat this
workshop for free as many times as you want.
View offer details
|
What You Learn at a Glance
-
What
is VBA?
-
Advanced data analysis
techniques for engineers and scientists using VBA and Excel
-
Advanced Excel VBA programming
techniques for automated chart construction in Microsoft
Excel
-
Advanced dashboards using
Excel and VBA for engineers and scientists
-
Advanced interface
construction using ActiveX controls and userforms
-
Advanced Microsoft Excel VBA programming
techniques for creating event driven
engineering and scientific applications in Microsoft Excel
-
Advanced VBA error trap
construction for engineers and scientists
-
How to create Excel menu bars
and toolbars
-
Advanced Excel VBA programming
tips for communicating with FORTRAN, VB ActiveX DLLs, PERL and C
-
System modeling discussion
including how to use Solver with VBA
-
Advanced VBA programming
strategies for communicating with engineering and science oriented databases
|
Self-Study Manual Purchase
Our Microsoft
Excel manuals
support business, engineering and science
professionals depending on the version ordered. We design our Excel self study and
Excel Visual Basic self study manuals around real
world problems facing business professionals, engineers
and scientists.
 |
 |
Advanced
Microsoft Excel VBA Training for
Engineers & Scientists
Public Meeting Signup |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
03/24/10-03/26/10 |
|
|
Thousand
Oaks, CA
|
$950.00 |
Thousand Oaks Inn,
Directions |
8:30
A.M.-4:00 P.M. PST |
|
05/19/10-05/21/10 |
|
|
Thousand
Oaks, CA
|
$950.00 |
Thousand Oaks Inn,
Directions |
8:30
A.M.-4:00 P.M. PST |
|
EMAGENIT staff will contact you within one business day of
enrollment. If you have any questions, please call us at
1.805.498.7162.
Also, military and
government discounts available.
Contact us directly for more
details. |
 |
Advanced Microsoft Excel
VBA Training for Engineers & Scientists
West
Coast Webcast Signup (PST) |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
03/24/10-03/26/10 |
|
|
Webcast
Simulcast |
$850.00 |
What is a Webcast? |
8:30
A.M.-4:00 P.M. PST |
|
05/19/10-05/21/10 |
|
|
Webcast
Simulcast |
$850.00 |
What is a Webcast? |
8:30
A.M.-4:00 P.M. PST |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162.
Also, military and government
discounts available.
Contact us directly for more
details. |
|
|
|