Microsoft Excel Aided Engineering Workshop Outline

In our "complete guide" to Microsoft Excel and Microsoft Excel VBA workshop, you will learn the methods behind coupling Excel and VBA to produce engineering and science applications that do days of work at the click of a button. From system modeling to data analysis to design optimization read below and see how we can help supercharge your Excel spreadsheets >>>

Call us at:   1.805.498.7162     1.805.558.9277--

Learn about how we can help your company or yourself achieve your Microsoft Excel training or self-study goals Visit our free Microsoft Excel and Microsoft Excel VBA resource center Learn how we can help save your company money with our innovative software solutions Visit out VBA code center for code that can save your company money Learn about our Excel Add-In software that can save your company time and money View our customer list from our 12 years in business Phone numbers, request form and email address Learn about EMAGENIT View our training schedule for Microsoft Excel and Microsoft Excel VBA

NASA Award for Microsoft Excel Design

EMAGENIT received an award from NASA for its software design in Microsoft Excel and VBA for the Mars Rover. We provide training for customers like AMGEN, General Dynamics and Caterpillar. Read below to learn more about our Beginning VBA Training.

 

Workshop Availability

  • Onsite, Self-Study
Workshop Outline

Microsoft Excel-Aided Engineering is a 1-5 day "hands-on" Microsoft Excel training workshop for engineers and scientists or self-study manual that covers critical Microsoft Excel, VBA, FORTRAN and ActiveX engineering topics. Covered in the workshop are Microsoft Excel engineering topics like:

  • Microsoft Excel worksheet fundamentals
  • Engineering formula design on the Microsoft Excel worksheet including array and complex numbers operations
  • How to use logic and database functions to create "smart" adaptive engineering worksheets
  • How to use the conditional formatting and data validation features in Microsoft Excel to monitor system requirements and create project alert displays
  • Developing dynamic interlinked system models in Microsoft Excel using single and multi-team workbooks
  • Matrix algebra, dynamic system simulation, boundary value problem, integration, differentiation and complex number solution techniques on the Microsoft Excel worksheet
  • How to create engineering charts and generate engineering reports in Microsoft Excel
  • How to develop carpet plots and perform trade studies using Microsoft Excel
  • Complete Microsoft Excel VBA and object oriented programming review for engineers and scientists
  • How to use Microsoft Excel VBA to design your own engineering functions for the worksheet and how to distribute them to teams
  • How to use ActiveX controls to create engineering GUI's on the Microsoft Excel worksheet
  • How to create event driven Microsoft Excel engineering applications using VBA
  • How to create and manage engineering databases in Microsoft Excel and link with external databases using Excel's built-in features and VBA
  • How to automatically create engineering charts using VBA
  • How to integrate design teams in Microsoft Excel over a network
  • Using Microsoft Excel for data analysis tasks
  • How to access engineering databases from Microsoft Excel
  • Engineering design optimization in Microsoft Excel using single and multi-workbook based models
  • How to monitor system requirements while performing design optimization
  • How to use Microsoft Excel and VBA to control and integrate other engineering programs written in FORTRAN and VB
  • How to design rapid prototyping and analysis environments in Microsoft Excel
  • How to design engineering wizards using VBA userforms in Excel
  • How to provide navigation for your engineering applications in Microsoft Excel
  • How to package and provide security for engineering applications in Microsoft Excel (Add-In's, templates and workbooks)
  • How to construct verified team tools in Microsoft Excel
  • How to construct and use VB ActiveX DLL's with Microsoft Excel
  • How to use Microsoft Excel as a command and control center integrating other engineering application data

Click here to view the full workshop outline.

It covers vital Microsoft Excel VBA skills that allow engineers and scientists to exploit the full power of Microsoft Excel.

Intended Audience
  • Excel-Aided Engineering was designed to accommodate the Excel beginner as well as the advanced developer.

  • It is intended for all types of engineers and scientists.

Training Options and Self-Study

   

EMAGENIT's Training Location

Public Location: Thousand Oaks, CA

Hotel: Thousand Oaks Inn

EMAGENIT is based in Thousand Oaks, CA 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 courses on-site nation wide. We also webcast (webinar) our public workshops, consult our webcast page for more information.

Our public workshops are a short commute for those living in:

  • Los Angeles, CA

  • Palmdale, CA

  • Westwood, CA

  • Santa Barbara, CA

  • San Fernando Valley, CA

  • Santa Clarita, CA

  • Newbury Park, CA

  • Westlake Village, CA

  • Camarillo, CA

  • Calabasas, CA

  • Sherman Oaks, CA

  • Reseda, CA

  • Woodland Hills, CA

  • Hollywood, CA

  • Fillmore, CA

  • Ventura, CA

  • Moorpark, CA

  • Simi Valley, CA

  • Santa Monica, CA

  • Oxnard, CA

  • Pasadena, CA

  • Agoura, CA

For more information about our public workshops, visit our public workshops page our call us at 805.498.7162.

Information Request

Submit a question to us via email at eae@emagenit.com

Call EMAGENIT between the hours of 8:00 A.M. and 5 P.M. PST at 1.805.498.7162 or 805.558.9277 for more information about this workshop.

Newsletter Contact Us Training Help
 

 

 

 

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-2011 EMAGENIT All Rights Reserved