MATLAB Resources

MATLAB TK Solver EES Excel VBA

Return to Math Modeling home

Excel is a spreadsheet application for graphing tools, calculation and data analysis. Its been widely used in statistical and financial analysis

 

Learning Modules and Sample Programs

Excel Basics Video Reference Website Reference
Accessing the software   Available through Microsoft Office
WorkBook Video Resrource
WorkSheet Video Resource
Cell Formatting Video Resource
Find and Select   Resource
More Data and Text editing   Resource
Text Formatting   Resource
Functions Video Reference Website Reference
Formulas, Count and  Sum Video Resource
Logical functions   Resource
Cell Reference   Resource
Date, Time   Resource
Array Formula   Resource
Data Analysis Video Reference Website Reference
Sorting Video Resource
Filter Video Resource
Conditional Filtering Video Resource
Charts Video Resource
Tables Video Resource
Pivot Tables Video Resource
Solver   Resource
Excel / VBA Examples   Resource