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.

 Development of prototype multi agent simulation using only spreadsheet. Simple example of race of agents. 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 best-fit 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 non-linear inequality equation Steps by step procedure to obtain zeros of non-linear 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. Learn simple matrix theory on how to obtain symmetric matrix from any matrix. Have fun with Excel to produce fractal shape of Seipinski gasket Practical approach to solve Ordinary Differential Equation numerically using Euler and Runge-Kutta method Learn about Chaos and having fun with Excel to produce Chaotic Shape of Ginger Bread Man Step by step state-diagram 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 :