Report generation in an excel

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

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.

SHARE
Best Answer by Sherin Viluel
Answered By 0 points N/A #85383

Report generation in an excel

qa-featured

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

 

Best Answer
Best Answer
Answered By 0 points N/A #85384

Report generation in an excel

qa-featured

 

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.

 

 

 

Login/Register to Answer

Related Questions