Data Analysis with MATLAB for Excel Users

Materials for public seminar of the same name (slides and demos)
Updated 1 Sep 2016

View License

Contains the slides and demos for the seminar entitled "Data Analysis with MATLAB for Excel Users", which was delivered on March 7th at the Newton Marriott in Newton, MA.
While a clever person could certainly make sense out of this material without having attended the seminar, it is designed to augment the live performance (not replace it). This means there are no detailed descriptions on how to run the various demos. Some of them require specific toolboxes to function.
Demo 1: Energy Prediction for a Power Plant -- Illustrates MATLAB's capabilities as a tool for data analysis. Shows features from MATLAB, Curve Fitting Toolbox, Statistics Toolbox, and Compiler.

Demo 2: Motor Noise Demo -- Illustrates two of MATLAB's integration methods with Excel including, Excel Link and Builder for Excel.

Demo 3: Introduction to MATLAB COM Interface -- shows the basics for using MATLAB as an activex client to connect to Excel. MATLAB can also be a server, though that is not shown here. The nice part about this section is nothing is required besides basic MATLAB.

Cite As

Michael Agostini (2024). Data Analysis with MATLAB for Excel Users (, MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2007a
Compatible with any release
Platform Compatibility
Windows macOS Linux

Inspired: EEG SIGNAL ANALYSIS , PV Panel Modeling


Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

MATLABforExcel/MATLABforExcel/Excel Demo 1/

MATLABforExcel/MATLABforExcel/Excel Demo 1/EnergyGUI/

MATLABforExcel/MATLABforExcel/Excel Demo 1/other/

MATLABforExcel/MATLABforExcel/Excel Demo 2/

MATLABforExcel/MATLABforExcel/Excel Demo 3/

MATLABforExcel/MATLABforExcel/Excel Demo 1/html/

Version Published Release Notes

Updated license

Updated some comments in the files. No code changes.
Removed dead link.

Cleaned up some text.

Updated copyright notices.