Kardi Teknomo Kardi Teknomo
Kardi Teknomo Kardi Teknomo Kardi Teknomo

Visit Tutorials below:
Adaptive Learning from Histogram
Adjacency matrix
Analytic Hierarchy Process (AHP)
ArcGIS tutorial
Arithmetic Mean
Bayes Theorem
Bootstrap Sampling
Bray Curtis Distance
Break Even Point
Chebyshev Distance
City Block Distance
Conditional Probability
Continued Fraction
Data Analysis from Questionnaire
Data Revival from Statistics
Decimal to Rational
Decision tree
Difference equations
Digital Root
Discriminant analysis
Eigen Value using Excel
Euclidean Distance
Euler Integration
Euler Number
Excel Iteration
Excel Macro
Excel Tutorial
Factorial Function
Feasibility Study
Financial Analysis
Generalized Inverse
Generalized Mean
Geometric Mean
Ginger Bread Man and Chaos
Graph Theory
Growth Model
Hamming Distance
Harmonic Mean
Hierarchical Clustering
Independent Events
Incident matrix
Jaccard Coefficient
Kernel basis function
Kernel Regression
k-Means clustering
K Nearest Neighbor
LAN Connections Switch
Learning from data
Lehmer Mean
Linear Algebra
Logarithm Rules
Mahalanobis Distance
Market Basket Analysis
Mean Absolute Deviation
Mean and Average
Mean, median, mode
Minkowski Distance
Minkowski Mean
Monte Carlo Simulation
Multi Agent System
Multicriteria decision making
Mutivariate Distance
Newton Raphson
Non-Linear Transformation
Normalization Index
Normalized Rank
Ordinary Differential Equation
Page Rank
Power rules
Prime Factor
Prime Number
Q Learning
Quadratic Function
Queueing Theory
Rank Reversal
Recursive Statistics
Regression Model
Reinforcement Learning
Root of Polynomial
Scenario Analysis
Sierpinski gasket
Sieve of Erastosthenes
Similarity and Distance
Solving System Equation
Standard deviation
String Distance
Summation Tricks
Support Vector Machines
System dynamic
Time Average
Tower of Hanoi
Vedic Square
Visual Basic (VB) tutorial
What If Analysis

Numerical Microsoft Excel Tutorials

by Kardi Teknomo

Share this: Google+

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 my other tutorials


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 best-fit 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 non-linear inequality equation

Zeros of Non-linear equation

Steps by step procedure to obtain zeros of non-linear 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).

K-Nearest 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 Runge-Kutta 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 state-diagram 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 ...

Share and save this tutorial

Share |

See also :

Rate these tutorials and send your feedback

All of these tutorials are copyrighted

© 2015 Kardi Teknomo. All Rights Reserved.