sona i forgot to mention this book

Best Practices for Equity Research Analysts: Essentials for Buy-Side and Sell-Side Analysts - James J. Valentine

the book above along with the McKinsey book on valuation can provide you what you are looking for but if you were talking about a guide to modelling on excel then i would recommend the following books

Building Financial Models - John S. Tija 2nd edition
Wiley Financial Modeling with Crystal Ball and Excel Mar 2007 - 2nd Edition
Financial Simulation Modeling in Excel + Website A Step-by-Step Guide (Wiley Finance) 2nd