Microsoft Office Tutorials and References
In Depth Information
I’ve Used the Quick Analysis! Now What?
I ve Used the Quick Analysis! Now What?
I ve Used the Quick Analysis! Now What?
The Quick Analysis is cool because you can easily experiment with some
powerful technologies. But the problem could be that you ve added
something to your data, and you might not fully understand how to control
that data. This section guides you on how to further control what you added
with the data lens.
Formatting Category
Formatting Category
All of the visualizations in this category come from Home, Condi-
tional Formatting. In the ribbon drop-down, there are six times as
many variations as in the Quick Analysis.
You can change the defaults by visiting Home, Conditional Format-
ting, Manage Rules.
To read more about these features, see Chapter 31 , Using Data
Visualizations and Conditional Formatting .
Charts Category
Charts Category
Charts are normally created by using Insert, Recommended Charts.
The resulting dialog offers 10 suggested charts on the first tab and
offers all charts on the second tab.
After you have a chart, you can customize it. For information, see
Chapter 32 , Graphing Data Using Excel Charts .
Totals Category
Totals Category
You can replicate the Sum, Average, and Count formulas using the
AutoSum button for totals or the AutoSum drop-down for Average and
Count. The drop-down also offers Max and Min.
The formulas for percentage of total are fine. The formula for run-
ning total is the slow method for calculating running totals. It does
not matter with a 20-row data set. If you have 20,000 rows, however,
you need to consider changing to a simple formula that adds the cell
above to the cell to the left.
Formulas are discussed in Chapter 8 , Understanding Formulas ,
and Chapter 9 , Controlling Formulas .
Tables Category
Tables Category
The first icon in the Tables category is Format as a Table. This is
discussed fully in Chapter 19 , Fabulous Table Intelligence .
Search JabSto ::




Custom Search