Multiagent System
Development of prototype multi agent simulation using only spreadsheet. Simple example of race of agents.

Nearest Neighbor Interpolation
Nearest Neighbor algorithm for smoothing and prediction of time series data

Market Basket Analysis
Business Intelligence method to discover association rules from transaction data of a store



Prime Factor
Factoring a number by its prime factors using MS Excel iteration. Free download 
Regression Model
Learn how to model you data, find the bestfit model and use graph, functions and Add Ins wizard in MS excel to automate the regression

Generalized Inverse
Solve regression using generalized inverse matrix in MS Excel 
Tower of Hanoi
Solve Tower of Hanoi solitary game using iteration in MS Excel

Newton Rhapson
Using MS Iteration to solve one of the most famous numerical methods finding root of equation 
Goal Seek
Solving inverse problem single unknown variable using Goal Seek tool

Excel Iteration
You can actually do many interactive simple programs in MS Excel without VBA macro. See how it works in this tutorial 
Break Event Point
Simple explanation on how to determine product price based on break even point

Solving Inequality
Finding the range of solution for nonlinear inequality equation 
Zeros of Nonlinear equation
Steps by step procedure to obtain zeros of nonlinear equation using MS Excel Goal seek

Discriminant Analysis
Many people disbelieve that you can do pattern classification and machine learning in MS excel without any programming or macro. Check how to do it in this tutorial 
MultiVariate Distance Matrix
Example to compute Distance matrix from combination of categorical, binary, rank, and quantiative variables

Observation Based Simulation
Demonstrate how to make Monte Carlo Simulation based on the observation data 
Monte Carlo Simulation
Learn the basic of simulation and how to perform Simulation in MS Excel.

Bootstrap Sampling
Advance Monte Carlo method to obtain sampling distribution of an estimator from non parametric sample.

K means clustering
Numerical example of K means clustering using iteration (no macro).

KNearest Neighbor Algorithm
Supervised learning for data mining and statistical pattern recognition.

Write your own Excel Function
Unleash the power of MS Excel by writing your own function

Simulatenous Rotation
Simplify your job using matrix multiplication to rotate many points simultaneously without typing the formula for each point. 
Solving System equations
Tutorial on how to use Inverse matrix and matrix multiplication in MS Excel.

Root of Polynomial
Finding root of cubic polynomial equation using Goal seek tool 
Finding Eigen Value
Using MS excel Goal seek to find eigen value of a symmetric matrix.

Symmetric matrix from any matrix
Learn simple matrix theory on how to obtain symmetric matrix from any matrix. 
Sierpinski Gasket
Have fun with Excel to produce fractal shape of Seipinski gasket 
Ordinary Differential Equation
Practical approach to solve Ordinary Differential Equation numerically using Euler and RungeKutta method

Ginger Bread Man
Learn about Chaos and having fun with Excel to produce Chaotic Shape of Ginger Bread Man 
Q Learning
Step by step statediagram learning theory by examples

Mean and Average
Interesting relationship of various average such as geometric mean, harmonic mean, and quadratic mean and arithmetic mean, time average, moving average and fundamental relationship

Learning from Data
Statistical concepts about central tendency (Mean, Median, and Mode) and variation of data (Range, Variance and Standard Deviation) 
Convert Decimal to Rational
How do we obtain approximation ratio of a real number? Take a look on this interesting tutorial. 
Kernel Regression
Find a fitting function that is smooth and approximate your data locally

Quadratic Function
Explore the characteristics of quadratic function and parabola curve 
Data Table
Simple example of what if analysis by creating data table with one input variable and two input variables.

More tutorials ... 
