Latest Blogs from SBS and Company LLP

    What's new in MS- Excel 13?

    As we all know, MS Excel is one of the extraordinary spreadsheet, which can be useful for calculations, analysis and formatting. Microsoft is trying their level best to add more wonderful features on each release of new version. 

    There was a drastic change when Microsoft released Version 2007 from 2003. 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. Excel 2003 is confined to only 65,536 (2^16) Rows and 256 (2^8) Columns. Excel 2007 lifts this restriction, allowing 10,48,576 (2^20) Rows and 16,384 (2^14) Columns. 

    Along 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. Than anything discussed above, User Interface is one of the greatest advantage with Excel 2007 than Excel 2003. 

    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. 

    Microsoft Excel version 2013 already is already in market. The following is the summary of what’s new in Excel 2013 versus Excel 2010. 

    1. One Workbook – One Window: 

    Till the Version 2010, Excel supports multiple document interface, which means under one window, there can be lot of workbooks. Excel no longer supports the option to display multiple workbooks in a single window. In Excel 2013, each workbook has its own top level

     

    window and ribbon menu.

    1. Quick Analysis: 

    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. User can have preview before apply any of the tools and make his choice stick in just one click. 

    Once  the  user  selects  the  data,  an  icon appears on the bottom corner of the right side. Once clicks, user can find the Quick Analysis tool bar.

     Shortcut for the Quick Analysis is Ctrl+Q 

    1. Flash Fill: 

    One of the diamond in Excel 2013 version is Flash Fill option. Excel automatically fills the values based on the sample user provides in the first cell. Flash Fill is an amazing tools which helps user to Concatenate, Merge, Split text in Cells without using any single formula. 

    In the Below Example, the First Name should appear in the B Column. Instead using the combination of text formula, we can split the first name by simply using the Flash Fill option.

    The navigation to the Flash Fill is below:

    Ribbon Menu -> Home Tab -> Editing Group -> Fill Command Dropdown -> Flash Fill (Or) Ribbon Menu -> Data Tab -> Data Tools Group -> Flash Fill 

    Shortcut for the Quick Analysis is Ctrl+E 

    1. Chart Recommendations: 

    Excel 2013 recommends user, the most suitable chart based on the data. User can simply peek into different charts recommended by Excel to selects the best. 

    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. 

    The navigation to the Flash Fill is below: 

    Ribbon Menu -> Insert Tab -> Charts Group -> Recommended Charts 

    1. New Excel Functions: 

    Excel 2013 came up with 50 new Functions. More than half of the new functions belongs to Math & trigonometry, and Engineering Functions. There are couple of other new functions in Date and Time, Financial, Information, Logical, Lookup and reference, Statistical, Text and Web function categories. 

    The following are the new Functions introduced in Excel 2013 along with the Category:

     

     

     

    Tags:

    Subscribe SBS AND COMPANY LLP updates via Email!