How to create a report in Microsoft® Excel
Follow the instructions to create a report in Microsoft Excel:
Select the ‘File’ menu and select ‘Print Report’.
Type the name for the report in the ‘Report Name’ box.
To create a section in the report, select a sheet from the ‘Sheet’ drop-down list box in the ‘Section to Add’ group.
To use a view from the selected worksheet, select the desired view from the ‘View’ drop-down list box.
To use a scenario from the selected worksheet, select the desired scenario from the ‘Scenario’ drop-down list box.
Click ‘OK’ when all sections for the current report are added.
Using Microsoft Excel you can create a simple report that you can use to summarize data, make a chart, show grouping, filter data and sort data. You can also make pie charts in Excel.