One of the most frequent uses of Excel is to work with data and plotting the results. This hands-on workshop is designed to dramatically increase your ability to use Excel and VBA to more effectively support your data plotting and analysis process. Frequently, this process can become limited when working with worksheets, worksheet functions and worksheet wizards. By using VBA, you can get more complete control over the plotting and data analysis features of Excel. This requires that you become familiar with the Excel Charting Object Model and the associated properties, methods and events. The methods taught in this workshop are particularly helpful for those working with large data sets, repetitive data analysis and plotting, plotting results of computational intensive calculations, plotting filtered or smoothed data, and specialized plotting styles which are not part of the standard style set available in the Chart Wizard. In addition, the participants at this workshop will be among the first to learn the features of XLProPlot, the new SpreadsheetWorld toolbox designed especially for engineering use. We encourage participants to bring their plotting and data analysis projects to the workshop for class discussion and class projects. Each participant receives a free copy of the premier data plotting application, XLProPlot and a set of course materials. It is accompanied by a CD-ROM containing an electronic version of the course notes; both generic and discipline-specific course exercises; in-depth engineering case studies; the Professional Version of the SpreadsheetWorld Toolbox Manager, and several SpreadsheetWorld Toolboxes.
Matthew E. Moran, PE is a Senior Engineer at NASA, and an
instructor in the graduate school at Walsh University.
He has 27 years experience
developing products and systems for aerospace,
electronics, military, and power generation applications.
He has created Excel/VBA thermal & fluid system models
for the Air Force, Office of Naval Research, Missile
Defense Agency, NASA, and other organizations. Matt is
Professional Engineer (Ohio), with a B.S. & graduate work
in Mechanical Engineering, and an MBA in Systems
Management. He has published 37 papers, and has 2
patents and 3 patents pending, in the areas of thermal
systems, cryogenics, MEMS/microsystems, power
generation systems, and electronics cooling.