Place yourself with the mouse in the Send section , next to you two options will appear:.Open an Excel workbook with data or open a new workbook and enter some data.To send Excel sheets once you have the data ready, follow these steps: The Excel program and also the other spreadsheet programs allow you to send Excel files by email. Note : Sometimes the Solver plugin is not loaded in the Excel program, depending on the configuration chosen when initially installing, to activate it you will have to do it from the Office installation CD or from the Microsoft website. In Excel 20 we are going to: Data, Data tools and in Excel 2003 to Tools, Solver and after specifying the Solver parameters in the window that appears you will get the quantity manufactured that leads to profit maximization. These are economic problems of the following type: A company manufactures two articles that report respectively a unit benefit, which is the one we try to maximize, although the company must take into account the restrictions given by the quantity of raw material and the hand not being able to exceed certain quantities, the company wants to know the quantity that each item has to produce to achieve profit maximization.
With this Excel application, calculations are performed to solve linear programming problems , where from a linear function to be optimized (find the maximum or minimum) and whose variables are subject to restrictions expressed as linear inequalities, the end is to obtain optimal values, whether they are maximum or minimum. If when you open the wizard instead of choosing PivotTable you choose PivotChart, a sheet opens with a blank graph that you will elaborate in the same way that I have commented for the PivotTable and as a result you will obtain a graph that combines the indicated information. 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 .