Quick Analysis Smart Tag

Added in Excel 2013.
This is a smart tag that appears in the bottom right corner of your selection
Displays the Quick Analysis gallery

Displaying the Smart Tag

When you highlight a group of cells a quick analysis button appears in the bottom right corner of your data.
Pressing this will display live previews of various different ways of displaying this data

Formatting

This is conditional formatting

Charts

Totals

Tables

Sparklines