Microsoft Office Tutorials and References
In Depth Information
Tip 69: Using the Quick Analysis Feature
Figure 69-2: A preview of Quick Analysis running totals.
Figure 69-3 shows another example. The range A2:G7 is selected, and Quick Analysis is previewing
the Line Sparklines option in column H.
Figure 69-3: A preview of Quick Analysis Sparklines.
The Quick Analysis options don’t enable you to do anything that you can’t do using
Excel’s normal commands. But sometimes it can you save a bit of time. If you find the
Quick Analysis button annoying, turn if off in the General tab of the Excel Options dialog
box. Deselect the check box labeled Show Quick Analysis Options on Selection.