Report generation in an excel

Asked By Ramakrishnana 0 points N/A Posted on - 01/11/2012

I want to get some examples for report generation in excel such as purchase, sales etc. I wonder those options are not available in the previous version of Excel. I also want to know how, more columns can add in the worksheet.

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

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Sherin Viluel

Go To Solution

Answered By Richard Gabriel 0 points N/A #85383

Report generation in an excel

For you to be able to create reports in ms excel, you will need to get the LabVIEW application which works hand in hand with Microsoft Word.

Some of the things that you will be able to do are as follows:

• You can create and edit reports that consist of text, tables, graphs, and pictures.
• You can populate report templates.
• You can also be able to manage the layout of the report and its formatting, which will be having headers, footers, page numbers, fonts, borders, colors, text alignment, and many other attributes.
• You can also be able to add functions and then sort data in Excel worksheets.
• Another thing that you will be able to do is run Visual Basic for Applications macros, and also make custom report generation functions and E-mail or print reports too.

Richard Gabriel

 

About Richard Gabriel

Questions
0

Answers
99

Best Answers
22

• Vote Up 0 Vote Down

• Posted on - 01/11/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Sherin Viluel 0 points N/A #85384

Report generation in an excel

 

You can use Microsoft Excel to generate any kind of report according to your requirement.

As you mentioned in the question I will show you how to make a Daily sales report which include following data.

Customer, Date of Sale, Invoice no, Amount.

We can include these data in an Excel work sheet as follows.

You can enter the above headings in Column A1, B1, C1, and D1.

 

 

 

Now you can enter the data which is relevant to each column.

 

 

 

If you want to add more columns to the above data you can follow the below method.

We will think you want to add “Payment method” in between Date of Sale and Invoice number.

Select the column C ( Click on the Letter C ),then right click on the selected area and click on the “insert”.( Or you can use the short cut keys “Ctrl+” without right clicking)

 

 

 

Now a new column will be inserted to column C and type the heading in the Cell C1.

 

 

 

About Sherin Viluel

Questions
0

Answers
50

Best Answers
37

• Vote Up 0 Vote Down

• Posted on - 06/28/2012
• Question Category: MS Excel