Learn how to make report in Excel using these simple steps

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 4875 points N/A #157824

Learn how to make report in Excel using these simple steps

qa-featured

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.

Answered By 0 points N/A #157825

Learn how to make report in Excel using these simple steps

qa-featured

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.

Related Questions