Pivot Tables and Pivot Charts

There are 7 types of screen elements. List of pivot table fields, report filter area, column label area, row label area, value area, layout portion, and field portion. Some people think that there are several ways to put the data in a list into a pivot table, but there are only two ways. You must first drag the field name from the top field section and place it in one of the four areas of the bottom layout section. For the field name of the top field section, Excel places the field in the default location based on the data type of the field.

Excel makes it easy to create output and reports for sharing with other users by saving data, performing numerical calculations, formatting cells, and adjusting the layout. Advanced functions such as subtotals, power pivot tables and pivots, analysis toolkits, and many templates make it easy to perform a variety of tasks. It can also be integrated with SQL Server analysis services (business intelligence). Adjusting the result is also very easy to get the exact layout, font, color etc you want.

If you do not know, PivotTable is one of the most powerful features of Excel. It is a tool for analyzing data. Learning to use PivotTables is essential for all employees in the organization. The faster you acquire, the more quickly you can see the benefits of converting common business data to useful information. The next thing you need to do is to find the Salesperson field (upper right corner), drag it to the ROWS area (left clicking) and drop it there. You can see that the sales representative's name is in the left corner. In the same way, drag the revenue to the VALUE area. In the following figure, the total income of each employee is automatically calculated by Excel.

Now that the adj_close_acq_date_modified data frame has been created, we use a very powerful panda function called pivot_table. If you are familiar with Excel's PivotTable, this feature rotates the data based on a single index or multiple indices, specifies the value to calculate and the column to rotate, and uses the agg function (using numpy) It is similar to how to do. Once completed, you can calculate the last column you want. Unless the stock price is evaluated on the most recent trading day (in that case it will be zero), taking it and always dividing it by Note will always be negative (this is usually a very good sign). in this case)

Besides being good at data management, Excel is an excellent business analysis tool. With PivotTable included in Excel, you can create seconds to automatically sort, summarize, and aggregate data stored in a table or spreadsheet to display summary data, making it easy to store large amounts of data You can analyze it. Using table Excel, you can also create professional forms that include a simple form with a box, as well as an option button that allows you to select an answer, and a drop-down list to select a specific answer from a list of items. Along with graphs, you can compile test or test responses using Excel and analyze the course overview (for teachers) or team (for supervisor).