Modelling, Artificial Intelligence and Simulation using Microsoft Excel

I am beginning to consider myself very lucky to know Excel extremely well. 
Why? It's because all the good books I have on data analysis and predictive analytics teach using Excel. I have been learning the following -

• Probability theory
• K-Means clustering
• K-Median clustering
• Cosine Similarity
• Naive Bayes
• Optimization Modelling
• Linearizing nonlinear models
• Linear Regression
• Nonlinear Regression
• Network Graph
• Exponential Smoothing
• Turkey Fences

 

image: en.wikipedia.org

Some also touch on implementation on R and I have one that is completely on R, but the ones I found easiest to follow for a non-statistic guy like me use Excel.

I have learned how to build a model that can intelligently classify things into specified categories. I will soon be using it in a long-term work I do for a client. It will save us hours of manual classification of thousands of user feedback.

I have also learned how to break down a business problem into a robust model in Excel that can be used for simulating real business situations/decisions.

I also learned many use cases that are not yet relevant for me now but may be in the future when I meet a client with a special need.

Microsoft Excel is extremely versatile and powerful. I have seen people build complex games with it; games with sound, movement controls and characters. It's more like an enabler, once you can mathematically think out what you want to do, Excel will help you do it.