The end of Microsoft Excel's 40-Year Dominance? (Shortcut AI is INSANE)

Key Concepts

• AI-powered Spreadsheet Tool: Shortcut, an AI application that integrates with Excel and Google Sheets to automate tasks.
• End-to-End Agent: Shortcut acts as a comprehensive agent, handling 90% of spreadsheet-related work.
• Prompt Engineering: The art of crafting effective prompts to guide the AI.
• Observability and Traceability: The ability to track the source and reasoning behind AI-generated data and calculations.
• Context Limits: The constraints on the amount of information an AI model can process at once.
• Utilization Rate: A metric used by agencies to measure how effectively employees are being used on projects.
• Conditional Formatting: A feature in Excel that allows users to automatically format cells based on specific conditions.

Main Topics and Key Points

Introduction to Shortcut

• The speaker, Greg, introduces Shortcut as an AI app that integrates with Microsoft Excel and Google Sheets, automating tedious tasks.
• Nico, the co-founder of Shortcut, joins the podcast to demonstrate the product and discuss its applications.
• Shortcut is described as "like Excel if it was built in the future," retaining Excel's functionality while adding AI-powered automation.
• Unlike co-pilots that assist with individual steps, Shortcut aims to handle 90% of the user's work.

Live Demonstrations of Shortcut

• Updating a DCF Model: Nico demonstrates updating a Discounted Cash Flow (DCF) model for Google by pulling 10K filings from 2022-2024 and projecting forward to 2029.
  • The AI identifies and extracts data from 10K filings, which are typically lengthy PDF documents.
  • The AI encounters context limits due to the size of the 10Ks and adapts by processing them in chunks.
  • The AI provides a task list outlining its plan, including reading the model, downloading filings, extracting data, and updating assumptions.
  • The AI identifies and corrects errors in the model, such as circular references and incorrect formulas.
• Building a P&L Statement: Nico demonstrates building a Profit and Loss (P&L) statement using dummy data, projecting two years forward, and looking one year back.
  • The AI generates a P&L statement with revenue, expenses, and projections.
  • The AI creates a dashboard to visualize the data.
  • The AI makes some formatting choices that are not ideal, but the underlying data and calculations are accurate.
• Creating a Profitability Analysis for an Agency: Nico demonstrates creating a profitability analysis for a design agency, including utilization rates for different teams.
  • The AI generates a spreadsheet with employee-level data, available hours, utilization percentages, revenue, and costs.
  • The AI includes conditional formatting to highlight employees with high or low utilization rates.
  • The AI benchmarks the agency's utilization rates against industry standards.
  • The AI provides strategic recommendations based on the analysis.

Prompt Engineering and Clarifying Questions

• Nico emphasizes the importance of prompt engineering, suggesting that vague prompts can encourage the AI to be more creative.
• Shortcut uses clarifying questions to refine the user's intent and improve the quality of the results.
• Clarifying questions are presented in a user-friendly UI, making it easier for users to provide additional information.

Trust and Observability

• Nico stresses the importance of trust in AI outputs, emphasizing the need to review the AI's work and understand its reasoning.
• Shortcut provides observability by citing the source of each data point, including the exact page of the PDF it came from.
• Users can trace the origin of any hardcoded value in the model.
• The AI can identify and correct errors in the model, explaining the issue and the solution.

Unfair Advantages and Use Cases

• Shortcut allows users to complete tasks in minutes that would typically take hours in Excel.
• Shortcut empowers non-Excel experts to perform complex tasks.
• Users can import and export Excel files seamlessly, making it easy to integrate Shortcut into existing workflows.
• Potential use cases include financial modeling, data analysis, reporting, and automation.

Self-Driving Car Analogy

• Nico compares Shortcut to self-driving cars, noting that it is not yet fully autonomous but is rapidly improving.
• He suggests that Shortcut is currently at the "Tesla self-driving" stage for updating existing models, requiring human supervision.
• For building things from scratch, Shortcut is already past the self-driving moment.

The Future of Excel and AI

• Nico believes that all code will eventually be generated dynamically by AI.
• He argues that the best ideas are obvious in hindsight and that Shortcut fills a clear need in the market.
• He suggests that the initial reception to Shortcut has been strong because it addresses a problem that many people have experienced.

Pricing and Availability

• Shortcut is currently available with a pro plan for $40/month and a max plan for $200/month.
• The max plan includes the analyst beta, which allows users to run multiple tasks in parallel.
• The pricing strategy is subject to change as the cost of AI tokens decreases.

How to Get Started

• Users can try Shortcut for free at trash.ai.
• Nico recommends starting with a challenging task to test the AI's capabilities.

Important Examples, Case Studies, or Real-World Applications Discussed

• DCF Model Update: Updating a DCF model for Google using 10K filings.
• P&L Statement Generation: Building a P&L statement with projections for a company's data room.
• Agency Profitability Analysis: Creating a profitability analysis for a design agency, including utilization rates and benchmarking.
• Finding Launch Partners: Greg mentions using a similar AI tool to identify potential launch partners for a product launch.

Step-by-Step Processes, Methodologies, or Frameworks Explained

• Updating a DCF Model:
  1. Provide the AI with the existing DCF model and instructions to update it with new data.
  2. The AI searches for and downloads relevant 10K filings.
  3. The AI extracts data from the filings.
  4. The AI updates the historical data, drivers, and assumptions in the model.
  5. The AI identifies and corrects errors in the model.
  6. The AI generates new charts and visualizations.
• Creating a Profitability Analysis:
  1. Provide the AI with the desired metrics and time period for the analysis.
  2. The AI generates a spreadsheet with employee-level data, utilization rates, revenue, and costs.
  3. The AI includes conditional formatting to highlight key trends.
  4. The AI benchmarks the agency's performance against industry standards.
  5. The AI provides strategic recommendations based on the analysis.

Key Arguments or Perspectives Presented, with Their Supporting Evidence

• Shortcut is a significant improvement over traditional Excel: Nico argues that Shortcut automates tedious tasks, empowers non-experts, and provides greater observability and traceability. The live demonstrations provide evidence of these claims.
• AI will transform the way people work with spreadsheets: Nico believes that AI will eventually handle most spreadsheet-related tasks, freeing up humans to focus on higher-level analysis and decision-making. The examples of DCF model updates and P&L statement generation support this view.
• Trust and observability are essential for AI adoption: Nico emphasizes the importance of being able to review the AI's work and understand its reasoning. Shortcut's features for citing data sources and identifying errors address this concern.

Notable Quotes or Significant Statements with Proper Attribution

• Nico: "It's like Excel if it was built in the future."
• Nico: "It will do 90% of your entire job and then you get to do other things as that happens."
• Nico: "Even if AI becomes perfect, which it's not and I'm not sure it ever will be... You will have to really really trust its outputs in order to move forward."
• Nico: "The best ideas are really obvious in hindsight and I think the best predictor of what that is is if you can release something do people say I can't believe this didn't exist already."
• Nico: "It makes you an instant Excel expert, right? You could now create this um and you will speak to it in just plain English. And not only is it faster, but it's now also better than you at Excel."

Technical Terms, Concepts, or Specialized Vocabulary with Brief Explanations

• DCF (Discounted Cash Flow): A valuation method used to estimate the value of an investment based on its expected future cash flows.
• 10K Filing: A comprehensive annual report that publicly traded companies are required to file with the SEC.
• P&L (Profit and Loss) Statement: A financial statement that summarizes a company's revenues, costs, and expenses over a specific period of time.
• Utilization Rate: A metric used by agencies to measure how effectively employees are being used on projects.
• Conditional Formatting: A feature in Excel that allows users to automatically format cells based on specific conditions.
• Context Limits: The constraints on the amount of information an AI model can process at once.
• RAG (Retrieval-Augmented Generation): A technique for improving the accuracy and relevance of AI-generated text by retrieving information from external sources.
• LLM (Large Language Model): A type of AI model that is trained on a massive amount of text data and can generate human-like text.

Logical Connections Between Different Sections and Ideas

• The introduction of Shortcut leads into live demonstrations of its capabilities.
• The demonstrations illustrate the importance of prompt engineering and clarifying questions.
• The discussion of trust and observability builds on the demonstrations, highlighting the need to verify AI outputs.
• The self-driving car analogy provides a framework for understanding the current state of AI in spreadsheet applications.
• The discussion of pricing and availability provides practical information for potential users.

Data, Research Findings, or Statistics Mentioned

• Excel has two billion users.
• Shortcut is being used by thousands of companies.
• Pricing for Shortcut is $40/month for the pro plan and $200/month for the max plan.

Synthesis/Conclusion of the Main Takeaways

Shortcut is a promising AI-powered tool that has the potential to transform the way people work with spreadsheets. It automates tedious tasks, empowers non-experts, and provides greater observability and traceability. While it is not yet fully autonomous, it is rapidly improving and is already being used by thousands of companies. The key to getting the most out of Shortcut is to learn how to craft effective prompts and to carefully review the AI's outputs. As AI technology continues to advance, tools like Shortcut are likely to become increasingly essential for anyone who works with data.