Data Science Tutorials

The SUMIFS() function in Excel sums values that meet multiple criteria, making it useful for conditional calculations with numbers, dates, and text. Learn to use SUMIFS() with syntax, examples, and best practices.

Learn how to install and use Google’s Gemini Code Assist in Visual Studio Code, with Python examples.

Learn how to use .gitignore to keep your Git repository clean. This tutorial covers the basics, common use cases, and practical examples to help you get started!

Learn how to connect to the OpenAI API, create an API key, set up a Python environment, and build a basic chatbot using GPT-4.5.

Learn how to use Anthropic's Claude Code to improve software development workflows through a practical example using the Supabase Python library.

Learn to create clear and informative line graphs in Excel. This guide walks you through each step, from setting up your data to customizing the graph for better readability.

Learn how to build an Agentic RAG pipeline from scratch, integrating local data sources and web scraping to generate context-aware responses to user queries.

Learn everything you need to know about the merge sort operation in Python and how to implement this critical algorithm for sorting large databases.

Learn how to construct and implement Convolutional Neural Networks (CNNs) in Python with PyTorch.

Explore the AI-powered IDE with features like Cascade, Supercomplete, and Memories, designed to boost developer productivity using the AI flow.

Learn how to generate images using Google’s Imagen 3 API with Python, including setting up your environment and adjusting options like aspect ratio and safety filters.

Learn to subtract cells, columns, rows, and more in Excel using the minus sign, cell references, absolute references, and even by using the `SUM()` or SUMPRODUCT() functions.