Data Science Tutorials

A practical guide to using SUMPRODUCT() for conditional, weighted, and matrix-based calculations in Excel

Learn how to read, write, format, and automate Google Sheets using the API, with practical examples.

Build a data engineering MVP with GPT-5.2 Codex. A step-by-step VSCode tutorial covering agentic coding, Python, DuckDB, and Streamlit workflows.

Learn to install, configure, and use the new GitHub Copilot CLI agent. Master Ask, Edit, and Agent modes to automate workflows directly from your terminal.

Master Python shebangs to build executable scripts, maintain environment portability, and apply industry-standard best practices.

Learn what circular references are, why they cause problems, and how to fix them using simple and advanced techniques.

Learn how to build a citation-grounded Streamlit document Q&A assistant with Nemotron 3 Nano, using lightweight keyword retrieval and either local Ollama runs or Ollama Cloud inference.

Cut through the hype. Learn to interpret LLM benchmarks, navigate open leaderboards, and run your own evaluations to find the best AI models for your needs.

Learn how to use Gemini 3 Flash to create a UI Studio that assembles dashboards via tool calls, structured outputs, and rapid knob-based iteration.

Learn how Google Workspace Studio lets you create AI agents to automate workflows in Gmail, Drive, and Sheets with an easy, hands-on beginner tutorial.

Learn how to save uncommitted work when switching branches, then restore it later without losing any code.

Learn the capabilities of Runway Gen 4.5 and find out whether it really is the best text-to-video AI out there.