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
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.