You can look at data from many different angles to provide insights – in tables with colored cells or arrows using conditional formatting, in various charts, in PivotTables and so on. One of the many strengths of Microsoft Excel is the ability to analyze data. Understand your data better using “Quick Analysis” This will without a doubt save you a lot of time and you will be able to finish your spreadsheets a lot faster. In Excel 2013 you can just start writing the names the way you want them in the first couple of cells and then Excel 2013 fills the rest of the range for you! The “Flash Fill” algorithm understands a number of different patterns and if it doesn’t understand completely, you can just add a couple more cells the way you want them and Excel 2013 will try again. You want to split this up into two columns– one with the first name and one with the last name, and you only want the first letters to be capitalized. Imagine you have a column with names in capital letters (like the image on the right). This is where Microsoft Excel 2013 works its’ magic. When they do, they don’t know how to use the tools so they end up cleaning the data up by hand instead. The problem is that most normal users don’t perform these tasks very often. There have always been a large number of tools available in Excel to modify and clean up data. Finish you spreadsheets faster using “Flash Fill” In this blog post, I’ll share with you my five personal favorite benefits of Microsoft Excel 2013. You will be amazed by the clever new functionality that, not only will save you a lot of time, but also help you produce better results. Even though there are a lot of great new enhancements in Word, PowerPoint, Outlook and OneNote that will for sure increase productivity, Microsoft Excel 2013 is in a league by itself. Business Productivity > Blog > The benefits of Microsoft Excel 2013 The benefits of Microsoft Excel 2013ĭuring the past few weeks, I have been writing blog posts about the benefits of the applications in the new Microsoft Office 2013.
0 kommentar(er)
