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.

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

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.

Tables Category

Tables Category

•
The first icon in the Tables category is Format as a Table. This is