Machine Learning in Excel: How Models Really Work
Scaling, regression, gradient descent, logistic regression, precision/recall, kNN, k-means and decision trees, computed cell by cell on small data, so you see what Python libraries do inside.
Machine learning is easier to understand when you can see every number. These AI and data science courses build the core algorithms cell by cell on small datasets, so you see exactly what a library such as scikit-learn or PyTorch computes when you call fit and predict. Nothing is hidden behind code, and every step is checked as you go.
Machine Learning in Excel splits and scales data, fits a linear regression with the normal equations, runs gradient descent by hand, scores a logistic regression, evaluates a classifier with a confusion matrix, precision, recall and F1, and covers k-nearest neighbours, k-means clustering and a decision-tree split with Gini impurity. Neural Networks by Hand builds a neuron, activation functions, a forward pass, loss functions, one backpropagation step, softmax and early stopping. Recommendation Systems & Text Analytics covers cosine similarity, user- and item-based collaborative filtering, evaluation with MAE, bag of words, TF-IDF and lexicon sentiment. The courses suit analysts and students who want to understand machine learning before they code it, and managers who need to judge model results. For the statistics underneath, Business Statistics & Regression and Probability & Combinatorics are good companions, and Forecasting & Time-Series Analysis covers prediction over time.
Scaling, regression, gradient descent, logistic regression, precision/recall, kNN, k-means and decision trees, computed cell by cell on small data, so you see what Python libraries do inside.
Neurons, activation functions, a full forward pass, loss, backpropagation, learning rates, softmax and early stopping, computed cell by cell so you see what PyTorch and TensorFlow do inside.
Ratings matrices, cosine similarity, user- and item-based collaborative filtering, MAE against a popularity baseline, bag of words, TF-IDF and lexicon sentiment, built cell by cell for one online bookshop.
Confusion matrix, precision and recall with an Excel example: TP, FP, FN and TN from COUNTIFS, then accuracy, F1, specificity and the threshold trade-off.
For learning, yes. Small datasets make every step visible, and the results match what Python libraries produce. For large data and production models you would use Python or R, but the maths is the same.
No. The courses use spreadsheet formulas only. Knowing basic Excel functions such as SUM, AVERAGE and SUMPRODUCT is enough.
School algebra is enough. Each lab explains the formula it uses, such as the sigmoid, Euclidean distance or Gini impurity, before you calculate it.
Free lessons work without an account. Sign up to save your progress.