805.498.7162       805.728.5681
EMAGENIT Logo

Public Microsoft Excel Training, Microsoft Excel VBA Training, Excel Macro Training

Business, Engineering and Science

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 Public Microsoft Excel Training

  • EMAGENIT has been providing Excel and Excel VBA training for over 10 years.
  • Our instructors not only train, they build software for Excel using VBA and Visual Basic .Net as well.
  • EMAGENIT provides Beginning Excel training
  • EMAGENIT provides Intermediate Excel Training
  • EMAGENIT provides Advanced Excel Training

Our beginning, intermediate, advanced and VBA public Excel training workshops are designed for business professionals looking to make the most out of their daily Excel use. Our training is presented using "hands-on" examples and covers both Mac and Windows users. Our instructors use MacBook Pros (intel-based dual core) running Windows as well as Mac OS X operating systems for dual instruction issues. Our public workshop schedule for our Microsoft Excel training is presented to the right.

 

About Our Public Microsoft Excel VBA Training

  • EMAGENIT provides Beginning Microsoft Excel VBA training (Excel Macros are designed using VBA)
  • EMAGENIT provides Advanced Microsoft Excel VBA training (Excel Macros are designed using VBA)

Our Microsoft Excel VBA training workshops are for business professionals, engineers and scientists. Our macro training covers the basics to the most advanced topics and is taught "hands-on". Our instructors use MacBook Pros (intel-based dual core) running Windows as well as Mac OS X operating systems for dual instruction issues. Our public workshop schedule for our VBA Excel Macro training is presented to the right.

 

What is Included in the Price?

  • Our full Excel manual, over 1600 pages of examples and text.

  • Our entire Microsoft Excel add-in software suite.

  • You can repeat the workshop at no extra charge and no time limit. We welcome repeat visits.

 
Public Training Locations
Our public workshops are held in Thousand Oaks (TO), California which is in the vicinity of Los Angeles county (LA County), Ventura county, Santa Barbara county and San Diego county. We hold all of our on-site Microsoft Excel courses nation wide. Our public workshops are a short commute for those living in the San Fernando Valley, Santa Clarita, Newbury Park, Camarillo, Calabasas, Sherman Oaks, Reseda, Woodland Hills, Hollywood, Fillmore, Ventura, Moorpark, Simi Valley, Santa Monica and Oxnard areas.
 
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 discounts for companies sending 3 or more attendees to our VBA classes. Military and government discounts are also available. Contact us for more details.
 

Why Use EMAGENIT?

  • We have been developing software in Microsoft Excel for over 11 years.

  • Our Excel self study and Excel Visual Basic self study manuals are not your generic Excel books

  • We offer a wide variety of Microsoft Excel workshops and Microsoft Excel Visual Basic 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 learn from than a company that actually uses it

  • We cover Excel 97 and beyond

 

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