Claude in Excel: build models, dashboards and reports
What Claude actually does once it is inside a spreadsheet - real, one-shot builds from a practitioner's sheet, not demos.
- Claude in Excel Just One-Shotted an XGBoost Response Model - Train-Test Split, AUC, Full WorkupThe one that started it. A full ML model, built in the sheet.
- Claude in Excel Built a 50-Chart India Macroeconomic Dashboard from RBI Data in Under an HourFrom raw RBI data to a live dashboard, no manual charting.
- Claude in Excel - Nifty50 Return Distribution Analysis (30 Days Forward), 2008 to 2026Distribution analysis over 18 years of index data.
- NIFTY50 - 30-Day Forward Return Analysis, Feb 2008 to 2026 (Claude in Excel with Python, Lambda)Forward-return study built with Python + LAMBDA in the sheet.
The working guides: Excel, PowerPoint, what works
The how-to playbooks - Excel and PowerPoint tips, an honest "is it worth it", and how Claude in Excel stacks up against Python-in-Excel.
- Power User Guide to Claude in Excel & PowerPoint - 26 Working TipsThe tips list - what to do, what to avoid.
- Claude in Excel & PowerPoint - Is It Worth It? What Works and What Doesn't PDFHonest limits, not a sales pitch.
- Python in Excel - Claude vs xlwings Lite? Who Wins?When to reach for which.
- Claude in Excel + MCP + xlwings Lite + Claude Code: Pull Data, Build a Model, Validate ItThe four tools working together, end to end.
Pull live data into Excel: databases and quant metrics over MCP
Connect Claude in Excel to your databases and analytics backends over MCP, so numbers come straight into the sheet - no copy-paste, no export dance. Start with the setup guide.
- MCP Guide for Claude in Excel - and Any MCP Client PDFThe setup guide. Start here to wire Claude to your data.
- QREP in Excel: 81 Risk and Return Metrics Inside Your Sheet Through Claude in ExcelPortfolio quant metrics pulled live into Excel.
- Pull Your Quant Numbers Directly with Claude / ChatGPT in Excel (with MCP)The quants-in-a-sheet pattern.
- Talk to Your Database from Excel - Postgres, DuckDB - via Claude in Excel with MCPQuery millions of rows from inside Excel.
- Talk to Your Database from Excel via Claude & MCP - Part 2Deeper patterns and gotchas.
- Claude in Excel with MCP Connector - Talk to Your Backends from Inside ExcelUsing the MCP connector, step by step.
- Connect Excel to a Database with Tens of Millions of Rows? Tigzig Has 15+ Apps and GuidesThe full map of Excel-to-database options on the site.
Beyond Excel: Claude as a universal agent
Excel is one front end. The same Claude drives PowerPoint, files, databases, coding and analysis from one place - Cowork and Claude Code. Lighter reading, and the research behind why it works.
- Claude - The Universal Agent PDFThe thesis, as a slide deck.
- Claude Cowork and Claude Code Have Quietly Become My Universal Front EndHow the day-to-day workflow actually looks now.
- Claude Code: Top 10 Tips from Boris ChernyPractical Claude Code habits.
- What Decides Whether a Coding Session Succeeds? Anthropic Says Domain ExpertiseAnthropic's study on agentic coding and expertise.
- Claude Code Was Getting Dumber. Stopped It Auto-Spawning Sub-Agents. Performance Came BackA real fix from running it hard.
More: the MCP hub, APIs, security and the apps
The infrastructure behind all of this - the MCP servers and APIs Claude connects to, the apps built with Claude Code, and what Claude looks like on the security side.
- Tigzig MCP Hub - 7 MCP servers, browse and connect them allThe master directory. Connect any of these to Claude in Excel or Claude chat.
- APIs & open data - REST + MCP, single row or whole-database downloadThe data surface behind the tools.
- Security checklist for AI-coded analytics apps108-point checklist from building and running these apps.
- Claude the Hunter-Killer - Claude Runs a Penetration Test on Your Own SetupClaude on the offensive-security side.
- My Public MCP Server Got Hammered - Security Lessons from a Bot AttackWhat running a public MCP server actually teaches you.
- Browse all apps - built with Claude Code, most open source40+ analytics apps and tools, free.