Machine Learning Reference Spreadsheet | 23 Algorithms Live Examples | Excel Recommender for Data Science

Machine Learning Reference Spreadsheet is a comprehensive, no-code workbook that walks data science students, bootcamp learners, and analysts through 23+ major ML algorithms - each one explained in plain English and computed live with real Excel formulas, so you understand the math without writing a single line of code.

WHAT'S INCLUDED

- 23+ algorithm tabs (Naive Bayes, Logistic Regression, KNN, Decision Tree, Random Forest, Gradient Boosting, SVM, Lasso, Ridge, K-Means, DBSCAN, PCA, ICA, Apriori, Isolation Forest, Q-Learning, and more) - each on its own dedicated sheet
- Plain-English intuition for every algorithm: what it does, when to use it, and when NOT to use it
- Assumptions and gotchas listed per algorithm so you avoid common modelling mistakes
- Live worked numeric example per algorithm driven entirely by Excel formulas - change the inputs and watch the math update instantly
- Interactive Recommender tab: answer a few questions about your problem and it ranks the best algorithms for you
- Decision flowchart by problem type (classification, regression, clustering, dimensionality reduction, anomaly detection) to guide your thinking
- Index tab for fast navigation across the full workbook

HOW IT WORKS

1. Purchase and download the Excel file instantly from Etsy.
2. Open in Microsoft Excel or Google Sheets - no macros, no plugins needed.
3. Start at the Index or How to Choose tab to orient yourself.
4. Open any algorithm tab, read the intuition, review the assumptions, then edit the live example inputs.
5. Use the Recommender to get a ranked shortlist of algorithms for your specific problem.

WHO IT'S FOR

- Data science bootcamp students who want to cement concepts beyond lecture slides
- Analysts and BI professionals who need to choose the right algorithm for a project without a CS degree
- Professionals preparing for machine learning interviews who need a quick, structured review of every major method
- Curious spreadsheet users who want to see ML math demystified in a tool they already know

FILE & COMPATIBILITY

Works in Microsoft Excel (Windows and Mac) and Google Sheets. No software subscription, no macros, and no coding required. The file is fully reusable - yours to keep and reference any time.

INSTANT DOWNLOAD

This is a digital download delivered instantly via Etsy after purchase. Nothing is physically shipped. Licensed for personal and educational use.

FAQ

Q: Do I need Excel to use this?
A: No. It works in both Microsoft Excel and Google Sheets, which is free.

Q: Can I edit the example data?
A: Yes - all input cells are editable and formulas recalculate automatically.

Q: Is this reusable?
A: Absolutely. Download once and reference it as many times as you like.

Q: Does it work on a Mac or phone?
A: Yes on Mac via Excel or Google Sheets; Google Sheets also works on mobile browsers.

Explore the rest of the SimpleDesign shop for more spreadsheet tools built to make complex topics approachable.