805.498.7162       805.728.5681
EMAGENIT Logo

Microsoft Excel-Aided Engineering and Science Workshop Outline

Business, Engineering and Science

Click here to return to our Excel Aided Engineering home page.

Training Module Overview

  • The following training modules are offered for on-site or public instruction.
  • All modules are offered at public offerings of E.A.E.
  • For on-site training, modules may be mixed and matched.

For more information, please contact us at 1.805.498.7162 or 805.728.5681 or email us at eae@emagenit.com.

Workshop Outline

Module #1: Excel Basics for Engineers and Scientists

  • Introduction to Microsoft Excel, VBA, DLL’s and graphical user interfaces
  • Excel program interface review including how to use Excel on-line help
  • Workbook file command and control

Module #2: Excel and the Engineering/Science Professional

  • Discusses how Excel can be used in the engineering and scientific process in the areas of analysis, modeling, FORTRAN, C and VB integration, wizard development, rapid design and analysis environments and team integration

Module #3: Engineering Methodologies and Analysis on the Worksheet

  • Worksheet/cell command and control fundamentals
  • Engineering and scientific formula construction and editing techniques on the worksheet
  • How to name cells and ranges and use them in engineering and scientific formulas
  • How to design input and output ranges on the worksheet
  • How to use lookup, logical, reference and database functions to create "smart" engineering and scientific worksheets
  • How to perform matrix algebra, dynamic system simulation, boundary value problem, integration, differentiation and complex number solution techniques on the worksheet
  • How to use the conditional formatting and data validation features in Excel to create interactive engineering and scientific applications on the worksheet
  • How to track engineering and scientific data using the conditional formatting feature
  • How to protect worksheets and workbooks
  • How to create engineering and scientific forms on the worksheet
  • How to design data and management task tracking applications in Excel using the conditional formatting feature
  • Single workbook system model construction techniques

Module #4: Creating Engineering and Scientific Charts and Reports in Excel

  • Engineering and scientific chart construction using Chart Wizard
  • Engineering and scientific chart editing and formatting techniques
  • Engineering and scientific curve fitting in Excel
  • Data visualization in Excel
  • Engineering and scientific carpet plot creation
  • Engineering and scientific report generation strategies in Excel

Module #5: VBA Editor and Module Basics for Engineers and Scientists

  • Overview of how VBA can help the engineering and scientific process
  • VBA editor overview including VBA project, module and procedure overview
  • Controlling and typing in VBA modules
  • Referencing and integrating VBA projects
  • Using the VBA debugger to debug your code

Module #6: VBA Language Basics for Engineers and Scientists

  • VBA variables, constants and arrays (declaring, scope and data typing)
  • VBA operators (logical, arithmetic and comparison)
  • Control structures (loops and logic decisions)
  • Overview of Excel objects, properties and methods
  • How to identify and command Excel objects using VBA
  • How to use Excel/VBA on-line help
  • How to use the VBA macro recorder to record Excel tasks in VBA
  • How to use the Object Browser
  • How to error proof your VBA code

Module #7: Function Procedure Design for Engineers and Scientists

  • Benefits of using Function procedures and User Defined Worksheet Functions (UDF's) for engineering and scientific tasks
  • Function procedure and UDF differences
  • How to declare Function procedures and UDF’s in VBA
  • How to create arguments for Function procedures and UDF’s
  • How to call UDF’s from a worksheet formula
  • Calling Function procedures from other VBA procedures
  • Function procedure and UDF procedure interface design
  • How to pass worksheet ranges as arguments to UDF's
  • Returning scalar and array values from UDF’s to worksheet formulas
  • Using VBA and Excel Worksheet functions in your procedures

Module #8: Sub Procedure Design for Engineers and Scientists

  • Benefits of using Sub procedures for engineering and scientific tasks
  • Declaring Sub procedures in VBA
  • Creating arguments for Sub procedures
  • Calling Sub procedures from other VBA procedures
  • Executing Sub procedures via the Macro dialog box
  • Executing Sub procedures via shortcut keys
  • Executing Sub procedures via engineering and scientific graphics
  • Executing Sub procedures via events
  • Sub procedure interface design
  • Sub procedure design tips for engineers and scientists
  • Property procedure overview

Module #9: Graphical User Interface Design for Engineers and Scientists

  • Developing engineering and science oriented GUI's and applications in Excel
  • Drawing engineering and science oriented graphics on the worksheet
  • Importing engineering and science oriented graphics into Excel
  • Creating graphics that display engineering and scientific data on the worksheet
  • Assigning VBA Sub procedures to worksheet based graphics
  • Using ActiveX and Form controls to create engineering and scientific GUI’s on the worksheet
  • Creating event procedures for controls placed on a worksheet
  • Controlling key Excel objects with VBA
  • Wizard overview for engineers and scientists
  • Using userforms to create wizards
  • Creating userforms in Excel
  • Creating controls and graphics on userforms
  • Commanding userforms and controls with VBA
  • Wizard design tips
  • Creating toolbars and menus to control your Excel engineering and scientific tools
  • Controlling Excel’s toolbar and menu system with VBA
  • Automating engineering and scientific chart construction with VBA

Module #10: FORTRAN/VBA Mixed Language Programming

  • Why should engineers and scientists develop FORTRAN DLL’s
  • How VBA locates and communicates with a FORTRAN DLL
  • FORTRAN DLL calling conventions from VBA
  • Why use Excel as a pre/post processor for FORTRAN DLL's
  • FORTRAN DLL design tips (using old FORTRAN code and writing new code)
  • Designing VBA procedures to communicate with FORTRAN DLL's
  • How to build a FORTRAN DLL in Digital Visual FORTRAN
  • How to debug a FORTRAN DLL
  • How to manage FORTRAN DLL files
  • Note C and ActiveX DLL discussion included
  • Note module 10 applies to Excel 97 and beyond

Module #11: Team Linking in Excel

  • Integrating teams and information using workbook links
  • Creating/managing linked workbooks on a single computer and network
  • Linked workbook distribution techniques
  • Controlling linked workbooks with VBA
  • Engineering and scientific uses of Excel’s shared workbook feature
  • Construction techniques for shared workbooks
  • Shared workbook operational procedures

Module #12: Packaging Applications in Excel

  • Storing and distributing Excel based tools in various Excel file types
  • Constructing verified, standardized engineering and scientific tools in Excel
  • Packaging/distributing engineering and scientific tools in workbook files
  • Engineering and scientific uses of Add-Ins and workbook templates
  • Constructing/packaging/distributing engineering and scientific tools in templates
  • Constructing/packaging/distributing engineering and scientific tools in Add-Ins
  • Distributing/maintaining Excel engineering and scientific tools on networks
  • Engineering and scientific procedure library design (i.e. rapid prototyping and analysis)
  • Developing security for Excel based software

Module #13: Processing Engineering and Scientific Data in Excel

  • Creating and managing tables in Excel
  • Sorting engineering and scientific data using the auto filter, sort and data form tools
  • Vital worksheet functions for engineering and scientific information processing
  • Importing engineering and scientific data using the Text Import Wizard
  • Integrating engineering and scientific applications using Automation/Dynamic Data Exchange (DDE)
  • Communicating with engineering and scientific databases via MS Query and ODBC
  • Commanding MS Query using DDE and VBA
  • Communicating with engineering and scientific databases using the ODBC functions
  • Overview of using DAO to communicate with engineering and scientific databases

Module 14: VBA / ActiveX DLL Programming

  • Object and class review

  • Practical uses of objects

  • Object method and properties overview

  • VB project overview for ActiveX DLL's

  • How to create an ActiveX DLL

  • Creating and naming your class modules

  • Designing object properties

  • Designing object methods

  • Designing object enums

  • Designing object hierarchies

  • How to reference your ActiveX DLL's from a VBA or VB project and distribute them

  • How to create and run your objects from Visual Basic

  • How to create and run your objects from VBA via Microsoft Excel

  • How to package and distribute your Active X DLLs

Module #15: Design Optimization in Excel Using Solver

  • Overview of design optimization
  • How to layout an optimization problem in Excel
  • Command and control worksheet overview
  • How to drive multiple workbooks using Solver
  • How to run VBA and FORTRAN while using Solver
  • How to use Solver in Microsoft Excel

Module #16: Constructing Large System Models in Excel 

  • How to determine your model equations and how they interact with each other
  • Using Excel’s structure to organize system teams
  • Laying out the system model in Excel
  • Library workbook introduction and design
  • Single and multi-workbook system model layout

Module #17: Microsoft Excel Updates

  • Important upgrade and how to information for Excel XP and 2003

Module #18: Windows On-Line Help Design

  • On-line help structure and content overview
  • How to create the files necessary to create on-line help
  • How to compile a Windows help file
  • How to display a Windows help file using VBA

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