Category: excel
-
The Machine Learning “Advent Calendar” Bonus 2: Gradient Descent Variants in Excel
The Machine Learning “Advent Calendar” Bonus 2: Gradient Descent Variants in Excel Gradient Descent, Momentum, RMSProp, and Adam all aim for the same minimum. They do not change the destination, only the path. Each method adds a mechanism that fixes a limitation of the previous one, making the movement faster, more stable, or more adaptive.…
-
The Machine Learning “Advent Calendar” Day 17: Neural Network Regressor in Excel
The Machine Learning “Advent Calendar” Day 17: Neural Network Regressor in Excel Neural networks often feel like black boxes. In this article, we build a neural network regressor from scratch using only Excel formulas. By making every step explicit, from forward propagation to backpropagation, we show how a neural network learns to approximate non-linear functions…
-
Separate Numbers and Text in One Column Using Power Query
Separate Numbers and Text in One Column Using Power Query An Excel sheet with a column containing numbers and text? What a mess! The post Separate Numbers and Text in One Column Using Power Query appeared first on Towards Data Science. Salvatore Cagliari Go to original source
-
The Machine Learning “Advent Calendar” Day 15: SVM in Excel
The Machine Learning “Advent Calendar” Day 15: SVM in Excel Instead of starting with margins and geometry, this article builds the Support Vector Machine step by step from familiar models. By changing the loss function and reusing regularization, SVM appears naturally as a linear classifier trained by optimization. This perspective unifies logistic regression, SVM, and…
-
The Machine Learning “Advent Calendar” Day 10: DBSCAN in Excel
The Machine Learning “Advent Calendar” Day 10: DBSCAN in Excel DBSCAN shows how far we can go with a very simple idea: count how many neighbors live close to each point. It finds clusters and marks anomalies without any probabilistic model, and it works beautifully in Excel. But because it relies on one fixed radius,…
-
The Machine Learning “Advent Calendar” Day 4: k-Means in Excel
The Machine Learning “Advent Calendar” Day 4: k-Means in Excel How to implement a training algorithm that finally looks like “real” machine learning The post The Machine Learning “Advent Calendar” Day 4: k-Means in Excel appeared first on Towards Data Science. angela shi Go to original source
-
The Machine Learning “Advent Calendar” Day 1: k-NN Regressor in Excel
The Machine Learning “Advent Calendar” Day 1: k-NN Regressor in Excel This first day of the Advent Calendar introduces the k-NN regressor, the simplest distance-based model. Using Excel, we explore how predictions rely entirely on the closest observations, why feature scaling matters, and how heterogeneous variables can make distances meaningless. Through examples with continuous and…
-
Understanding Convolutional Neural Networks (CNNs) Through Excel
Understanding Convolutional Neural Networks (CNNs) Through Excel Deep learning is often seen as a black box. We know that it learns from data, but we rarely stop to ask how it truly learns. What if we could open that box and watch each step happen right before our eyes? With Excel, we can do exactly…
-
Generating Data Dictionary for Excel Files Using OpenPyxl and AI Agents
Generating Data Dictionary for Excel Files Using OpenPyxl and AI Agents Introduction Every company I worked for until today, there it was: the resilient MS Excel. Excel was first released in 1985 and has remained strong until today. It has survived the rise of relational databases, the evolution of many programming languages, the Internet with…
-
Think you Know Excel? Take Your Analytics Skills to the Next Level with Power Query!
Think you Know Excel? Take Your Analytics Skills to the Next Level with Power Query! 5 practical use cases that prove Power Query is worth exploring. I have a confession to make: I’ve been living under a rock 🪨. Not literally, but how else can I explain not discovering Power Query in Excel until now? Imagine…