Excel is often mistakenly perceived simply as a business tool. This website provides an insight on how Excel software can be effectively utilised in a wide range of engineering applications. Engineering students typically use software like MATLAB or MATHEMATICA during their tertiary studies, and though in industry most engineers have access to Excel, utilization is generally limited to crunching out numbers and data storage.
As this site illustrates, Excel is a powerful and versatile tool that can be broadly adapted to supporting a wide variety of engineering functionality and complex numerical analysis applications.
A secondary objective of this site is to convey to the readers an appreciation for the understated beauty of mathematics in general, and numerical analysis in particular. Mathematics is like art - it challenges the mind and showcases the hidden capacity and beauty of the human imagination. Sadly, mathematics is often taught in a morbidly technical manner that swiftly creates a lingering dread of the subject matter within the mind of the students.By demonstrating how "difficult" mathematics can be performed by simple operations within the rows and columns (matrix) of a spreadsheet, it is hoped that at least a part of the loathing will disappear, and greater interest and confidence in learning created. The "Engineering Mathematics" section on the Apps page shows how topics like algebra and calculus can be readily understood with the aid of a spreadsheet.
Most of the Apps on this site have been built using Microsoft Excel 2003. They will also work in Excel 2007 and Excel 2010. All the files on the Apps Section of this site are free to download, advanced versions of some apps are available for purchase at the App Store.
Special thanks to all those visitors who have actively provided feedback to this site over the years. Some have also shared their case study/application specifics, and this has usually been featured at one or more locations within this site. In the interest of continuous improvement of the site, services and available products, I urge the readers to please keep the feedback coming, as appropriate, on email firstname.lastname@example.org.
You are also welcome to join the open Linked-in group Engineering Using Spreadsheets where you can share your experiences with Excel and give feedback on the site. Information on site updates will be featured in that group.
Featured: Animation Using Excel
This video shows various Excel animation techniques demonstrated on this site. The following apps have been featured in this video:
A 2nd order Butterworth Filter removes high frequency noise from the input. See the Filter Analysis App.
See more screenshots in Gallery.