Download Quick Reference Card
Excel 2013 Quick Reference Card 
(restricted to campus)
Three New Features in Excel 2013
1. Quick Analysis
Quick Analysis formatting lets you convert your data into a chart or table with formatting in two steps or less.
- Click the Quick Analysis button at the bottom right of your selected data (or press CRTL + Q) and make your selection.
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.
