Here are some of the coolest new features in Excel 2013
1. Flash Fill
The coolest new feature in Excel 2013 is Flash Fill. Flash Fill looks at the data you are entering and compares that to data in adjacent columns and then based on any patterns suggests a fill done option.
A great example is if you have a column of full names – and you want to extract the first names, you can begin by typing only the first names in the adjacent column, after one or two rows Flash Fill will complete the task.
Timelines are a great new reporting feature that allows you to filter data quickly in a large pivot table or pivot chart based on a date range. Great for management meetings when quick comparison of data by period is needed.
3. Recommended Charts
There are several improvements to Charting in Microsoft 2013 including animated charting. Our favorite new feature though is Recommended Charts, which is particularly useful for inexperienced users.
Simply point the cell pointer anywhere the table of data and click Insert->Recommended Charts. Excel then displays a Insert Chart dialog box with a subset of chart types that are appropriate to the data you've selected.
4. Quick analysis tool
This new Quick Analysis tool will speed up your workflow. The tool appears on the bottom right when you select any range of data.
It then allows you quickly apply conditional formats, create a chart or pivot table, total up columns or row and add sparklines.
5. Excel in the Cloud
In line with all computing moving towards cloud computing, Excel 2013 has save options that allow you to save files directly to your SkyDrive. Storing files in the cloud make them accessible to any device you have which has Excel running or if you have an Office 365 subscription you can review and edit most files in any major browser. There is also a neat feature allow you to invite someone to review a file you have saved in the cloud.
Training Connection offers MS Office Training in Chicago and Los Angeles, as well as Onsite excel training countrywide.