The following are the new Functions introduced in Excel 2013 along with the Category: There are couple of other new functions in Date and Time, Financial, Information, Logical, Lookup and reference, Statistical, Text and Web function categories. More than half of the new functions belongs to Math & trigonometry, and Engineering Functions. Ribbon Menu -> Insert Tab -> Charts Group -> Recommended ChartsĮxcel 2013 came up with 50 new Functions. Once user selects the data in worksheet and clicks the recommended charts command to get a customized set of charts that Excel think will fit best with the data. User can simply peek into different charts recommended by Excel to selects the best. Shortcut for the Quick Analysis is Ctrl+EĮxcel 2013 recommends user, the most suitable chart based on the data. Ribbon Menu -> Home Tab -> Editing Group -> Fill Command Dropdown -> Flash Fill (Or) Ribbon Menu -> Data Tab -> Data Tools Group -> Flash Fill The navigation to the Flash Fill is below: Instead using the combination of text formula, we can split the first name by simply using the Flash Fill option. In the Below Example, the First Name should appear in the B Column. Flash Fill is an amazing tools which helps user to Concatenate, Merge, Split text in Cells without using any single formula. Excel automatically fills the values based on the sample user provides in the first cell. One of the diamond in Excel 2013 version is Flash Fill option. Shortcut for the Quick Analysis is Ctrl+Q Once clicks, user can find the Quick Analysis tool bar. Once the user selects the data, an icon appears on the bottom corner of the right side. User can have preview before apply any of the tools and make his choice stick in just one click. Use the Quick Analysis tool to Quickly and easily analyse data with some of Excel’s most useful tools, such as Formatting, Charts, Totals, Tables, Sparklines. In Excel 2013, each workbook has its own top level Excel no longer supports the option to display multiple workbooks in a single window.
![use the quick analysis tool in excel 2013 use the quick analysis tool in excel 2013](https://excelchamps.com/wp-content/uploads/2020/04/3-check-if-it-is-disabled.png)
Till the Version 2010, Excel supports multiple document interface, which means under one window, there can be lot of workbooks. The following is the summary of what’s new in Excel 2013 versus Excel 2010. Microsoft Excel version 2013 already is already in market. Microsoft is continuing the same user interface from Excel 2007 to Excel 2010 with additional improved features which includes high performance in computing, improved charts, Sparklines, Slicers etc. Than anything discussed above, User Interface is one of the greatest advantage with Excel 2007 than Excel 2003.
![use the quick analysis tool in excel 2013 use the quick analysis tool in excel 2013](https://www.avantixlearning.ca/wp-content/uploads/2016/05/ExcelQuickAnalysisSmartTag.png)
Excel 2007 lifts this restriction, allowing 10,48,576 (2^20) Rows and 16,384 (2^14) Columns.Īlong with the huge data storage support, introduction of new functions, tables, improvement in Conditional Formatting, Filtering and Sorting by Colour, Formula Nesting limitation have also been introduced with Version 2007. One of the most important changes from Version 2003 to Version 2007 has to do with the amount of data user can store in any one worksheet. There was a drastic change when Microsoft released Version 2007 from 2003.
![use the quick analysis tool in excel 2013 use the quick analysis tool in excel 2013](https://i.ytimg.com/vi/eSOer8lVVZU/maxresdefault.jpg)
Microsoft is trying their level best to add more wonderful features on each release of new version.
![use the quick analysis tool in excel 2013 use the quick analysis tool in excel 2013](https://jeffprom.files.wordpress.com/2013/03/quick-analysis-icon-set.jpg)
As we all know, MS Excel is one of the extraordinary spreadsheet, which can be useful for calculations, analysis and formatting.