Microsoft Office Tutorials and References
In Depth Information
Analyzing data instantly by using the Quick Analysis tool
Analyzing data instantly by using the Quick Analysis tool
One of the refinements in Excel 2013 is the Quick Analysis Lens,
which brings the most commonly used formatting, charting, and
summary tools into one convenient location. You have a wide
range of tools available to you, 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 Totals and then Running
Total for columns, identified by the icon labeled Running Total
and the yellow column at the right edge of the button, to add a
column that calculates the running total for each row.
Summarize data by using Quick Analysis
1 Select the cell range that you want to summarize.
2 Click the Quick Analysis action button to display the Quick Analysis
tools available to you.
3 Click the label representing the category of tools that you want to
Click the button representing the summary that you want to create.
TIP 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 change.
Search JabSto ::

Custom Search