Asked By
nabeelahmed
0 points
N/A
Posted on - 08/20/2016
Hi. I have recently started using MS-Excel. I want to learn to make a report in Excel. How to make report in Excel? Please reply ASAP. Thanks in advance.
Answered By
superuser
4875 points
N/A
#157824
Learn how to make report in Excel using these simple steps
Hi. To learn how to make report in Excel, first click on the PivotTable from the insert menu. Then, in the table box, ensure that the table is selected. A range can be typed in the dialog box; however, an Excel takes in an automatic range for the cells if not specified. The worksheet name should be included as well. If the report needs to be placed on the starting cell named A1, then click on new worksheet else if it needs to be placed on an existing location, click on existing worksheet and mention the first cell where the report needs to be placed. Click on OK. The report is added to the specified location and can be formatted further. Next, fields can be added to the report in the field boxes after you click on the name of that field and then clicking on the Add to report filter, add to column or add to row label option. Field can be dragged to the section as well. Hope we helped.
Learn how to make report in Excel using these simple steps
Hi. To learn how to make report in Excel, first click on the PivotTable from the insert menu. Then, in the table box, ensure that the table is selected. A range can be typed in the dialog box; however, an Excel takes in an automatic range for the cells if not specified. The worksheet name should be included as well. If the report needs to be placed on the starting cell named A1, then click on new worksheet else if it needs to be placed on an existing location, click on existing worksheet and mention the first cell where the report needs to be placed. Click on OK. The report is added to the specified location and can be formatted further. Next, fields can be added to the report in the field boxes after you click on the name of that field and then clicking on the Add to report filter, add to column or add to row label option. Field can be dragged to the section as well. Hope we helped.
