Microsoft Office Tutorials and References
In Depth Information
Understanding Data Analysis Choices
10
The Quick Analysis button offers a variety of ways to analyze selected data. This section provides
CHAPTER
Understanding Data Analysis Choices
an overview of the analysis categories and the choices offered in each category.
Formatting
Use formatting to highlight parts of your data. With formatting, you can
add data bars, color scales, and icon sets. You can also highlight values
that exceed a specified number and cells that contain specified text.
Charts
Pictures often get your point across better than raw numbers. You can
quickly chart your data; Excel recommends different chart types, based on
the data you select. If you do not see the chart type you want to create,
you can click More Charts.
Totals
Using the options in the Totals category, you can easily calculate
sums — of both rows and columns — as well as averages, percent of
total, and the number of occurrences of the values in the range. You can
also insert a running total that grows as you add items to your data.
Tables
Using the choices under the Tables category, you can convert a range to a
table, making it easy to filter and sort your data. You can also quickly and
easily create a variety of PivotTables — Excel suggests PivotTables you
might want to consider and then creates any you might choose.
Sparklines
Sparklines are tiny charts that you can display beside your data that
provide trend information for selected data. See Chapter 12 for more
information on sparkline charts.
187
Search JabSto ::




Custom Search