Prompt Engineering is the New Excel Formula: The Skill Set Every Analyst Needs
In the 1990s, you needed VLOOKUP to survive in finance. In 2026, you need to know how to talk to LLMs.
For 30 years, the defining skill of a financial analyst was Excel mastery. If you could build nested IF statements and macros, you were a god. But today, the most valuable syntax isn't code or formula—it is natural language.
Prompt Engineering—the art of crafting precise instructions for AI models—Is the new barrier to entry. An analyst who knows how to prompt well can do the work of ten analysts who don't. It is the ultimate leverage.
From Calculation to Orchestration
Excel was about *calculation*. You had to tell the computer exactly how to do the math. AI is about *orchestration*. You tell the computer the outcome you want, and it figures out the math.
But this shift is deceptive. It sounds easier, but it requires a different kind of rigor. You have to be precise about context, constraints, and format. "Analyze this data" yields garbage. " Analyze this variance report, focusing on T&E spend, and highlight any anomalies over 2 standard deviations" yields gold.
The Rise of the "AI Whisperer"
We are seeing a new archetype in finance teams: the "AI Whisperer." This is the person who knows exactly how to phrase a query to get the model to output a perfectly formatted board memo or a clean SQL query.
These individuals are becoming indispensable. They are building the libraries of prompts that the rest of the team uses. They are translating business ambiguity into algorithmic specificity.
Iterative Logic vs. Binary logic
Excel formulas are binary: they work or they error out. Prompt engineering is iterative. You start with a draft, see the AI's output, and refine. It's a conversation, not a command.
This requires resilience and adaptability. The best analysts today are those who can quickly iterate through five versions of a prompt to get to the truth, rather than spending five hours building a model from scratch.
Career Proofing Your Future
If you are a junior analyst today, don't just learn shortcuts for your spreadsheets. Learn how to structure a chain-of-thought prompt. Learn how to provide few-shot examples to a model.
The tools will change—Excel might fade, and new platforms will rise—but the ability to effectively direct intelligence will be the defining skill of the next decade.
Conclusion
Excel isn't dead, but its monopoly on analytical work is over. The future belongs to those who can speak the language of machines fluently. It’s time to upgrade your syntax.
Master the prompt with ChatFin.
Upgrade Your Skills
Explore our library of finance-specific prompts to supercharge your analysis.