Leverage your transferable skills
You don’t need to start from scratch. You may already use tools and perform tasks that overlap with finance.
Ask yourself:
Do you work with budgets, forecasts, or reports?
Are you comfortable using Excel to analyze trends or create dashboards?
Do you understand how your company makes money and how financial decisions are made?
If you answered yes to any of these, you already have a foundation worth building on.
Fill knowledge gaps with essential skills (including AI tools)
If you're serious about how to become a financial analyst with no direct experience, this is a critical step. You don’t need to be an expert in every tool, but you should aim for a mix of foundational knowledge and the ability to learn quickly on the job.
The most important traditional tools to be familiar with include:
Excel—especially pivot tables, formulas and basic macros
Financial modeling—simple budgets, forecasts or scenario planning
Reporting tools—like Power BI or Tableau for data visualization
ERP systems—such as Oracle or NetSuite for tracking company-wide financials
Basic coding or data skills—SQL or Python can be useful, but aren’t essential for all roles
But use of traditional tools alone doesn’t cut it today. You’ll also have to know how to use generative AI to your advantage. Tools like ChatGPT are becoming everyday helpers for analysts. You might use them to speed up research, draft a summary for a presentation or double-check a complex formula.
And don’t skip the soft skills. Strong technical knowledge matters, but so does the ability to communicate clearly, ask the right questions and work well with others. Financial analysts often work with teams across the business, so they need to explain complex ideas in a way that’s easy for non-finance colleagues to understand.