# Claude for Analytics - in Excel, PowerPoint and Cowork Everything I have built and written on using Claude (Anthropic's AI) inside Excel and PowerPoint - and as a universal agent for day-to-day analyst work. One-shot models, 50-chart dashboards, pulling live database and quant data into a sheet over MCP, plus the setup guides and playbooks. By a practitioner. Free and open. Source: https://www.tigzig.com/ai-in-excel ## 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 Workup](https://www.tigzig.com/post/claude-in-excel) - The 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 Hour](https://www.tigzig.com/post/claude-in-excel-rbi-macroeconomic-dashboard) - From raw RBI data to a live dashboard, no manual charting. - [Claude in Excel - Nifty50 Return Distribution Analysis (30 Days Forward), 2008 to 2026](https://www.tigzig.com/post/claude-in-excel-nifty50-return-distribution-analysis) - Distribution analysis over 18 years of index data. - [NIFTY50 - 30-Day Forward Return Analysis, Feb 2008 to 2026 (Claude in Excel with Python, Lambda)](https://www.tigzig.com/post/nifty50-30-day-forward-return-analysis-claude-in-excel) - 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 Tips](https://www.tigzig.com/post/claude-in-excel-powerpoint-working-tips) - The tips list - what to do, what to avoid. - [Claude in Excel & PowerPoint - Is It Worth It? What Works and What Doesn't](https://www.tigzig.com/post/python-in-excel-with-claude-what-works-and-what-doesnt) [PDF] - Honest limits, not a sales pitch. - [Python in Excel - Claude vs xlwings Lite? Who Wins?](https://www.tigzig.com/post/python-in-excel-claude-vs-xlwings-lite) - When to reach for which. - [Claude in Excel + MCP + xlwings Lite + Claude Code: Pull Data, Build a Model, Validate It](https://www.tigzig.com/post/claude-in-excel-mcp-xlwings-lite-claude-code-combining-4-tools) - The 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](https://www.tigzig.com/post/mcp-guide-claude-in-excel) [PDF] - The setup guide. Start here to wire Claude to your data. - [QREP in Excel: 81 Risk and Return Metrics Inside Your Sheet Through Claude in Excel](https://www.tigzig.com/post/qrep-claude-in-excel-mcp-jun2026) - Portfolio quant metrics pulled live into Excel. - [Pull Your Quant Numbers Directly with Claude / ChatGPT in Excel (with MCP)](https://www.tigzig.com/post/qrep-mcp-quants-numbers-claude-chatgpt-excel) - The quants-in-a-sheet pattern. - [Talk to Your Database from Excel - Postgres, DuckDB - via Claude in Excel with MCP](https://www.tigzig.com/post/talk-to-your-database-from-excel-postgres-duckdb-claude-mcp) - Query millions of rows from inside Excel. - [Talk to Your Database from Excel via Claude & MCP - Part 2](https://www.tigzig.com/post/talk-to-your-database-from-excel-mcp-part-2) - Deeper patterns and gotchas. - [Claude in Excel with MCP Connector - Talk to Your Backends from Inside Excel](https://www.tigzig.com/post/claude-in-excel-mcp-connector-talk-to-backends) - Using the MCP connector, step by step. - [Connect Excel to a Database with Tens of Millions of Rows? Tigzig Has 15+ Apps and Guides](https://www.tigzig.com/post/tigzig-excel-to-databases-ai-find-jun2026) - The 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](https://www.tigzig.com/post/claude-the-universal-agent) [PDF] - The thesis, as a slide deck. - [Claude Cowork and Claude Code Have Quietly Become My Universal Front End](https://www.tigzig.com/post/working-with-claude-cowork-claude-code-jun2026) - How the day-to-day workflow actually looks now. - [Claude Code: Top 10 Tips from Boris Cherny](https://www.tigzig.com/post/claude-code-top-10-tips-from-boris-cherny) - Practical Claude Code habits. - [What Decides Whether a Coding Session Succeeds? Anthropic Says Domain Expertise](https://www.tigzig.com/post/anthropic-claude-code-expertise-survey-jun2026) - Anthropic's study on agentic coding and expertise. - [Claude Code Was Getting Dumber. Stopped It Auto-Spawning Sub-Agents. Performance Came Back](https://www.tigzig.com/post/claude-code-sub-agents-performance-fix) - A 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 all](https://www.tigzig.com/mcp) - The master directory. Connect any of these to Claude in Excel or Claude chat. - [APIs & open data - REST + MCP, single row or whole-database download](https://www.tigzig.com/apis) - The data surface behind the tools. - [Security checklist for AI-coded analytics apps](https://www.tigzig.com/security) - 108-point checklist from building and running these apps. - [Claude the Hunter-Killer - Claude Runs a Penetration Test on Your Own Setup](https://www.tigzig.com/post/claude-the-hunter-killer-pen-test) - Claude on the offensive-security side. - [My Public MCP Server Got Hammered - Security Lessons from a Bot Attack](https://www.tigzig.com/post/mcp-server-bot-attack-security-lessons) - What running a public MCP server actually teaches you. - [Browse all apps - built with Claude Code, most open source](https://www.tigzig.com/browse-apps) - 40+ analytics apps and tools, free.