Action, Plan, and Ask Modes in Excel AI

Shortcut's three modes transform Excel work: Action Mode for building models, Plan Mode for creating detailed implementation plans, and Ask Mode for intelligent analysis. Build complex financial models in minutes while understanding every calculation and insight.

Exceptional spreadsheet work is not just about building models fast.

It's about understanding your data, extracting insights, and knowing what matters.

Shortcut helps you do exactly that. It doesn't just execute tasks—it plans complex implementations, answers questions, traces calculations, and highlights key trends in your models.

This is why Shortcut is built around three powerful modes: Action Mode, Plan Mode, and Ask Mode.

What are Action, Plan, and Ask Modes?

Action Mode — Your Excel Execution Assistant

Action Mode is designed to help you build, edit, and automate your financial models. Think of it as your personal modeling associate who can:

  • Build complex models from scratch (DCF, CRE Pro Forma,SaaS P&L, etc.) in minutes.
  • Pull and clean data from CIMs, OMs, PDFs, CSV or Excel files or internet available data, including 10Ks and 10Qs public filings from the SEC using our EDGAR integration.
  • Execute prompts to update assumptions, add scenarios, or create visualizations.

How Action Mode Works

Under Action Mode, the system uses a multi-agent workflow to convert a user's prompt into a structured, step-by-step execution plan. First, the primary agent asks clarifying questions to fully understand the request. Once the intent is clear, it breaks the prompt down into five core task types: data extraction, planning,cell execution, formatting, and verification. This structured plan is then handed off to a secondary agent, which loops through every cell, applies edits, pulls formulas across tabs, and runs formatting and verification checks. As tasks are completed, they're tracked in a planning bar that shows progress and status. Finally, cell tagging tracks the source page or data lineage, making it easy to trace back where each data point originated.

Example prompts to Try

"Build a 10-year CRE pro forma with 3% rent growth and 2.5% OpEx inflation using the CIM I just uploaded."

Ask Mode — Your Data Q&A Assistant

Ask Mode is built for understanding your model and helping derive insights. Instead of manually tracing formulas across 10 tabs, ask mode helps you:

  • Traces data lineage back to your source files
  • Break down calculations logic step by step
  • Identify key trends and performance drivers
  • Surfaces insights for memos and decks
  • Translate raw numbers into clear narratives

Example prompts to Try

"Explain how the Year 2 stabilized NOI was calculated and where the inputs came from."

"Which line item drives most of NOI growth between Year 2 and Year 5?"

"What trends should I highlight in my memo?"

Plan Mode — Your Implementation Strategist

Plan Mode creates detailed, step-by-step implementation plans for complex tasks without making any changes to your spreadsheet. Perfect for:

  • Understanding implementation approach before making changes
  • Reviewing code and logic before execution
  • Learning how to build complex models step-by-step
  • Getting executable code you can review and modify

Execute Plan Button

When Plan Mode finalizes a plan, an "Execute Plan" button appears. Click it to automatically switch to Action Mode, create a new chat, and execute the plan—turning your strategy into reality with one click.

Example prompts to Try

"Create a detailed plan to build a DCF model with sensitivity analysis."

"Plan out how to restructure this model to separate assumptions from calculations."

Common Use Cases

1. Understanding How Numbers Are Built

When you need to reverse-engineer a metric and see exactly where it comes from.

Example prompt:

"How is Year 2 NOI calculated" or "Where does Year 5 EBITDA come from?"

Ask Mode traces the calculation chain, pinpoints the exact source cells, and highlights the assumptions driving that number — no manual formula hunting required.

2. Face Value Lookups

When you just need to pull a specific figure buried somewhere in a large model.

Example prompt:

"What's the historical cost per unit for Year 1?"

Ask Mode searches the entire model, finds the number instantly, and tells you where it came from. Perfect for quick reference checks or fact-finding during meetings.

3. Education and Onboarding

When junior analysts or new team members need to understand how the model actually works.

Example prompt:

"Can you explain how assumptions flow into the pro forma and which inputs matter most?"

Ask Mode walks through the model structure step by step — showing how inputs flow into outputs, where the key levers live, and how changes ripple through the model. It's like having a senior analyst on call 24/7.

How does Shortcut fit into your Daily Workflow?

Typical financial workflows involve both building and interpreting models. Shortcut sits on top of your existing Excel, making it faster, cleaner, and more intelligent.

TraditionalWith Shortcut
Download CIM / OM / other PDFUpload file directly
Extract numbers manuallyAI extracts data such as OpEx, CapEx, etc.
Build model in ExcelUser uses Action Mode to build Model
Manually trace cellsUser uses Ask Mode to explain data and assumptions
Prepare memoAI highlights key insights through Ask Mode
Adjust scenariosUser uses Action Mode to re-prompt and auto-update model

Typical time to build and interpret a financial model manually takes 2–4 hours.
With Shortcut, it takes less than 5 minutes using a single prompt.

Step-by-Step Example: Building a CRE Pro Forma

Step 1: Upload Your Source Files

Start by uploading your CIM, OM, or any PDF containing property information.

Step 2: Build your Model with Action Mode

Prompt: "Build a 10-year CRE pro forma with 3% rent growth and 2.5% OpEx inflation using the pdf I just uploaded."

Shortcut automatically:

  • • Extracts NOI, rent baselines, and financials from the PDF
  • • Creates sheet structure with Assumptions, Pro_Forma, and Summary tabs
  • • Applies professional formatting

Time Spent: 5 Minutes!

Step 3: Analyze with Ask Mode

Prompt: "What trends should I highlight in my investment memo?"

Shortcut analyzes your model and provides insights like NOI growth rates, margin expansion, and key value drivers formatted for your memo.

Key Takeaways

  • 3 Powerful Modes - Action for execution, Plan for strategy, Ask for analysis
  • Execute Plan Button - One-click execution from planning to implementation
  • Financial Model Automation - Build DCF, CRE, SaaS models in minutes
  • SEC EDGAR Integration - Direct access to 10K and 10Q filings
  • Multi-Agent Workflow - 5-step structured execution with verification
  • Data Lineage Tracking - Trace every cell back to its source