You will find this tool in the 2003 version of Excel under Data, Report of dynamic tables and graphs (Excel 20 in Insert, Pivot Table), a wizard opens that indicates different possibilities about where the data is to be used in the table, if you want it on a separate sheet, design, help, etc.Ĭlicking Finish opens a blank table in a new spreadsheet with a window called PivotTable Field List. In row, column and in the central part of the table we place the criteria you need for your report by clicking on the field you want and dragging it with the mouse and dropping it in the table area. Pivot tables are used to perform data analysis even more specific than that provided by the Subtotal tool. They are called dynamics because the report obtained with them can be easily transformed into another one depending on the criteria you choose, all based on a few clicks and mouse dragging. To remove the Subtotals, go to Data, Subtotals, Remove all. You will obtain the order grouping by totals the sales made to each client, also in a minimum time and with absolute fidelity of the data obtained. You want to know the total sales of each client in the given month, for this you just have to use the Subtotal tool within the Data menu, both in Microsoft Excel 2010 and in previous versions. Said information is organized in several columns with the following epigraphs: Date, Client and Amount.
With this action, Excel allows you to perform an analysis of the data quickly, making groupings. Suppose you have a list in Excel format that reflects the information about sales. These Microsoft Excel applications in the company are :
To counteract this situation, I explain below a series of actions that Microsoft Excel allows you to carry out and the application of said actions in the company . With these processes you will achieve greater efficiency and you will save time and increase productivity.
Practically all companies have on their computers one of the best known and currently used tools, such as the Microsoft Excel computer program .But in many occasions this powerful computer resource is highly underused .
0 kommentar(er)
