Microsoft Office Tutorials and References
In Depth Information
Examining data by using the
The Quick Analysis Lens provides a wide range of tools that you can use, including the
ability to create an Excel table or PivotTable, insert a chart, or add conditional formatting. You
can also add total columns and rows to your data range. For example, you can click the
Totals tab of the Quick Analysis Lens, and then click Running Total for columns, identified
by the icon labeled Running Total and the blue row at the bottom of the button, to add a
row that calculates the running total for each column.
You can add one summary column and one summary row to each data range. If you select
a new summary column or row when one exists, Excel displays a confirmation dialog box to
verify that you want to replace the existing summary. When you click Yes, Excel makes the
In this exercise, you’ll use the Quick Analysis Lens to analyze data.
SET UP You need the PackageAnalysis workbook located in the Chapter08 practice
file folder to complete this exercise. Open the workbook, and then follow the steps.
Click any cell in the data range.
Press Ctrl+* to select the entire data range.
Click the Quick Analysis button to display the tools available in the Quick Analysis
Click the Totals tab to display the tools on that tab, point to (but don’t click) the Sum
button that has the blue row at the bottom to display a live preview of the effect of
clicking the button, and then click the Sum button to add a sum total to the bottom
of the data range.