How to Automate Excel Work with Shortcut AI

TL;DR

Shortcut uses natural-language prompts to create, update, and analyze spreadsheets, including existing Excel files, while showing its task plan and data sources. It can reduce complex financial modeling from hours to minutes for experts and help less experienced users handle formulas, projections, dashboards, and multi-sheet models without mastering macros.

Transcript

I spent years inside Microsoft Excel building models, forecasting revenue, cleaning messy data. I hated it. Every time I thought there has to be a better way. Then last week I came across Shortcut. It's this AI app that plugs into Microsoft Excel, Google Sheets, and suddenly the tedious stuff becomes magic. So I invited the co-founder Nico onto the... Read More

Key Insights

• Shortcut is an AI-powered spreadsheet application that accepts plain-English instructions, works with existing Excel files, and is designed to support the same kinds of tasks users perform in Excel. Its agent can create, modify, and analyze spreadsheet content without requiring users to write every formula manually.
• Shortcut is designed to complete about 90% of a spreadsheet job rather than assist with only one or two isolated steps. Users can send a substantial task to the agent, work elsewhere, and return later instead of watching every intermediate action as it happens.
• Complex financial modeling is a central Shortcut use case. The demonstration asks the agent to update a large discounted cash flow model, preserve an exact template, retrieve Google filings from 2022 through 2024, and create forward projections through 2029.
• Existing templates are valuable because real finance work often involves updating established structures rather than building models from scratch. Shortcut can retain a template's organization while replacing historical data, revising assumptions, and updating formula-driven profit-and-loss statements, dashboards, metrics, and charts.
• Context-aware clarification questions improve underspecified prompts by asking users to choose assumptions and output requirements. In the profit-and-loss example, Shortcut asks whether future growth should be conservative, moderate, or aggressive, and the user requests all scenarios across multiple sheets.
• Shorter prompts can produce better results when Shortcut has room to interpret the objective and request clarification. The co-founder recommends relatively vague, less verbose instructions because they encourage model creativity while allowing the product's follow-up questions to resolve important requirements and assumptions.
• Transparency is supported through visible plans and source tracing. Shortcut displays a task list for reading the existing model, locating filings, extracting information, updating historical figures, and revising drivers and assumptions, helping users understand how the spreadsheet work is being performed.
• Shortcut benefits both spreadsheet experts and less experienced users. Experts can reduce work that normally takes hours to about ten minutes, while users who are uncomfortable with formulas or macros can create and manipulate sophisticated models with natural language and guided clarification questions.

Questions & Answers

Q: What is Shortcut AI for spreadsheets?

Shortcut is an AI-powered spreadsheet application that resembles Excel and supports the same broad types of spreadsheet work. Its main difference is an AI agent that understands plain-English requests and can perform most of a job on the user's behalf. It can also open existing Excel files directly, allowing users to modify established models instead of rebuilding them from scratch.

Q: How does Shortcut work with existing Excel files?

Shortcut can open an existing Excel file and manipulate its contents through natural-language instructions. A user can ask it to preserve the exact template, replace historical information, revise drivers and assumptions, and extend projections. Formula-driven areas, such as profit-and-loss statements and dashboards, can then update automatically when the underlying source material is changed.

Q: How can Shortcut create a financial model?

A user describes the required model, its purpose, the historical period, the projection period, and any formatting expectations. In one demonstration, Shortcut is asked to build a professional profit-and-loss statement using one year of data and project it for two more years for a data room. It also supports multiple scenarios, sheets, metrics, and charts.

Q: How should users prompt Shortcut effectively?

The co-founder recommends relatively short and less specific prompts rather than highly verbose instructions. A broad request gives the model room to develop an approach, while Shortcut's context-aware clarification questions collect important details. Users can then specify assumptions, scenarios, template requirements, sheets, charts, and output quality in response to those focused follow-up questions.

Q: Why does Shortcut ask clarification questions?

Clarification questions help users define requirements they may not have included in their initial prompts. Shortcut can ask which growth assumptions to apply, such as conservative, moderate, or aggressive scenarios. This productized interaction improves prompting, helps the agent understand the spreadsheet's context, and lets users make important modeling choices without writing a long technical specification first.

Q: How does Shortcut provide transparency and verification?

Shortcut shows its working plan and provides visibility into the sources used for a task. During the discounted cash flow demonstration, it lists steps for analyzing the model, finding and downloading company filings, extracting information, updating historical data, and revising drivers and assumptions. This traceability helps users inspect where information came from and how the model was updated.

Q: Who benefits most from using Shortcut?

Shortcut serves two main user groups. Experienced Excel users can reduce lengthy, repetitive work from hours to roughly ten minutes while continuing to use familiar models and templates. Less experienced users can become capable of sophisticated spreadsheet work more quickly because natural-language requests and clarification questions reduce the need to master formulas, macros, and complex modeling procedures first.

Q: What complex tasks can Shortcut automate?

Shortcut can automate discounted cash flow models, profit-and-loss statements, projections, scenario analysis, dashboards, metrics, charts, and multi-sheet workbooks. In the demonstration, it searches for Google's filings from 2022 through 2024, extracts relevant data, updates a large model, and creates projections through 2029 while preserving the requested template and its formula-driven structure.

Summary & Key Takeaways

• Shortcut recreates the familiar Excel experience while adding an AI agent that can perform most spreadsheet work from natural-language requests. Users can open existing Excel files, preserve established templates, update source data, create formulas and charts, and run several spreadsheet tasks at the same time while working on something else.

• The demonstrations include updating a discounted cash flow model with Google filings, building a professional profit-and-loss statement for a data room, and projecting financial results under several growth scenarios. Shortcut creates task lists, finds relevant source material, extracts historical data, updates assumptions, and lets formula-driven sections refresh from revised inputs.

• Shortcut serves two primary user groups. Spreadsheet experts can compress hours of repetitive modeling into roughly ten minutes, while non-experts can perform work that previously required advanced Excel knowledge. Shorter, less specific prompts are encouraged because context-aware clarification questions help define assumptions, preserve structures, select scenarios, and improve the final spreadsheet output.