Excel Professional – Design of Output

Above I have reproduced a 1-page outline of a project I need to build. There’s no meed for you to read my handwriting at this stage, and we will be coming back to this image.

In the previous section I indicated the items that will be selected for the output report.

If you are working from printed sheets from an Existing workbook then you will probably save time by circling various results in different colours, one colour for each specific output report.

As a general rule I like to see just two levels of detail in a report. Think of the report as a 1-page executive summary.

Next Step: