# Shortcut AI: How to use the best Excel AI Agent

Source: https://www.youtube.com/watch?v=yRx9QPfUNwU
Recap page: https://rapidrecap.app/video/yRx9QPfUNwU
Generated: 2025-10-28T23:31:03.563+00:00

---
## Quick Overview

Shortcut AI is a powerful Excel agent that enhances spreadsheet workflow by enabling users to execute complex tasks like building multi-tab DCF models, analyzing 10-K filings, and performing calculations in parallel directly within Excel using natural language prompts, offering features like targeted edits, prompt saving, and reversible changes via checkpoints.

**Key Points:**
- Shortcut AI integrates directly into Microsoft Excel, allowing users to issue natural language commands to perform complex spreadsheet tasks.
- The agent demonstrated capabilities in analyzing large documents (like a 10-K filing) to extract financial data and build complex models, such as a multi-tab DCF model with Monte Carlo simulations.
- Users can utilize targeted edits, specifying a range (e.g., A3:C5) for the AI to modify, which provides precise control over updates.
- The tool supports importing external files like PDFs for analysis, as shown when analyzing the America Water Works 10-K filing.
- Users can manage workflow context by starting new chats to clear the agent's memory, preventing 'context pollution' during complex tasks.
- Shortcut maintains a history of changes, allowing users to review all modifications (hard-coded vs. formula-driven) and restore the workbook state to any previous incremental step.
- Customization is available via 'AI Rules' and 'AI Preferences,' allowing users to define formatting (e.g., blue for assumptions, border styles) and function preferences (e.g., XLOOKUP vs. INDEX/MATCH).

![Screenshot at 0:10: The initial demonstration environment showing the empty Excel sheet alongside the Shortcut AI agent interface, ready to receive commands.](https://ss.rapidrecap.app/screens/yRx9QPfUNwU/00-00-10.png)

**Context:** The video is a tutorial/update demonstration by Nico from Shortcut AI, showcasing the advanced capabilities of their AI agent integrated directly into Microsoft Excel. The presenter walks through several complex use cases, including data extraction from financial documents and building sophisticated financial models, emphasizing control mechanisms like targeted edits, reversible changes, and prompt customization.

## Detailed Analysis

The tutorial highlights Shortcut AI's integration within Excel, allowing users to perform tasks through natural language prompts. The presenter first demonstrates populating an existing VC tracker template by asking the AI to find individual names associated with firms, showing the agent's ability to perform targeted edits on selected ranges (e.g., filling founder names in cells A3:C5). The agent also supports importing external data, exemplified by attaching and analyzing an America Water Works 10-K PDF to extract financial data and build a comprehensive, multi-tab DCF model that includes a Monte Carlo simulation, all formula-driven. Key operational features include the ability to switch between 'Action' (to execute changes) and 'Ask' mode (for clarifying questions), saving routine commands in a 'Prompt Library,' and customizing behavior via 'AI Rules' and 'AI Preferences' (e.g., specifying preferred formulas like XLOOKUP or formatting styles). Crucially, Shortcut maintains a detailed revision history, allowing users to review every change (hard-coded vs. formula-driven) and restore the workbook to any prior state, ensuring control and auditability.

### Excel Integration and Basic Use

- Agent operates within Excel interface
- Can open new or existing Excel files
- Demonstrates filling initial data like individual names using targeted edits on specific ranges.

### Complex Model Building

- Agent builds a multi-tab DCF model using data extracted from an uploaded America Water Works 10-K PDF
- Model includes formula-driven calculations, a drivers tab, Monte Carlo simulation (100 scenarios), and a dashboard.

### Customization and Rules

- Users can set 'AI Rules' defining formatting preferences (e.g., color coding for assumptions/outputs) and formula preferences (e.g., XLOOKUP vs. INDEX/MATCH)
- 'Prompt Library' saves frequently used prompts for routine workflows.

### Interaction Modes and Control

- Features 'Action' mode (to make changes) and 'Ask' mode (to ask clarifying questions)
- Users can switch between 'Speed' (limited tools) and 'Power' modes for execution.

### Change Management and Auditability

- Detailed 'Review Changes' log shows all modifications categorized as Hard-Coded (16 in one example) or Formulas (76 in one example)
- Users can 'Restore' the workbook to any previous checkpoint or latest saved state, ensuring reversibility of actions.

![Screenshot at 0:10: The initial demonstration environment showing the empty Excel sheet alongside the Shortcut AI agent interface, ready to receive commands.](https://ss.rapidrecap.app/screens/yRx9QPfUNwU/00-00-10.png)
![Screenshot at 0:37: The file selection dialog appearing after the user requests to open an existing VC Tracker template file from their computer.](https://ss.rapidrecap.app/screens/yRx9QPfUNwU/00-00-37.png)
![Screenshot at 0:50: The VC Tracker template successfully loaded, showing initial data and column headers, ready for AI population.](https://ss.rapidrecap.app/screens/yRx9QPfUNwU/00-00-50.png)
![Screenshot at 1:12: Demonstration of a targeted edit where the user prompts the AI to 'fill in the founder names' in the selected cell range \(A3:C5\).](https://ss.rapidrecap.app/screens/yRx9QPfUNwU/00-01-12.png)
![Screenshot at 3:52: The file attachment dialog opened by the user to upload a PDF \(America Water Works 10K\) for financial analysis.](https://ss.rapidrecap.app/screens/yRx9QPfUNwU/00-03-52.png)
![Screenshot at 4:42: The Fantasy Draft Optimizer spreadsheet is being built, showing the agent actively working on tasks in the right panel.](https://ss.rapidrecap.app/screens/yRx9QPfUNwU/00-04-42.png)
![Screenshot at 6:07: The user navigates to the 'Settings' menu under the account tab, highlighting options like 'Data controls' and 'Security'.](https://ss.rapidrecap.app/screens/yRx9QPfUNwU/00-06-07.png)
![Screenshot at 6:34: The 'AI Rules & Instructions' configuration window open, showing detailed settings for formatting and operation logic.](https://ss.rapidrecap.app/screens/yRx9QPfUNwU/00-06-34.png)
![Screenshot at 7:44: The input prompt box showing the selection between 'Speed' and 'Power' modes for task execution, with 'Power' currently selected.](https://ss.rapidrecap.app/screens/yRx9QPfUNwU/00-07-44.png)
![Screenshot at 8:17: The agent's chat history showing the successful completion of the complex DCF model build, including the creation of a Monte Carlo simulation tab.](https://ss.rapidrecap.app/screens/yRx9QPfUNwU/00-08-17.png)