One way that I have seen people use excel is by keeping track investment portfolios. A model is created by the use of VBA (Visual Basic Application) which allows neat visual comparison of the performance of the portfilio with other benchmarks like the S&P500.
Tamjid Chowdhury