In last post we listed out five new Microsoft Excel 2013 features. In this blog post, we will 10 more new useful features of Microsoft Excel 2013.
- 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.
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
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.
- Search in Filters
Users can search for filters in interactive way in Filters. Users can sort by colors too.
More themes and Styles have been added in MS Excel 2010 with live preview.
Many options for Paste have been added such as No Borders, Keep Source Formatting, Picture, Linked Picture et al.
- Picture Editing Tools
Picture editing tool allows users to remove background, artistic effects, smart arts layouts, corrections etc.
- XLL Software Development Kit
Lots of improvement has been added for Developers. There are improvements in performance perspective for printing, charts have been done.
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.
- 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.
- #2 QAInsights Podcast – 18.104.22.168 and many more - April 9, 2018
- QAInsights Podcasts – First Episode - March 30, 2018
- Rajini Makkal Mandram Vs Makkal Neethi Maiyam – a tech comparison - March 5, 2018
- Do not blame it on server! - February 26, 2018
- Unboxing Apache JMeter 4.0 - February 13, 2018