Share this: Google+
Excel Tutorials
Microsoft Excel is a very powerful software. The tutorials below introduce you with some MS Excel power to solve problem numerically with or without programming.
If you like these free online learning material, link this page from your homepage, tell your friends. If you write any papers or publications or even web sites based on the open course in this web site, please refer to the appropriate reference for each material. I would really appreciate this because you help others to find this page easier.
Click here to check other tutorials
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

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

Factoring a number by its prime factors using MS Excel iteration. Free download 
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

Solve regression using generalized inverse matrix in MS Excel 
Solve Tower of Hanoi solitary game using iteration in MS Excel 
Using MS Iteration to solve one of the most famous numerical methods finding root of equation 
Solving inverse problem single unknown variable using Goal Seek tool 
You can actually do many interactive simple programs in MS Excel without VBA macro. See how it works in this tutorial 
Simple explanation on how to determine product price based on break even point 
Finding the range of solution for nonlinear inequality equation 
Steps by step procedure to obtain zeros of nonlinear equation using MS Excel Goal seek 
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 
Example to compute Distance matrix from combination of categorical, binary, rank, and quantiative variables 
Demonstrate how to make Monte Carlo Simulation based on the observation data 
Learn the basic of simulation and how to perform Simulation in MS Excel. 
Advance Monte Carlo method to obtain sampling distribution of an estimator from non parametric sample. 
Numerical example of K means clustering using iteration (no macro). 
Supervised learning for data mining and statistical pattern recognition. 
Unleash the power of MS Excel by writing your own function 
Simplify your job using matrix multiplication to rotate many points simultaneously without typing the formula for each point. 
Tutorial on how to use Inverse matrix and matrix multiplication in MS Excel. 
Finding root of cubic polynomial equation using Goal seek tool 
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. 
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 
Learn about Chaos and having fun with Excel to produce Chaotic Shape of Ginger Bread Man 
Step by step statediagram learning theory by examples 
Interesting relationship of various average such as geometric mean, harmonic mean, and quadratic mean and arithmetic mean, time average, moving average and fundamental relationship 
Statistical concepts about central tendency (Mean, Median, and Mode) and variation of data (Range, Variance and Standard Deviation) 
How do we obtain approximation ratio of a real number? Take a look on this interesting tutorial. 
Find a fitting function that is smooth and approximate your data locally

Explore the characteristics of quadratic function and parabola curve 
Simple example of what if analysis by creating data table with one input variable and two input variables. 
It will cluster your data better 
More tutorials ... 
See also :
Rate these tutorials and send your feedback
All of these tutorials are copyrighted