Microsoft Office Tutorials and References
In Depth Information
How to Make Your Formulas Function Even Better
Figure 2-19:
The
worksheet after
copying
the SUM
function
formulas
using the fill
handle.
Sums via Quick Analysis Totals
For those of you who don’t have the time or patience for adding totals to
your worksheet tables with AutoSum and AutoFill, Excel 2013’s Totals feature
of the new Quick Analysis tool is just the thing. The Quick Analysis tool offers
a bevy of features for doing anything from adding conditional formatting
(see Chapter 3), charts (see Chapter 10), pivot tables (see Chapter 9) and
sparklines (see Chapter 10) to your worksheet tables. And it turns out Quick
Analysis is also a whiz at adding running totals and sums to the rows and
columns of your new worksheet tables.
To use the Quick Analysis tool, all you have to do is select the worksheet
table’s cells (see Chapter 3 for details) and then click the Quick Analysis tool
that automatically appears in the lower-right corner of the last selected cell.
When you do, a palette of options (from Formatting to Sparklines) appears
right beneath the tool.
To add totals to your selected table data, simply click the Totals button. You
can then use your mouse or Touch Pointer to have Live Preview show you
totals in a new row at the bottom by highlighting Running Total or in a new
column on the right by highlighting Sum (shown in Figure 2-20). To actually
add the SUM formulas with the totals to a new row or column, you simply
click the Running Total or Sum button.
Search JabSto ::




Custom Search