iYogi

Computer Problems? Call Toll Free @ 1 877 316 9417
Troubleshoot all your computer problems with certified tech experts, Call Today!
http://support.iyogi.com

Question

How to create a report in Microsoft® Excel

Reason
If you have a number of Microsoft Excel worksheets that contain related data, then you need to create a report that consolidates and summarizes the data. Sometimes you have to analyze large amounts of data and create reports based on that data.

The solution to the problem

Follow the instructions to create a report in Microsoft Excel:

  1. 1

    Select the ‘File’ menu and select ‘Print Report’.

  2. 2

    Click ‘Add’.

  3. 3

    Type the name for the report in the ‘Report Name’ box.

  4. 4

    To create a section in the report, select a sheet from the ‘Sheet’ drop-down list box in the ‘Section to Add’ group.

  5. 5

    To use a view from the selected worksheet, select the desired view from the ‘View’ drop-down list box.

  6. 6

    To use a scenario from the selected worksheet, select the desired scenario from the ‘Scenario’ drop-down list box.

  7. 7

    Click ‘Add’.

  8. 8

    Click ‘OK’ when all sections for the current report are added.

  9. 9

    Click ‘Close’.

Footnotes:

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.

Leave a Reply

*