ise consultancy - Excel

Microsoft Office consultancy for charities and small businesses

Home 

Access 

Word 

Visual basic for Applications 

SunVision 

I was asked to present benchmark data to a number of non-financial managers who due to their busy schedules needed to understand the results quickly.

The attached spreadsheet demonstrates that by using charts.

Either click on the link to open the spreadsheet in your browser or right click and 'save target as' to save your own copy.

To use the spreadsheet the appropriate ratio needs to be selected from the drop down list at the top of the page and the OK button clicked.

The results can then be limited or expanded by selecting appropriate areas or schools from the drop down lists at the bottom of the page.

There are a number of areas each containing a number of schools.