Execute MATLAB Functions in Microsoft Excel

Executing Spreadsheet Link Functions

Learn about different Spreadsheet Link™ function types, execution methods, and how to specify arguments to execute MATLAB functions.

Create Diagonal Matrix Using Microsoft Excel Ribbon

Export data in a named range of a worksheet, execute a MATLAB function using the Microsoft Excel ribbon, and import results into Microsoft Excel.

Create Diagonal Matrix Using Microsoft Excel Context Menu

Export data in a named range of a worksheet, execute a MATLAB function using the Microsoft Excel context menu, and import results into Microsoft Excel.

Create Diagonal Matrix Using Worksheet Cells

Export data in a named range of a worksheet, execute a MATLAB function using Microsoft Excel worksheet cells, and import results into Microsoft Excel.

Create Diagonal Matrix Using VBA Macro

Export data in a named range of a worksheet, execute a MATLAB function using a Microsoft Excel VBA macro, and import results into Microsoft Excel.

Return Multiple Output Arguments from MATLAB Function

Calculate the singular value decomposition of a matrix using a Microsoft Excel VBA macro.

Execute MATLAB Functions Using Real Data

Model Data Using Regression and Curve Fitting

Build a mathematical model of a data set, organize the data, and display it using a Microsoft Excel worksheet.

Interpolate Thermodynamic Data

Interpolate, organize, and display data using a Microsoft Excel worksheet.

Price Stock Options Using Binomial Model

Price options and build a binomial tree in a Microsoft Excel worksheet.

Plot Efficient Frontier of Financial Portfolios

Analyze three portfolios using rates of return for six time periods in a Microsoft Excel worksheet.

Map Time and Bond Cash Flows

Determine a set of cash flow amounts and dates given a portfolio of five bonds in a Microsoft Excel worksheet.

Execute MATLAB Functions Using MATLAB Function Wizard

Find and Execute MATLAB Function Using MATLAB Function Wizard

Find a MATLAB function, select a function signature, specify arguments, and execute the function using the MATLAB Function Wizard.

Find Custom MATLAB Function Using MATLAB Function Wizard

Write a custom MATLAB function and find it using the MATLAB Function Wizard.