Microsoft Excel 2013 Features Part Two

In last post we listed our five new Microsoft Excel 2013 features. In this blog post, we will 10 more new useful features of Microsoft Excel 2013.

1. Conditional Formatting

New sets of Icons have been introduced in Conditional Formatting. More options have been added in Data bars. Conditional formatting allows user to refer values from other worksheets in active workbook.

2. PowerPivot

PowerPivot add-in enables users to perform analysis on millions of records in MS Excel quickly. PowerPivot allows users to perform, create relationships, and create Pivot Tables/Charts. For more details visit PowerPivot.

3. Functions

MS Excel added more accurate functions using by across fields such as engineering, statistical et al. In Excel 2013, users should be able to insert functions from the web services as well.

4. Search in Filters

Users can search for filters in interactive way in Filters. Users can sort by colors too.

5. Themes

More themes and Styles have been added in MS Excel 2010 with live preview.

6. Paste

Many options for Paste have been added such as No Borders, Keep Source Formatting, Picture, Linked Picture et al.

7. Picture Editing Tools

Picture editing tool allows users to remove background, artistic effects, smart arts layouts, corrections etc.

8. XLL Software Development Kit

Lots of improvement has been added for Developers. There are improvements in performance perspective for printing, charts have been done.

9. Co-Authoring

Co-Authoring using Excel Web App, allows multiple users to work on single workbook concurrently. If you are working on your project sheet from home, at the same time, your colleagues also can work at office in same project sheet.

10. Flash Fill

Flash Fill is an excellent feature in Excel 2013. It saves time and increases productivity and usability for people who are working with loads of data. Instead of using Text to Columns feature, just start typing, excel will finish your work instantly.

In next blog post, we will see some more new Microsoft Excel 2013 features. If you are enjoying our articles, please subscribe for our free weekly newsletter.