In their fields of specialty, Engineers are constantly challenged with solving a wide range of complex analytical and computational problems. These problems involve analysis methodologies and the management of data. The application of computers enables repetitive, time-consuming and often tedious calculations to be conducted rapidly, efficiently, and less prone to errors. The application of computer tools also enables the results and outputs of such engineering analyses to be readily transferred and incorporated into reports and other engineering documents. An even greater advantage - in terms of productivity and efficiency - is realized when these calculations and outputs are replicated across numerous projects. Competence in computer skills predisposes engineers to pursue and develop more creative and innovative solutions to problems.
Microsoft Excel is an electronic spreadsheet program developed by the Microsoft company, and is part of the software products. A spreadsheet is a grid that organizes data and calculations into columns and rows. The intersection of a column and a row is called a cell. An electronic spreadsheet enables users to store, organize, manipulate, and analyze data in the cells of the spreadsheet. As of this publication, the software is into the 2016 release.
Microsoft Excel is widely and increasingly being used as a tool to assist engineers in conducting and replicating intricate calculations and analysis, designing complex systems, and managing large data sets. This course presents a selection of engineering analysis topics and how to formulate, implement and solve them in Microsoft Excel.
This course presents fundamental principles and engineering applications of problems in linear algebra, and demonstrates the Excel tools, methods, and strategies that can be used to formulate and solve them.
Upon completion of this course, participants will have gained insight into applying Excel tools, methods, and strategies in analyzing, formulating and implementing a variety of engineering related problems, as well as managing large sets of complex data. Participants will also be able to identify professional situations where the application of innovative Excel techniques will be of great benefit and advantage, and will enable practitioners to significantly improve their productivity, efficiency, and the quality of their work product.