Excel sheet to calculate total stock returns including price appreciation and dividends

Try My Portfolios feature of bseplus.bseindia.com

http://bseplus.bseindia.com/portfolio/DetailView.aspx?lang=en

Other option is to use Google Finance.

Also search the forum. You should find some excel sheet that use XIRR function to calculate returns.

http://forum.valuepickr.com/t/need-help-to-calculate-stock-returns/7375

http://forum.valuepickr.com/t/how-to-track-ones-portfolio-effectively/564/1