Microsoft Office Tutorials and References
In Depth Information
Tip 69: Using the Quick Analysis Feature
Using the Quick Analysis Feature
One of the new features in Excel 2013 is Quick Analysis. When you select a range of data, Excel
displays a Quick Analysis button in the lower-right corner of the range. Click the button to view some
options, shown in Figure 69-1. You can also press Ctrl+Q on the keyboard to display the Quick
Figure 69-1: Quick Analysis options for the selected range.
The words along the top (Formatting, Charts, Totals, Tables, and Sparklines) are menu items. Click an
item and a different set of icons appears. When you hover your mouse over an icon, Excel sometimes
displays a preview of how the option will appear.
The options available depend on the type of data in the selected range. For example, if the range
contains only text, the Sparklines option will not be available.
Figure 69-2 shows an example of a range of numbers in column C, with a preview of the Quick
Analysis option to create running totals in column D.