The Tool Nobody Can Kill
Every few years, someone declares "Excel is dead."
Then every finance team in the world ignores them and keeps using Excel.
There's a reason for that.
Why Excel Won (And Keeps Winning)
1. Universal Language
Every finance professional speaks Excel.
- New hire? They know Excel.
- Consultant? They work in Excel.
- Board member? They understand Excel.
- Auditor? They want Excel files.
Try getting that adoption with any other tool.
2. Infinite Flexibility
Need to:
- Build a 3-statement model?
- Calculate IRR on a waterfall?
- Reformat a table 17 different ways?
- Create a one-off analysis that will never be repeated?
Excel can do it. Right now. Without waiting for IT.
3. Owned by the User
"I don't need permission to build a model. I don't need a developer. I just open Excel and do it."
Finance teams value autonomy. Excel delivers it.
4. Iterative Analysis
Finance work is exploratory:
- "What if we assume 3% growth instead?"
- "Show me that by region instead of by product"
- "Actually, let's look at the last 3 years, not 5"
Excel handles rapid iteration better than any BI tool.
5. It's Already There
Every computer has Excel. Every finance team uses Excel.
Switching costs are enormous. Inertia is real.
Where Excel Shines
✅ Ad-Hoc Analysis
"The CEO just asked a random question. I need an answer in 20 minutes."
Excel is perfect for this.
✅ Financial Modeling
3-statement models, DCF analysis, sensitivity tables—Excel was built for this.
✅ Data Manipulation
Clean, transform, pivot, reformat. Excel is the Swiss Army knife of data.
✅ One-Off Projects
M&A model for a single deal? Excel. Building a SaaS platform? Not Excel.
✅ Presentation & Formatting
When the final output needs to look just right, Excel gives you pixel-level control.
Where Excel Fails (And Becomes Dangerous)
❌ Single Source of Truth
When "Final_Budget_v7_revised_FINAL2.xlsx" is your system of record, you have a problem.
❌ Multi-User Collaboration
Three people editing the same complex model = disaster.
❌ Large-Scale Data Processing
100,000+ row datasets? Excel will crash. Or slow to a crawl.
❌ Automated Workflows
"Every month I export from MRI, paste into Excel, recalculate, save as PDF..."
This shouldn't be manual.
❌ Auditability & Governance
Who changed this formula? When? Why? Excel doesn't know.
❌ Real-Time Reporting
Board wants current NOI? Good luck if your Excel is 3 days old.
❌ Version Control
Which version is the official budget? The one in the CFO's email? Controller's network drive? Property manager's desktop?
The Modern Approach: Excel + Intelligence
The best finance teams don't eliminate Excel. They augment it.
Use Excel For:
- Analysis and exploration
- Financial modeling
- Custom formatting
- One-off projects
- Final presentations
Use Purpose-Built Tools For:
- Data storage (database, not spreadsheet)
- Automated data pipelines
- Multi-user collaboration
- Audit trails and governance
- Real-time dashboards
- Scheduled reporting
The Integration
- Data Layer: Systems (like MRI) connect to intelligence platform
- Intelligence Layer: Automated processing, validation, consolidation
- Analysis Layer: Export to Excel for CFO-level analysis and modeling
- Presentation Layer: Dashboard for ongoing monitoring, Excel for board decks
Real-World Example
Bad (Excel as System of Record):
- Property data exported from MRI to Excel
- 35 property workbooks
- Manual consolidation each month
- Multiple versions floating around
- Errors discovered days later
Good (Excel as Analysis Tool):
- MRI data flows automatically to intelligence platform
- Platform consolidates and validates
- CFO exports to Excel for specific analysis
- Excel used for modeling and presentation
- One version of truth maintained in platform
What This Looks Like in Practice
Scenario: Board asks "What if we sold our 3 worst-performing properties?"
With Excel Alone:
- Pull performance data (2 hours)
- Identify bottom 3 (30 minutes)
- Build exit model (4 hours)
- Calculate impact on debt covenants (2 hours)
- Create presentation (2 hours) Total: 10+ hours
With Excel + Intelligence:
- Platform identifies bottom 3 (30 seconds)
- Export data to Excel (30 seconds)
- Build exit model (1 hour)
- Calculate covenant impact (30 minutes)
- Create presentation (1 hour) Total: ~3 hours
Excel is still central. But it's doing what it does best (modeling and analysis), not what it does worst (data management).
The Controversial Take
"Excel isn't the problem. Using Excel as a database is the problem."
Excel is a calculation and analysis tool. When you force it to be:
- A database
- A workflow engine
- A collaboration platform
- A governance system
That's when things break.
The Bottom Line
Excel dominates finance for good reasons:
- Flexible
- Familiar
- Powerful
- Universal
The solution isn't to eliminate Excel. It's to:
- Recognize its strengths
- Acknowledge its limitations
- Complement it with purpose-built tools
- Use each tool for what it does best
Excel will still dominate finance in 2030. And that's OK.
As long as it's not your only tool.
For finance teams looking to modernize without abandoning Excel, the key is building complementary systems that handle what Excel can't—while keeping Excel for what it does brilliantly.