Learn how to make report in Excel using these simple steps

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.

• Status: Open
• Question Views: 441
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

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.

About superuser

Questions
2

Answers
28

Best Answers
14

• Vote Up 0 Vote Down

• Posted on - 08/20/2016
• Question Category: MS Excel

Answered By i7j3h9w9xb 0 points N/A #157825

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.

About i7j3h9w9xb

Questions
1

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/20/2016
• Question Category: MS Excel