Excel is widely used in businesses around the world, you may feel that it has a lot of features, but Microsoft added several features in Excel 2013, Flash fill is perhaps the most important one, it makes Excel easy to use. This feature will automatically reformat and rearrange the data based on your use of Excel 2013, and it will automatically compute the rest of the data without using a formula or macro. When I tried it, I found it wasn't perfect every time, but in terms of formatting it certainly helped keep the document neat and tidy.
The new quick Trend feature provides a chart that can analyze historical time series data. New Excel add-in can scan spreadsheets for errors, invalid links, and inconsistencies. Some users or system administrators want to move documents to a new location, but worry about breaking existing links, and they will find this scanner useful.
Microsoft also provides a new way to visualize data in Excel spreadsheets. Quick Analysis Lens (Rapid analytical Mirror) can recommend the data presentation method to you. It also has a recommended chart feature that allows you to recommend the best chart type based on the data pattern. Chart animations also provide a visual way to see how data moves through a chart when the change takes effect. Microsoft also provides a code code-named Agaves (agave) that allows developers to create custom add-ons that mix Web data with data from Excel worksheets. This web extension is also available in other applications, but it is apparently primarily for Excel users and corporate users. Like word 20,131, Excel 2013 also supports the present online presentation feature, allowing users to share workbooks on the web in real time. In addition, there are two new features in office Professional Plus and above, one for quick Explore (fast browsing), for crosstab analysis of large datasets, and power view (brute force), which enables data, Charts and graphs are compiled into a single view.