EMAGENIT
NASA Award
|
 |
|
EMAGENIT received an award
for its involvement with NASA JPL in helping redesign and integrate their
conceptual Rover mission
software in Microsoft Excel.
Click the picture above for more detail about our Rover
involvement. To learn more about the NASA mission to mars
click here. |
|
Awards & Customers |
About Our Microsoft
Excel Corporate Training
|
- EMAGENIT has been providing
Excel and Excel VBA training for over 10 years.
- We train top companies on
the uses Excel.
- Our instructors not only
train they build software for Excel using VBA and Visual
Basic .Net as well.
- EMAGENIT provides Microsoft Excel
onsite training and Microsoft Excel VBA
on site training for business professionals, engineers and scientists.
- We
also provide specialized VB .Net, Access, SQL Server, FORTRAN
DLL and VB Active X onsite training.
|
On Site Training
Benefits
|
Low Cost
- It actually costs less
to bring us onsite than it does to take a public
workshop. Inquire at 805.498.7162 or click the Request
Information button to the left for more details.
- We
can supply computers, projector and screen.
Custom Training
- We can custom
design a course that fits your company's needs at no
extra cost. Most of the time our customers want a mixture of
the course topics you see to the right. We incorporate your
company’s Microsoft Excel or Excel Visual Basic (VBA) problems into
our workshops.
Don't See What
You Want
- If you do not see
what you want, just ask us. We also cover how to use SQL
Server, Microsoft Access and Microsoft Word with Excel as
well as a host of other programs.
|
What
is Included in the Price
|
-
State
of the art CD-ROM manuals, which explain in detail the Excel
topics discussed in class. These manuals contain state of
the art screen shots of Excel, step by step Excel
instructions, useful Excel tips, the examples covered in
class and supplementary examples.
-
In-class consulting on your company’s specific Excel
problems. The class can be designed around the problems
faced by your company.
-
Your employees can attend the
same public workshop at no extra cost as many times as
they want.
|
Our Clients
|
|
We train
organizations and companies like NASA, RAND, Hewlett Packard, The
Consumer Product Safety Commission, Conoco Phillips, Shell,
LSI
and Caterpillar |
How
We Train
|
- We do not teach a canned
generic Microsoft Excel workshop.
- Our onsite training is presented using
"hands-on" examples and our workshops can be customized to your companies needs.
-
We offer a wide variety of Microsoft Excel and Microsoft Excel
Visual Basic Programming workshops for beginning through Excel
power users.
- We develop Microsoft
Excel applications for companies like Northrop Grumman, NASA JPL
and Caterpillar so whom better to teach you than a company that
actually uses what they teach.
- Our FORTRAN DLL and
Visual Basic ActiveX DLL training provides instruction on how to
use these two technologies with Microsoft Excel and Microsoft
Excel VBA.
|
|
Payment Options |
|
EMAGENIT accepts Visa, MasterCard, Discover Card
and American Express.
Click here
for more payment options and our mailing address. |
|
Pricing and Discounts
|
|
EMAGENIT offers
military and government discounts. Contact us for more details. |
|
Beginning Microsoft
Excel Onsite Training
|
|
|
Type: Business
Professionals
Platform: Windows or Mac
Versions: 97-2007
Training:
Hands-On
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
|
Intermediate Microsoft
Excel Onsite Training
|
|
|
Type: Business
Professionals
Platform: Windows or Mac
Versions: 97-2007
Training:
Hands-On
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
|
Advanced Microsoft
Onsite Excel Training
|
|
|
Type: Business
Professionals
Platform: Windows or Mac
Versions: 97-2007
Training:
Hands-On
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
|
Microsoft Excel
VBA (Macro) Company Training for Business
|
Beginning Microsoft
Excel VBA On Site Training
|
|
|
Type: Business
Professionals
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA? |
|
Overview:
This
on-site workshop covers the fundamentals of using VBA programming. From
loops, variables and logic to controlling Microsoft Excel, Microsoft
Word and PowerPoint to data processing.
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. |
Advanced Microsoft
Excel VBA On Site Training
|
|
|
Type: Business
Professionals
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
|
|
Overview:
This on-site workshop covers
advanced VBA topics such as 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. |
Specialized Microsoft Excel
VBA Company Training for Business
|
VB
ActiveX DLL Design On Site Training
|
|
|
Type: Business
Professionals
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA? |
|
Overview:
This on site workshop
covers how to protect your Excel VBA code using a VB ActiveX
DLL and also how to construct your own objects. |
Microsoft Excel VBA Data
Analysis On-Site Training
|
|
|
Type: Business Professionals
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
|
|
Overview:
This on-site workshop
focuses entirely on automating data analysis in Microsoft Excel
using Excel VBA.
Covered are strategies for importing
text files, automating multi file access in Windows (multi files to
open), single and multi worksheet data processing strategies,
summarizing data, automating chart construction, how to query data
from databases, automating report generation in Word and PowerPoint
and how to automate Excel's built-in data processing features. |
Microsoft Excel
Dashboards On-Site Training
|
|
|
Type: Business
Professionals
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
|
|
Overview:
This on site workshop covers
advanced VBA topics such as 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. |
Beginning Excel VBA for
Engineers and Scientists Onsite Training
|
|
|
Type: Engineers and Scientists
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
|
|
Overview:
This on-site 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. |
|
Advanced
Excel VBA for Engineers and Scientists Onsite Training |
|
|
Type: Engineers and Scientists
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA? |
|
Overview:
This on site 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. |
|
Specialized Microsoft Excel VBA Training
for Engineers and
Scientists |
Microsoft Excel VBA
Data Analysis On-Site Training
|
|
|
Type: Engineers and Scientists
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
|
|
Overview:
This on-site workshop
focuses entirely on automating data analysis in Microsoft
Excel using Excel VBA.
Covered are strategies for
importing text files, automating multi file access in
Windows (multi files to open), single and multi worksheet
data processing strategies, summarizing data, automating
chart construction, how to query data from databases,
automating report generation in Word and PowerPoint and how
to automate Excel's built-in data processing features. |
 |
Microsoft
Excel-Aided Engineering and Science On-Site Training
|
|
|
Type: Engineers and Scientists
Platform: Windows
Versions: 97-2003
Training:
Hands-On
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
|
|
Overview: This all in
one on-site workshop covers basic engineering and science formula
design on the worksheet to numerical techniques on the
worksheet like linear systems, Runge Kutta, Newton's method,
integration, differentiation and boundary value problems. It
also covers complex number operations and advanced
engineering and science charts. EAE also covers system
modeling, design optimization using Solver and integrating
engineering teams. Also reviewed is beginning and advanced
VBA programming including userform design, data processing and how to
integrate FORTRAN into your coding solutions. It is the
workshop that all of our other workshops are based off. |
FORTRAN
DLL Microsoft Excel Visual Basic Programming
|
|
|
Type: Engineers and Scientists
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
|
|
Overview: This
on-site workshop covers how to create FORTRAN
DLLs that interface with Microsoft Excel Visual Basic. It
discusses how to call FORTRAN from VBA procedures and
worksheet formulas allowing entire FORTRAN programs to be
run from a single cell. Also discussed are the essentials
for communicating with FORTRAN like passing arrays, strings
and scalar values. It also discusses how to convert existing
FORTRAN programs to the DLL standard. |
|
Microsoft
Excel VBA UDF Design On Site Training |
|
|
Type: Engineers and Scientists
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA?
|
|
Overview: This
on-site workshop covers how
to build your own custom engineering and science functions in VBA.
Discussed is how to design and call VBA function procedures from
other procedures. Also discussed is how to create custom user
defined worksheet
functions (UDF's) using Microsoft Excel VBA. UDF's can be used to
communicate with databases, other computer languages and even other
applications. Learning how to create UDF's allow advanced system and
analysis models on the worksheet to be created. Also discussed are
advanced system modeling techniques and how to use UDF's with Solver
allowing advanced system models to be optimized. |
VB
ActiveX DLL Design On Site Training
|
|
|
Type: Engineers and Scientists
Platform: Windows
Versions: 97-2007
Training:
Hands-On
Consult our
Training Guide
to help decide on the right workshop.
What Is VBA? |
|
This on site workshop
covers how to protect your Excel VBA code using a VB ActiveX
DLL and also how to construct your own objects. |
|
|