Data Science Tutorials

Learn how the SUBTOTAL() function dynamically summarizes filtered or grouped data. Understand its syntax, explore practical examples, and compare it with similar functions.

Discover XMATCH, a powerful Excel function to find the relative position of an item that matches a specified value.

The triangle inequality is more than just a geometric principle - it's a cornerstone of distance measures in data science. Discover how this elegant mathematical concept powers algorithms across computational geometry, optimization, and machine learning.

Say goodbye to complex nested IF() logic. Learn how to build readable formulas using the IFS() function instead.

Master Docker Compose for efficient multi-container application development. Learn best practices, scaling, orchestration, and real-world examples.

Learn why the #NAME? error occurs in Excel formulas and discover practical steps to troubleshoot, fix, and prevent it for smoother spreadsheet workflows.

Learn how to build an Android app that uses Google's Gemma 3n to answer questions about images directly on your phone, without needing a cloud connection.

Explore Claude Sonnet 4’s developer features—code execution, files API, and tool use—by building a Python-based math-solving agent.

Plan, build, test, and deploy a machine learning project from scratch using the Claude Opus 4 model with Claude Code.

Learn how to add numbers in Excel using built-in tools. Explore multiple methods for quick calculations, including formulas, keyboard shortcuts, and table formatting.

Learn how to use Veo 3 to create a spec ad, maintain character consistency across different shots, and gain modular control with the Ingredients feature.

Learn how to use Devstral with Mistral Inference locally and with OpenHands using the Mistral AI API.