0
You can create a report in any style you like. Put data on the page in the locations where you would like it to be displayed, look at how it will appear when printed, and adjust as necessary to meet your specifications.
Wiki User
∙ 13y ago
Wiki User
∙ 9y agoThere are a number of kinds of report to which you could mean. You have a simple structured table, with headings, data and totals. You can then use the Table Autoformat to format the table.
There are also pivot tables. To create one, first you need you list of original data. Then you would select that data, and go to the Data menu. There you will find the options for creating the pivot table. Excel will give a little assistance in the process of creating one. They are a bit complicated to start with, but with a bit of practice, you will get used to using them and know how and when to use them. You will find help in Excel itself and there are lots of resources and examples on the internet about them.
There are also What-if tables. You have one input and two input tables. These can be used to apply formulas to a large set of data and result in a table of data. Data from the first column and/or row are used in conjuction with a formula.
Wiki User
∙ 14y agoclick the print button
Add your answer:
Earn +20 pts
Can you show me a example of a business related report created with Microsoft Excel?
MS Excel (and its competitors similar software) is often used to create reports which are showing details of mass amounts of figures.Examples of these figures would include:Financial income or expenditureSales figuresDetails of a studyA collection of details pertaining to a specific subjectAdded to the related links are a few examples of 'reports' which are made using information in Excel and a simple guide to excel reports.
What program is used to create and modify spreadsheets on Excel Answer It?
Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.
Why students use computer?
To type reports (Word), research information (internet), or create spreadsheets (Excel).
Why would you interchange word access and Excel?
Because you want to use excel as input of data (for instance from different teams or users), access as database and word to create reports (by using templates and insert data via bookmarks).
How do you make a result sheet in Excel?
how to create a excel sheet
How do you create a table that reports the displays the quarterly sales by territory on Excel?
It is not simple to answer without knowing the data you have and its layout. However, once your data is set up correctly, you could use a Pivot Table to do what you are asking. You can do that through the Insert tab on new versions of Excel or on the Data menu in Excel 2003 and before.
When you create an Excel chart in PowerPoint what data do you use that is editable in Excel into the presentation?
You can create an excel chart in presentation. This helps to compare a large number of values.
Why MS-Excel is used?
ms excel is used to create spreadsheets.
Why do you need Microsoft Access especially if you have Microsoft Excel?
Microsoft Access is a database application and Microsoft Excel is a spreadsheet application, so they are two different kinds of application. There are things that both can do, but if you want to create a proper database, then Access is better than Excel. It has far more facilities for working with databases than Excel does. Because of that, it is simpler to do lots of things in Access than in Excel. If you want to create a spreadsheet, then that is what Excel is used for, though you can do a lot of things Excel does in Access. If you already have Excel and want to create databases, then you can, but you won't be able to do the really sophisticated things that Access can do and which a really good database needs, such as queries, reports, relationships etc. If you want a really good database that can do those things, then you need Access.
How do you create an Excel to Oracle converter?
From MS Excel, there is nothing you can create. You can save an Excel file in various formats, that might make it easier to import the data into Oracle.
How do you easily create Excel files in c?
You might be able to use C to extract data from an Excel file, but there is no easy way to write a program to create an Excel file.
Which reports are easy to create rdlc or crystal report in asp.net?
The reports are easier to create iin crystal report.
