As indicated in a previous post, one of the tools that 'notices' colours in Excel cells is the Data Filter. By combining this with some other tools/ functions you can get a sum, count or average of the coloured cells.
Once you have created your spreadsheet with your impressive charts, you may need to copy the Excel chart into PowerPoint or Word. There are a few options for this which are worthwhile considering.
Spreadsheets are great at sorting and identifying numbers but what can you do to match positive and negative numbers in excel. If you sort the numbers the 'matches' are as far apart as could be possible.