Workshop teaches Excel for engineers

Emagenit has released a new version of its popular Microsoft Excel/VBA workshop for engineers called AETS for Engineers.

Emagenit has just released a new version of its popular Microsoft Excel/VBA workshop for engineers called Excel-Aided Engineering.

This workshop is a modular 1-5 day on-site hands-on workshop that can be taught in the USA and Europe.

It can be customised to fit a company's particular Excel needs.

It also comes in a self-study version and is taught as a public course in the USA.

It covers all the popular Microsoft Excel topics engineers want to know like: worksheet and chart sheet fundamentals; engineering formula design on the worksheet including array and complex numbers operations; how to use logic and database functions to create "smart" engineering worksheets; how to use the conditional formatting and data validation features in Excel to create interactive engineering applications on the worksheet; developing dynamic interlinked system models in Excel using single- and multi-team workbooks; matrix algebra, dynamic system simulation, boundary value problem, integration, differentiation and complex number solution techniques on the worksheet; complete VBA and object oriented programming review for engineers; how to use VBA to design your own engineering functions for the worksheet; engineering GUI design on the worksheet using ActiveX controls; how to create event driven engineering applications in Excel using VBA; how to create and manage engineering databases in Excel and link with external databases using Excel's built-in features and VBA; how to integrate design teams in Excel over a network; using Excel for data analysis tasks; how to access engineering databases from Excel; engineering design optimisation in Excel using single- and multi-workbook based models; how to develop carpet plots and perform trade studies using Excel; how to use Excel and VBA to control and integrate other engineering programs written in Fortran and C; how to design rapid prototyping and analysis environments in Excel; how to design engineering wizards using VBA userforms in Excel; how to provide navigation for your engineering applications in Excel; how to package and provide security for engineering applications in Excel (add-ins, templates and workbooks); how to construct verified team tools in Excel; introduction to constructing and using VB ActiveX DLLs with Excel; and how to use Excel as a command and control centre integrating other engineering application data.

Back to top