Dress Up Your Excel Data
New Flash Fill reformatting in Excel makes rearranging data much easier. This feature helps Excel learn and recognize your patterns and auto complete the remaining data cells without all the manual formatting. Analyzing data used to involve quite a bit of work, but now it only takes a few steps to quickly create different types of charts, including line and column charts, or add miniature graphs (called sparklines). You can also apply a table style, create PivotTables, quickly insert totals, and apply conditional formatting.