Programme management tools

Hi I'm running a number of projects as the pm, but also reporting to the board on all projects. This is a new position and the company are new to pm management. I want something that will show very simply when all projects are being delivered (start to complete) and something else that shows departmental resources allocation. I've started to use excel to show this, but does anyone have any other options? Thanks