![where is the quick analysis tool in excel where is the quick analysis tool in excel](https://cdn.arstechnica.net/wp-content/uploads/2012/07/excel-9-quick-anal-suggested-pivot-tables.jpg)
From within the category, point at an option to see a preview of that analysis choice, in this case % Total.Ĥ.
#Where is the quick analysis tool in excel mac
Note, Mac users, on the Home tab, use the Sum tool. You need to divide H5, the 2006 Store 1 turnover, by cell G10, the total turnover of all five stores. By using the Quick Analysis tool, Sum the Quarter 1 sales, and then copy the formula across for the remaining Quarters. In the example shown, you want to calculate what percentage the 2006 Turnover in Store 1 was of Total 2006 figures. Open a workbook with figures that need percentages and click in the cell where you want your answer. You may have to work out the sales in each store as a percentage of the total sales over all stores.