805.498.7162       805.728.5681
EMAGENIT Logo

Microsoft Excel VBA Training, Microsoft Excel Software Design, Microsoft Excel Manuals

Business, Engineering and Science

EMAGENIT Awards and Training Options

NASA Award

Web Cast Training

Learn about EMAGENIT's involvement with the NASA mars rover and our Mac 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.

Webcast training for Microsoft Excel VBA and Microsoft Excel

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

On-Site training for Microsoft Excel and Microsoft Excel VBA

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...

Public training for Microsoft Excel and Microsoft Excel VBA

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
Self-Study manuals for Microsoft Excel and Microsoft Excel VBA

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
Microsoft Excel and Windows Software Design Featuring VBA, VB .NET, SQL Server and Microsoft Excel Access
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 Training Directory and Schedules

Engineering/Science Business

Public Workshop Spotlight

Beginning Microsoft Excel VBA Training for Business

Public Dates: (7/28-7/29),(9/22-9/23)
Beginning Microsoft Excel VBA

Type: Business Professionals

Platform: Windows

Versions: 97-2007

Training: Hands-On

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

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 price and signup Class outline and location information Price and purchase the manual for the class
 

Public Workshops for Business Professionals

Beginning Microsoft Excel Training

Public Dates: (9/8)
Beginning Microsoft Excel

Type: Business Professionals

Platform: Windows or Mac

Versions: 97-2007

Training: Hands-On

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

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 price and signup Class outline and location information Price and purchase the manual for the class
 

Intermediate Microsoft Excel Training

Public Dates: (7/10),(9/9)
Intermediate Microsoft Excel
Type: Business Professionals

Platform: Windows or Mac

Versions: 97-2007

Training: Hands-On

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

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 price and signup Class outline and location information Price and purchase the manual for the class
 

Advanced Microsoft Excel Training

Public Dates: (7/11),(9/10)
Advanced Microsoft Excel

Type: Business Professionals

Platform: Windows or Mac

Versions: 97-2007

Training: Hands-On

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

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 price and signup Class outline and location information Price and purchase the manual for the class
 

Beginning Microsoft Excel VBA Training for Business

Public Dates: (7/28-7/29),(9/22-9/23)
Beginning Microsoft Excel VBA

Type: Business Professionals

Platform: Windows

Versions: 97-2007

Training: Hands-On

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

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 price and signup Class outline and location information Price and purchase the manual for the class
 

Advanced Microsoft Excel VBA Training for Business

Public Dates: (7/30-8/1),(9/24-9/26)
Advanced Microsoft Excel VBA

Type: Business Professionals

Platform: Windows

Versions: 97-2007

Training: Hands-On

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

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 price and signup Class outline and location information Price and purchase the manual for the class
 

Microsoft Excel Dash Board Training

Public Dates: (9/29-10/1)
Microsoft Excel Dashboards

Type: Business Professionals

Platform: Windows

Versions: 97-2007

Training: Hands-On

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

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 price and signup Class outline and location information
 

Public Workshops for Engineers and Scientists

Beginning Microsoft Excel VBA Training for Engineers and Scientists

Public Dates: (July closed),(9/15-9/16)
Beginning Microsoft Excel VBA for Engineers

Type: Engineers and Scientists

Platform: Windows

Versions: 97-2007

Training: Hands-On

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

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 price and signup Class outline and location information Price and purchase the manual for the class
 

Advanced Microsoft Excel VBA Training for Engineers and Scientists

Public Dates: (July closed),(9/17-9/19)
Advanced Microsoft Excel VBA for Engineers

Type: Engineers and Scientists

Platform: Windows

Versions: 97-2007

Training: Hands-On

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

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.

Public price and signup Class outline and location information Price and purchase the manual for the class

Request information about our training, products or software design Read about our public training schedule, location and pricing Read about our web cast training schedule and pricing Read about our onsite training workshops Read about our self study manuals and pricing Read about our unique software design services for Windows and Excel Visit our product store for our latest software and manuals Download Excel VBA code for data processing, dashboards, automated charting...

 

 

 

 

 

 

 

Additional Pages

Microsoft Excel Classes  Microsoft Excel VBA Courses  Microsoft Excel Training  Microsoft Excel Macros  Microsoft Excel VBA Consulting  Microsoft Excel Add-Ins

Copyright © 2002-2008 EMAGENIT All Rights Reserved