Comment by daemon13

First and foremost you need to understand finance and the numbers (what is behind them), tool is not relevant for this.

However, proper tool does make things more efficient. Based on practical experience Excel is excellent for financial modelling.

As for R, Python + Pandas, databases and CSV files - they are mostly useful for supporting and ad-hoc analysis, esp. for sales and marketing data.