Microsoft Excel 
ITTraining@sgul.ac.uk Page 32 St. George’s Information Services 
UNDERSTANDING QUICK ANALYSIS 
 
 
 
 
  
 
The Quick Analysis tools were developed in 
response to the fact that users weren’t using or 
even aware of the more powerful analytical tools 
found in Excel. So Excel decided to combine 
Live Preview with some of these tools to create 
the Quick Analysis tools. 
The Quick Analysis Button 
The Quick Analysis button 
appears when a range is 
selected in a worksheet. 
Clicking on the button displays 
the Quick Analysis gallery 
which contains quick analysis 
tools that can be applied to the 
selected data. 
The tools have been organised 
along tabs at the top – 
FORMATTING, CHARTS, 
TOTALS, TABLES, and 
SPARKLINES. 
When you click on a tab, 
options specific to that tab are 
presented. 
Using Quick Analysis Tools With Live 
Preview 
Most of the Quick Analysis tools in the 
Quick Analysis gallery provide a Live 
Preview of the changes in the worksheet 
when you point to an option. 
This is very useful if you are not sure of the 
formatting or type of analysis you require as it 
provides you with a preview of what the data 
would look like if you selected that specific 
option. 
At the right we have selected only the totals 
from the worksheet shown above. We have 
pointed to options from the TOTALS tab (% 
Total and Average) and from the 
FORMATTING tab (Data Bars). 
Live Preview has either presented another 
row of analysed data or has formatted the 
selection accordingly. 
All of these tools are also available on the 
ribbon but using the Quick Analysis tools is 
much quicker.