Microsoft Excel 
ITTraining@sgul.ac.uk Page 35 St. George’s Information Services 
QUICK TOTALS 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
The TOTALS tab in the Quick Analysis gallery 
has some useful tools and options to help you 
build your worksheet. You can use the options to 
analyse data and perform alternate arithmetic 
operations (e.g. AVERAGE instead of SUM) or use 
the options to create the totals and calculations in 
the first place.   
Try This Yourself: 
Open 
File Before starting this 
exercise you MUST 
open the file E1355 
Quick Analysis_3.xlsx… 
 
Click in cell B5, hold 
down , then click in 
cell E9 to select the 
range B5:E9 
 
Click on the Quick 
Analysis button, then 
click on the TOTALS tab 
to see the calculation 
options for this range 
 
Point to Vertical Sum to 
see a preview of the 
totals for each column 
 
Point to Horizontal 
Sum to see a preview of 
the totals for each row 
 
Point to the other 
options and study the 
results – do not click on 
any at this stage 
 
Click on Vertical Sum 
to create column totals 
 
Click on the Quick 
Analysis button again, 
click on the TOTALS 
tab, then click on 
Horizontal % to see the 
percentages for each 
day of the week 
 
3 
6 
For Your Reference… 
To create Quick Totals in a worksheet: 
1. Select the range to be totalled/calculated and 
click on the Quick Analysis button 
2. Choose the desired calculation methodology 
from the TOTALS tab 
7 
Handy to Know… 
 Always check any operation that performs 
calculations and embeds formulas for you to 
ensure that the correct cells and ranges are 
included in totals.