A collection of bits and pieces. Not really worthy of being classed as useful tools.
Manually recording dividends and displaying in a pivot table
This Excel spreadsheet shows a way of manually recording dividends and presenting the data in a pivot table. Note that if the data is changed, the pivot table needs to be refreshed to correctly display the new data.
Also note that historic data may need to be manually adjusted to take account of share splits or consolidations.