Recommended Pivot Table
For most of us the Pivot table is a complex tool. Now, Excel 2013 summarizes your data with preview of different pivot table.
After the selection of your data, a small icon appears in the bottom-right, in order to help you to select the best tool (conditional formatting, sparklines, charts, and tables). Just click on one of these options to apply it to your data.
The FlashFill is the easiest way to reformat and rearrange your data without using formula. You just have to write your rules and Excel apply it to the rest of the data.