get cumulative total using quick analysis tool in excel

Click Average and you will get a new line with the average total at the end of the data and so on. For example if you choose Sum when you data is highlighted it would give you a new line of data under your existing data with the sum of each of your columns. The Totals option, allows you to create a totals line at the bottom of your selected data. Again if you hover over the chart types you will see the chart before deciding on the one to choose. The Charts option, allows you to create a chart from the selected data. Also, if you just hover over these icons you will see a preview before you click, as when you click you have applied the format and would need to clear format to delete it. Note that the last icon on the formatting view us clear format, so if you apply a format like Colour scale and then decide you do not like it you can clear it very easily. Very quickly you can apply the options of data bars, colour scales and so on. The formatting option, allows you to apply conditional formatting options without having to go to the HOME tab and choosing Conditional formatting. You can see from this screen that there are 5 possible options.

When you click on this tool the following screen will appear.

Once you select your data, if the option is applicable, you will see the Quick Analysis tool appearing in the bottom right of your selection.

Get cumulative total using quick analysis tool in excel