Economics and Finance for Microsoft Excel- myassignmenthelp.com

Question: Discuss about theEconomics and Finance for Microsoft Excel. Answer: Pivot Table: A pivot table is a statistical tool, useful for arranging and summarizing data in a tabular structure, which can be done in Microsoft Excel. The pivot table has provision for reorganization of rows and columns of a data set according to need and for getting the desired outcome. This operation is particularly helpful in handling and interpreting big data sets as this statistical tool does not change the data but helps in viewing and interpreting the same data from different perspectives (Dierenfeld Merceron, 2012). Tips for Pivot Table: There are several tricks and tips which can be beneficial for using Pivot Table more efficiently (Walkenbach, 2013): To find the summarization of the desired information, the following path can be followed: Pivot Table Tools - Analyze - Field Settings - Summarize value field by For proper interpretation of numerical data: Pivot Table Tools - Analyze - Field Settings - Number Format To add the personally calculated metrics: Pivot Table Tools - Analyze - Fields, Items and Sets - Calculated Field In cases where there is an error message: Pivot Table Tools - Analyze - Options - For error values show For assessing the grand total: Pivot Table Tools - Analyze - Options - Totals and Filters - Grand Totals For slicing for the derivation of the desired data: Pivot Table Tools - Analyze - Insert Slicer For slicing the concerned data such that data can be derived for a particular time period to test their value: Pivot Table Tools - Analyze - Insert Timeline For grouping the data according to categories desired: Select Data - Right Click - Group, Subtotal Apart from this many other convenient functions can be done with the help of this tool which are also easy to understand and implement. References Walkenbach, J. (2013).Excel 2003 bible(Vol. 36). John Wiley Sons. Walkenbach, J. (2013).Excel 2013 formulas. John Wiley Sons.