Excel 2013: An overview of all new functions
Excel 2013 comes with many new functions that make working with your data even easier. We will explain the most important innovations to you.
New Excel 2013 function: templates
Excel now comes with numerous templates to help you get started in new projects.
- In this way, you can start your bills, annual reports or film lists directly without having to create a professional table.
- Simply click on one of the templates that suit your tasks and get started.
- Of course, you can easily adjust the design and content details.
Flash preview function in Excel 2013
The flash preview completes your entries reliably and quickly.
- The tool automatically recognizes what you are working on and what the pattern of your data is.
- Unlike in the case of automatic completions, not only the current field is filled automatically, for example, but the entire column.
- If you don't like the suggestions, just type over the preview. The suggestions then evolve and adapt as necessary.
The Excel 2013 quick analysis function
Data can now be formatted and clearly viewed in Excel 2013 with just a few clicks.
- When you select a data record, a quick selection menu appears in the lower right corner.
- You can also quickly and directly set known functions such as conditional formatting.
- You can display the individual formatting as a preview and then apply it with one click. All you have to do is move the mouse pointer over the respective option.
New in Excel 2013: Function for diagram recommendations
There was a quick selection for diagrams in the past, but now Excel gives you explicit recommendations as to which diagram best suits the selected data set.
- Of course, you can also have the different suggestions displayed in a simple preview.
- It has also become much easier to edit charts. Just click on the object and on the right side you will find well-sorted quick selection symbols.
- Here you can change elements, colors, style and of course the displayed data sets. With just a few clicks, you can set highlights, sorting, filters and much more.
Data sharing: functions in Excel 2013 for sharing documents
Excel 2013 makes it even easier for you to share data with your team in collaboration with other Microsoft products.
- You can now start presentations directly from Excel via Lync.
- Skydrive has also become a direct storage option.
If you want to test these functions extensively, we will next explain how you can legally extend the test period of Office 2013.