Excel 2013 Quick Reference Card (restricted to campus)
Quick Analysis formatting lets you convert your data into a chart or table with formatting in two steps or less.
2. Flash Fill
Flash Fill fills down or across a pattern it recognizes in your data. In this way you can split or join columns of data.
- Click on the first cell where you want to fill the pattern, as shown in the example below:
- Click Flash Fill on the Edit group on the Home tab:
- Flash Fill enters data based on the pattern it recognizes, and you can click the Flash Fill icon for options, as shown in the example below:
3. Chart Elements
Select a chart and click the Chart Elements button on the top right corner to select elements that can add more value to the chart such as Data Table, Error Bars, Timeline, Titles and more.
Learn more about what's new in Excel 2013 at microsoft.com.
Contact the Help Desk if you have questions.