File Exchange

image thumbnail

Data Analysis with MATLAB for Excel Users

version (350 KB) by

Materials for public seminar of the same name (slides and demos)



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.

Comments and Ratings (13)

very good

zaoui fares

zaoui fares

 very good

Shoeb Sayeed


muk (view profile)

haider daod

hellow can u help me plz i want to download this file can u send it to my mail thanx (file.m) mppt + photovoltaic

zied trabelsi

(file.m) mppt + photovoltaic

zied trabelsi

(file.mdl)for optimal inclination of photovoltaic panel and monthly solar irradiance

zied trabelsi

(file.m) for optimal inclination of photovoltaic panel and monthly solar irradiance

Peng Zhang

Peter Sheppard

Thankyou for making the material available

Marc Pelletier

melanie vanloocke


Updated license


Removed dead link.


Updated some comments in the files. No code changes.


Cleaned up some text.


Updated copyright notices.

MATLAB Release
MATLAB 7.4 (R2007a)

Inspired: PV Panel Modeling

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video

MATLABforExcel/MATLABforExcel/Excel Demo 1/EnergyGUI/

MATLABforExcel/MATLABforExcel/Excel Demo 1/

MATLABforExcel/MATLABforExcel/Excel Demo 1/other/

MATLABforExcel/MATLABforExcel/Excel Demo 2/

MATLABforExcel/MATLABforExcel/Excel Demo 3/

MATLABforExcel/MATLABforExcel/Excel Demo 1/html/