Learn how to calculate beta for stocks manually and in Excel. Step-by-step guide with Nike example, common mistakes to avoid, alternative methods for private companies, and portfolio application tips.