|
805.498.7162 805.728.5681 |
 |
Microsoft Excel /
Microsoft Excel VBA Signup
|
|
Business, Engineering
and Science |
|
Public Dates:
(9/8) |
|
|
Type: Business Professionals
Platform: Windows or Mac
Versions:
97-2007
Training:
Hands-On
Hotel: Thousand Oaks Inn
Onsite Training:
Details
Repeat
your public workshop as many times as you want, no date or repeat
limit.
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
Overview:
Learn fundamental
Microsoft Excel skills
like
-
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 and more
We also cover personal
examples as part of our
instruction. |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
9/8/08 |
|
|
Thousand Oaks, CA |
$190.00 |
Thousand Oaks Inn |
8:30A.M.-5:00 P.M. |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162. |
|
Public Dates: (7/10),(9/9) |
|
|
Type: Business Professionals
Platform: Windows or Mac
Versions: 97-2007
Training: Hands-On
Hotel: Thousand Oaks Inn
Onsite Training:
Details
Repeat
your public workshop as many times as you want, no date or repeat
limit.
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
Overview:
Learn Microsoft Excel intermediate skills like:
-
Filtering data
using Auto Filter and Advanced Filter
-
Working
with text files using Text Wizard and Text to Columns
-
Using Data Validation
and Conditional
Formatting
-
Perform table lookups using
VLookup and HLookup
-
Build summary/pricing
worksheets
-
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
-
Build basic pivot tables
and more
We also cover personal examples as
part of our instruction. |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
7/10/08 |
|
|
Thousand Oaks, CA |
$190.00 |
Thousand Oaks Inn |
8:30A.M.-5:00 P.M. |
|
9/9/08 |
|
|
Thousand Oaks, CA |
$190.00 |
Thousand Oaks Inn |
8:30A.M.-5:00 P.M. |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162. |
|
Public Dates: (7/11),(9/10) |
|
|
Type: Business Professionals
Platform: Windows or Mac
Versions: 97-2007
Training:
Hands-On
Hotel: Thousand Oaks Inn
Onsite Training:
Details
Repeat
your public workshop as many times as you want, no date or repeat
limit.
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
Overview:
Learn advanced Microsoft Excel skills like:
-
Building
forms using ActiveX controls
-
Building dashboards using
array formulas, charts and drawing shapes
-
Querying databases
-
Advanced
data filtering
-
Pivot table construction
-
Linking Excel with other programs like
Word
-
Macro recording and
more
We also cover personal
examples as part of our instruction. |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
7/11/08 |
|
|
Thousand Oaks, CA |
$190.00 |
Thousand Oaks Inn |
8:30 A.M.-5:00
P.M. |
|
9/10/08 |
|
|
Thousand Oaks, CA |
$190.00 |
Thousand Oaks Inn |
8:30 A.M.-5:00
P.M. |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162. |
|
Public Dates:
(7/28-7/29),(9/22-9/23) |
|
|
Type: Business Professionals
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Hotel: Thousand Oaks Inn
Onsite Training:
Details
Repeat
your public workshop as many times as you want, no date or repeat
limit.
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
Overview:
This workshop covers the fundamentals of using VBA
programming. It
covers
VBA fundamentals
such as loops, variables and logic and controlling Microsoft
Excel, Microsoft Word and PowerPoint using VBA. This
workshop also covers
data processing
using Excel and VBA including single
data sheet, multi data sheet
problems and summary sheets. It also covers
automated chart construction
and
beginning dashboard topics.
It uses real world examples that lets you start building
macros in Excel right away. We also cover personal examples
as part of our instruction. |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
7/28/08-7/29/08 |
|
|
Thousand Oaks, CA |
$1050.00 |
Thousand Oaks Inn |
8:30 A.M.-5:00
P.M. |
|
9/22/08-9/23/08 |
|
|
Thousand Oaks, CA |
$1050.00 |
Thousand Oaks Inn |
8:30 A.M.-5:00
P.M. |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162. |
|
Public Dates:
(6/19-6/20) |
|
|
Type: Business Professionals
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Location:
Web Cast
Web Cast:
Details
Onsite Training:
Details
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
Overview:
This workshop covers the fundamentals of using VBA
programming. It
covers
VBA fundamentals
such as loops, variables and logic and controlling Microsoft
Excel, Microsoft Word and PowerPoint using VBA. This
workshop also covers
data processing
using Excel and VBA including single
data sheet, multi data sheet
problems and summary sheets. It also covers
automated chart construction
and
beginning dashboard topics.
It uses real world examples that lets you start building
macros in Excel right away. We also cover personal examples
as part of our instruction. |
 |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
8/18/08-8/19/08 |
|
|
None |
$850.00 |
Web Cast |
10:00 A.M.-5: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. |
|
Public Dates: (7/30-8/1),(9/24-9/26) |
|
|
Type: Business Professionals
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Hotel: Thousand Oaks Inn
Onsite Training:
Details
Repeat
your public workshop as many times as you want, no date or repeat
limit.
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
Overview:
This workshop covers advanced VBA topics such as
advanced data processing,
automated chart construction
for multi worksheets; advanced
control techniques of other applications such as Microsoft
Word and Microsoft PowerPoint;
advanced dash board construction
using charts, pictures, ActiveX controls and drawing shapes;
wizard construction using
userforms;
advanced worksheet layout including navigation;
database communication
using ADO and DAO; communicating with other computer
languages like PERL and C and
advanced report generation.
It uses real world examples that lets you take your Excel
applications to the top level. We also cover personal
examples as part of our instruction. |
 |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
7/30/08- 8/1/08 |
|
|
Thousand Oaks, CA |
$1325.00 |
Thousand Oaks Inn |
8:30
A.M.-5:00 P.M. |
|
9/24/08- 9/26/08 |
|
|
Thousand Oaks, CA |
$1325.00 |
Thousand Oaks Inn |
8:30
A.M.-5:00 P.M. |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162. |
|
Public Dates:
(Oct TBA) |
|
|
Type: Business Professionals
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Location:
Web Cast
Web Cast:
Details
Onsite Training:
Details
Repeat
your public workshop as many times as you want, no date or repeat
limit.
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
Overview:
This workshop covers advanced VBA topics such as
advanced data processing,
automated chart construction
for multi worksheets; advanced
control techniques of other applications such as Microsoft
Word and Microsoft PowerPoint;
advanced dash board construction
using charts, pictures, ActiveX controls and drawing shapes;
wizard construction using
userforms;
advanced worksheet layout including navigation;
database communication
using ADO and DAO; communicating with other computer
languages like PERL and C and
advanced report generation.
It uses real world examples that lets you take your Excel
applications to the top level. We also cover personal
examples as part of our instruction. |
 |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
Oct
TBA |
|
|
None |
$1050.00 |
Web Cast |
10:00 A.M.-5: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. |
|
Public Dates: (9/29-10/1) |
|
|
Type: Business Professionals
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Hotel: Thousand Oaks Inn
Web Cast: Details
Onsite Training:
Details
Repeat
your public workshop as many times as you want, no date or repeat
limit.
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
Overview:
This workshop covers how to make
sophisticated dashboard layouts
in Microsoft Excel. Taught is how to use charts, pictures,
drawing shapes, the worksheet and VBA in combination with
each other to create visually stunning and functional Excel
dashboard displays. Learn how to animate Microsoft Excel
constructing timelines,
calendars, performance meters, process maps
and a lot more. The course also covers
database communication,
chart
construction
and
data processing techniques
using VBA. Great for visualizing data stored in external databases
and Microsoft Excel based tables. We
also cover personal examples as part of our instruction. |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
9/29/08-10/1/08 |
|
|
Thousand Oaks, CA |
$1325.00 |
Thousand Oaks Inn |
8:30
A.M.-5:00 P.M. |
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162. |
|
Public Dates:
(8/11-8/13) |
|
|
Type: Business Professionals
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Location:
Web Cast
Web Cast: Details
Onsite Training:
Details
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
Overview:
This workshop covers how to make
sophisticated dashboard layouts
in Microsoft Excel. Taught is how to use charts, pictures,
drawing shapes, the worksheet and VBA in combination with
each other to create visually stunning and functional Excel
dashboard displays. Learn how to animate Microsoft Excel
constructing timelines,
calendars, performance meters, process maps
and a lot more. The course also covers
database communication,
chart
construction
and
data processing techniques
using VBA. Great for visualizing data stored in external databases
and Microsoft Excel based tables. We
also cover personal examples as part of our instruction. |
|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
8/11/08-8/13/08 |
|
|
None |
$1050.00 |
Web Cast |
10:00 A.M.-5: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. |
|
Public Dates:
(7/14-7/15),(9/15-9/16) |
|
|
Type: Engineers and Scientists
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Hotel: Thousand Oaks Inn
Web Cast: Details
Onsite Training:
Details
Repeat
your public workshop as many times as you want, no date or repeat
limit.
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
Overview:
This workshop
covers the fundamentals of using VBA programming in the engineering
and science world. From loops,
variables and logic to controlling Microsoft Excel, Microsoft Word
and PowerPoint to data processing. It also covers automated
engineering chart
construction, beginning dashboard topics, system modeling, custom
worksheet functions (UDF's) and numerical analysis approaches. It uses real
engineering and science examples that lets you start building
useable macros in
Excel right away.
We also cover personal examples as
part of our instruction. |

|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
Closed |
|
|
Thousand Oaks, CA |
$1050.00 |
Thousand Oaks Inn |
8:30A.M.-5:00 P.M. |
|
9/15/08-9/16/08 |
|
|
Thousand Oaks, CA |
$1050.00 |
Thousand Oaks Inn |
8:30A.M.-5:00 P.M. |
|
|
EMAGENIT staff will contact you within one business day of enrollment. If
you have any questions, please call us at 1.805.498.7162. |
|
Public Dates:
(8/4-8/5) |
|
|
Type: Engineers and Scientists
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Location:
Web Cast
Web Cast: Details
Onsite Training:
Details
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
Overview:
This workshop
covers the fundamentals of using VBA programming in the engineering
and science world. From loops,
variables and logic to controlling Microsoft Excel, Microsoft Word
and PowerPoint to data processing. It also covers automated
engineering chart
construction, beginning dashboard topics, system modeling, custom
worksheet functions (UDF's) and numerical analysis approaches. It uses real
engineering and science examples that lets you start building
useable macros in
Excel right away.
We also cover personal examples as
part of our instruction. |

|
Dates |
Enroll |
View Cart |
Location |
Cost |
Facility |
Time |
|
8/4/08-8/5/08 |
| | | |