EMAGENIT Awards and Training Options
|
NASA
Award
|
Web Cast
Training |
|
|
EMAGENIT received an award
for its involvement with NASA JPL in helping redesign and integrate their
conceptual Rover mission
software in Microsoft Excel.
View the Mars Mission home page. View
our
Awards & Customers. |
|
|
Live "hands-on" Excel
webcast training with an
instructor via the internet.
Lower cost, no traveling,
hands-on training and
voice interactive.
More... |
|
On-Site
Training
|
Public
Workshops |
|
|
EMAGENIT can travel anywhere in the U.S. to
your company for less than our per person
public workshop price. We have additional
workshops for onsite training that are not
listed in our public schedule. We can also
create a custom workshop that suits your
needs.
More... |
|
|
EMAGENIT presents
public workshops for Microsoft Excel and Microsoft
Excel VBA. We have workshops for business,
engineering and science professionals. Our public
schedule is presented to the right.
More... |
|
Self-Study
Training
|
New to
Excel |
|
EMAGENIT sells
it Microsoft Excel and Microsoft Excel VBA
workshops as self-study manuals. 3 month
e-mail interaction and if you decide to take
the workshop, we will deduct the manual
price.
More... |
|
|
If
you are new to Microsoft Excel
or Excel VBA, review the
following hyperlinks to
familiarize yourself with its
capabilities.
VBA
Overview
Microsoft Excel Overview
If you are an engineer and are
interested in using FORTRAN with
Excel read the following
overview.
FORTRAN DLL Overview |
|
|
EMAGENIT Profile |
|
About
EMAGENIT |
 |
|
EMAGENIT provides
Microsoft Excel training, Microsoft Excel VBA
training, Excel macro training and Visual Basic .Net
training for business and engineering professionals.
Our diverse engineering, science and business
background also allows us to create a custom
Microsoft Excel training solution that is right for
you. We also provide FORTRAN DLL training.
EMAGENIT also provides software design services
using Microsoft Excel VBA and Visual
Basic .Net. Using these tools, EMAGENIT creates
unique business and engineering hybrid software
designs that are more flexible than traditionally
designed software tools and less expensive to build.
We also use FORTRAN DLL, Visual Basic ActiveX,
Microsoft Word, Microsoft Access and Microsoft SQL
Server in our designs. Our diverse background in
engineering and business allows us to tackle any
job. |
|
|
Microsoft Excel and Windows Software
Design |
|
Software
Design |
 |
|
EMAGENIT constructs
software for Microsoft Excel and Windows
using Visual Basic .Net, VBA, MS SQL
Server, Microsoft Access, Microsoft Word
and Microsoft PowerPoint. We design
basic macros for Microsoft Excel to
advanced hybrid designs using VB .Net
and Microsoft Excel VBA that integrate
thousands of people.
More.... |
|
Additional Training Information |
EMAGENIT Training Options
|
-
Workshops
home
-
On-site
.... EMAGENIT travels to
your company
-
Public....
You travel to Thousand Oaks, California
-
Self
Study.... Buy our class manuals. Looking
for FORTRAN DLL or ActiveX DLL design, we have
that also.
-
Web Cast...Take a workshop on your computer
real time
|
EMAGENIT Training Options for Business and
Engineering |
-
Microsoft
Excel Training......Beginning, Intermediate and Advanced Excel
-
Microsoft Excel VBA Training
(Macros)......Beginning to Advanced including
database and multi program control
-
Visual
Basic .Net Training......Beginning and Database
Communication (Coming this fall)
|
EMAGENIT Training Advantages
|
-
Our workshops can be
customized to fit your company's needs at no additional cost.
-
We
develop software for large companies like
Caterpillar, LSI, Verizon and organizations like
NASA so we teach what we use.
-
EMAGENIT has over 15 years of design experience
using Excel and Visual Basic.
-
To
view
our workshop training home page click here.
|
|
Public Workshop Spotlight
|
|
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
Webcast: Details,
Signup
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. |
 |
|
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. |
|
|
|
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. |
|
|
|
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. |
|
|
|
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
Webcast: Details,
Signup
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. |
|
|
|
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
Web Cast: Details,
Signup
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. |
|
|
|
Public Dates: (9/29-10/1) |
|
|
Type: Business
Professionals
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Hotel: Thousand Oaks
Inn
Web Cast: Details,
Signup
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. |
 |
|
Public Dates: (July closed),(9/15-9/16) |
|
|
Type: Engineers and Scientists
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Hotel: Thousand Oaks
Inn
Web Cast: Details,
Signup
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. |
|
|
|
Public Dates:
(July closed),(9/17-9/19) |
|
|
Type: Engineers and Scientists
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Hotel: Thousand Oaks
Inn
Webcast: Details,
Signup
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 engineering and science VBA topics such as automated
engineering chart construction for multi
worksheets; advanced control techniques of other applications such
as Microsoft
Word and
Microsoft PowerPoint; advanced engineering dash board
construction
using
charts, pictures, ActiveX controls and drawing shapes;
engineering wizard construction
using userforms; advanced worksheet layout
including navigation; advanced system modeling; team linking; database
communication using ADO and DAO and communicating with other computer languages like
FORTRAN. 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. |
|
|
|
|
|
