Then, copy that formula down for the rest of your stocks. But, as I said, dividends can make a huge contribution to the returns received for a particular stock. Also, you can insert charts and diagrams to understand the distribution of your investment portfolio, and what makes up your overall returns. If you have data on one sheet in Excel that you would like to copy to a different sheet, you can select, copy, and paste the data into a new location. A good place to start would be the Nasdaq Dividend History page. You should keep in mind that certain categories of bonds offer high returns similar to stocks, but these bonds, known as high-yield or junk bonds, also carry higher risk.