FormulaML Documentation

FormulaML brings the power of machine learning directly into Excel through simple, intuitive formulas. No programming experience required.

What is FormulaML?

FormulaML is an Excel add-in that enables you to:

• Build machine learning models using familiar Excel formulas
• Work with your existing Excel data seamlessly
• Create predictions and insights without leaving Excel
• Access professional ML algorithms through simple functions

All FormulaML functions start with the ML. prefix, making them easy to find and use.

Quick Navigation

🚀 New to FormulaML?

Start with our Getting Started Guide to learn the basics and create your first model in minutes.

📊 Working with Your Data

Learn how to prepare and explore your data using FormulaML’s data handling functions.

🤖 Building Models

Explore available models and algorithms for regression, classification, and clustering tasks.

📈 Evaluating Performance

Understand how to evaluate your models and interpret results for business decisions.

💡 Learn by Example

Browse our examples and tutorials for step-by-step workflows using real datasets.

⚡ Advanced Techniques

Discover advanced features like pipelines, preprocessing, and dimensionality reduction.

📖 Function Reference

Find detailed documentation for all FormulaML functions organized by category.

🛠️ Tips & Troubleshooting

Get help with common issues and best practices in our tips and troubleshooting guide.

Free vs Premium Features

FormulaML offers both free and premium features:

✅ Free Features Include:

• Core ML algorithms (Linear Regression, Logistic Regression, K-Means, SVM)
• Built-in datasets for learning (Iris, Diabetes, Digits)
• Basic model training and prediction
• Data exploration and visualization tools
• Essential preprocessing functions

⭐ Premium Features Include:

• Advanced algorithms (Random Forest, Elastic Net)
• Cross-validation and hyperparameter tuning
• Advanced preprocessing and feature engineering
• Custom dataset loading from OpenML
• Priority support and updates

Getting Help

• Quick Start: Begin with our Getting Started Guide
• Function Lookup: Use the Function Reference for syntax and parameters
• Examples: Check our Tutorials for complete workflows
• Support: Contact support@formulaml.com for assistance

Understanding Object Handles

FormulaML uses “object handles” to manage complex data and models in Excel. Think of these as references that allow Excel to work with machine learning objects efficiently. You’ll see these as values like <Dataset> or <LinearRegression> in your cells. Trained models show a 🧠 brain icon to distinguish them from untrained models. Don’t worry - we’ll explain how to use them effectively in the Getting Started Guide.

Ready to Begin?

Start your machine learning journey in Excel:

1. Install FormulaML - Get the add-in up and running
2. Learn the Basics - Understand core concepts
3. Try an Example - Follow a complete tutorial
4. Build Your Model - Apply ML to your own data

Welcome to the world of machine learning in Excel with FormulaML!