Hi....
I usually use the following ratio's for fundamental analysis:
ROE, broken into Margin Ratio, Net Income Ratio, PBT EBIT Ratio, Return on Sales, Asset Turnover Ratio & Equity Ratio.
To understand Price Action, i use the following information; Open, Close, High, Low, Prv Close, Volume, VWAP & OI. Charts on VWAP, OI, High & Low are the most important.
My comfort on XLS, & its charts is cause I started my job working on Budgets, Forecast, Reporting & Ratio Analysis. We had deployed Balance Scorecards in the organisation to track NFP data also.
Having me on the team will benifit you and your org.