Finance is going through a massive transformation. With AI, automation, and data analytics reshaping business decisions, the role of the FP&A professional is evolving faster than ever.
In the past, FP&A teams were mainly responsible for budgeting, forecasting, and reporting numbers. But today, companies expect finance professionals to act as strategic business advisors.
If you’re an ACCA student or aspiring finance professional, the question is no longer:
“Can you calculate numbers?”
It’s now:
“Can you turn numbers into business decisions?”
Let’s explore the most important skills future FP&A professionals must develop between 2026 and 2035.
The Shift: Number Cruncher → Strategic Advisor
Modern FP&A teams are expected to:
• Interpret complex data
• Provide strategic insights
• Predict business performance
• Support leadership decision-making
Technology will automate repetitive financial work, but companies will always need professionals who can think strategically and explain the story behind the numbers.
That means finance professionals must combine:
• Technical skills
• Analytical thinking
• Communication skills
• Business understanding
Core Technical Skills Every FP&A Professional Must Learn
1. Advanced Excel (Still the King of Finance)
Even with modern analytics tools, Excel remains the most important tool in finance.
Most financial models, reports, and forecasts are still built in Excel.
Important Excel skills include:
• Advanced formulas
• Pivot tables
• Power Query
• Scenario analysis
• Financial modeling
Free Resources to Learn Excel
Microsoft Excel Beginner Course
https://www.youtube.com/watch?v=Vl0H-qTclOg
Excel Skills for Business (Free course)
https://www.coursera.org/learn/excel-essentials
2. Financial Modeling
Financial modeling helps companies understand future performance, investment opportunities, and financial risks.
FP&A teams regularly build models for:
• Revenue forecasts
• Budget planning
• Scenario analysis
• Investment decisions
Free Financial Modeling Resources
Corporate Finance Institute Free Courses
https://corporatefinanceinstitute.com/resources
Financial Modeling Tutorial
https://www.youtube.com/watch?v=9o5CkS9ZCqk
Macabacus Financial Modeling Guide
https://macabacus.com/modeling
3. Power BI & Data Visualization
Finance is becoming data-driven, and businesses need dashboards instead of static reports.
Tools like Power BI help finance teams:
• Visualize financial data
• Track KPIs in real time
• Build executive dashboards
• Identify trends faster
Free Power BI Learning Resources
Microsoft Power BI Learning Path
https://learn.microsoft.com/en-us/training/powerplatform/power-bi
Power BI Full Course (Free)
https://www.youtube.com/watch?v=AGrl-H87pRU
Practice Datasets for Power BI
https://www.kaggle.com/datasets
4. SQL & Data Basics
Finance professionals increasingly work with large datasets, and SQL helps extract data directly from databases.
SQL allows FP&A teams to:
• Pull financial data
• Analyze large transactions
• Automize reporting processes
Free SQL Resources
SQL for Beginners
https://www.sqlbolt.com
Mode SQL Tutorial
https://mode.com/sql-tutorial
SQL Full Course
https://www.youtube.com/watch?v=HXV3zeQKqGY
AI & Automation Skills for Finance
Artificial Intelligence is already transforming FP&A.
AI can now:
• Forecast revenue
• Detect financial anomalies
• Automize reports
• Analyze massive datasets
Finance professionals must learn how to work with AI tools, not compete with them.
AI Skills to Learn
• Prompt engineering
• AI-assisted financial analysis
• Automated reporting
• Data interpretation
Free AI Learning Resources
AI for Everyone Course
https://www.coursera.org/learn/ai-for-everyone
Prompt Engineering Guide
https://www.promptingguide.ai
ChatGPT for Finance Tutorial
https://www.youtube.com/watch?v=V0q5rQKZkOQ
Business & Strategic Thinking
Numbers alone don’t drive business success.
FP&A professionals must understand:
• Business models
• Industry trends
• Competitive strategy
• Cost drivers
• Profitability analysis
Finance teams now help answer questions like:
• Should the company enter a new market?
• Which products are most profitable?
• How can costs be optimized?
Strategic thinking makes FP&A professionals valuable partners to leadership teams.
Communication & Storytelling with Numbers
One of the most underrated skills in finance is communication.
FP&A professionals must translate complex financial data into clear insights that executives understand quickly.
This includes:
• Presenting dashboards
• Explaining financial trends
• Writing executive summaries
• Influencing business decisions
Free Communication Resources
Storytelling with Data Blog
https://www.storytellingwithdata.com
Harvard Business Review Guide to Persuasive Presentations
https://hbr.org
TED Talks on Data Storytelling
https://www.youtube.com/results?search_query=data+storytelling
Skills ACCA & Finance Students Should Start Building Today
If you are an ACCA or finance student, start focusing on these areas early:
Technical Skills
• Advanced Excel
• Financial Modeling
• Power BI
• SQL basics
Future Skills
• AI tools
• Data analytics
• Automation tools
Business Skills
• Strategy thinking
• Communication
• Data storytelling
Developing these skills now will give you a huge advantage in the finance job market.
Final Thoughts
The future FP&A professional will be part analyst, part strategist, and part storyteller.
By 2035, the most successful finance professionals will not just report numbers — they will shape business decisions using data, technology, and strategic insight.
If you start building these skills today, you’ll be well prepared for the next generation of finance careers.
