Worksheet table's cells and then click the Quick Analysis tool thatĪutomatically appears in the lower-right corner of the last selectedĬell. To use the Quick Analysis tool, all you have to do is select the Totals and sums to the rows and columns of your new worksheet tables.
![using quick analysis excel 2016 using quick analysis excel 2016](https://pryormediacdn.azureedge.net/blog/2016/1/CreatePivotTable01.png)
The Quick Analysis tool offers a bevy of features for doingĪnything from adding conditional formatting, charts, pivot tables, andĪnd it turns out Quick Analysis is also a whiz at adding running Totals to your Excel 2016 worksheet tables with AutoSum and AutoFill,Įxcel 2016's Totals feature on the Quick Analysis tool is just the Excel inserts SUM (equal sign and all) onto the Formula bar places a marquee around cells B3, C3, and D3 and uses the cell range B3:D3 as the argument of the SUM function.įor those of you who don't have the time or patience for adding On the AutoSum drop-down menu (or press Alt+=). Position the cell pointer inĬell E3 where the first-quarter total is to appear and then select Sum Sales of Jack Sprat Diet Centers in row 3.
#USING QUICK ANALYSIS EXCEL 2016 HOW TO#
In the following figure, check out how to use AutoSum to total the More Functions command on this menu, Excel opens the Insert Functionĭialog box as though you had clicked the fx button on the Formula bar. You need to click its drop-down button and select the name of theĭesired function on its pop-up menu (click Count Numbers on the menu to If you want to use the AutoSum button to insert another function, such as AVERAGE, COUNT, MAX, or MIN,
#USING QUICK ANALYSIS EXCEL 2016 PLUS#
The quicker method to select thisįunction is to press Alt+= (the Alt key plus the equal to symbol on the Simply select the AutoSum button followed by Sum on the drop-down menu on the Home tab when you want to insert the SUMįunction into the current cell. Simply dragging the cell pointer through the block of cells to sum. For that tenth case, you can manually correct the range by Moving dotted line) the correct cell range to total, average, count, and Nine times out of ten, Excel selects (with the marquee or In addition to entering the SUM, AVERAGE, COUNT, MAX, or MINįunctions, it also selects the most likely range of cells in theĬurrent column or row that you want to use as the function's argumentĪnd then automatically enters them as the function's argument.
![using quick analysis excel 2016 using quick analysis excel 2016](https://cdn4-exceldashboardsc.netdna-ssl.com/wp-content/uploads/2020/12/quick-analysis-tool-live-preview.png)
Worth its weight in gold when it comes to entering functions. The AutoSum tool is in the Excel 2016 Editing group on the Home tab