Together with the new release of the 2013 version of Microsoft Office, most people are curious about what's new in Excel 2013 and what modifications have taken place in the most well-liked software program on the planet. The latest spreadsheet program has not undergone any drastic changes, but there are a few tweaks that make it much easier to work with for equally novice and veteran number-crunchers. New apps and Excel 2013 new features enable users to browse through more quickly and compile data with significantly less input.
Start out At the Beginning
The new Office 2013 software package utilizes a start screen that is different from the prior packages. In contrast to the older versions of Excel in which users chose between workbooks, calendars, and to-do lists, the start screen for Excel 2013 loads up the most current files automatically. This allows you to retain the worksheets pinned to a list of current activity to ensure that it is always visible and comes up free of any loading. You are able to automatically import existing workbooks or templates from your hard drive, a disk, as well as the cloud. New templates can be pinned alongside the current files to better let you boot up your work.
Look Towards the Rear
One of the popular functions of Office 2010 was the Backstage View, a way of calling up several files so as to import info with out swapping out tabs or pulling up a whole new program. This View has been re-vamped for Microsoft Office 2013, with a tab that lets you pull up recently accessed documents. This list can consist of e-mail chains, laptop or computer drives, lately browsed sites, and some online databases. What is more, you can make use of the View to open a SkyDrive account that shares files between registered users.
Seeing The Patterns
Pattern recognition software has come a long ways since the days of Office detecting what words you're about to type based only on the initial handful of letters. Microsoft's new algorithm can see patterns in numerical information. The Flash Fill tool of Excel 2013 allows you to find patterns inside the numbers you input and then automatically fill remaining entries using the data. For those who need to apply a common figure to existing numbers, for example a rise for inflation, the Flash Fill can without difficulty and instantly plug in numbers that would previously need making use of the calculator function. This applies to numbers at the same time as names and time, in order that you can Flash Fill the projected figures months and years from now.
Ask To get a Recommendation
One of several intuitive new capabilities of Excel 2013 certainly is the Recommended Charts app. This pulls up a subset of the figures you have input inside of a chart form, whether bar graph or pie chart or numbers over time. By inserting recommended charts, it is possible to click around to see how your numbers would appear in a number of visual styles. All you must do when you see the graph that appears correct is hit OK and it will be generated and added to your document.
Analyze In Rapid Time
Being able to work with all your info as quickly as it has been inserted into each cell is amongst the most exciting parts of what's new in Excel 2013. The Quick Analysis allows you to pull up a brick of cells or information and then play around with it. You may use Quick Analysis in an effort to format your numbers by dates or numerical orders; you may build new charts; you are able to total up the running tally; or you can make tables for other users. After previewing each tally or chart, only click OK and is going to be applied towards the numbers.
View Each Number In Each Dimension
The last versions of Excel had a compatible Power View app. In Office 2013, this app is now integrated within the application. Power View is fantastic for turning a bunch of numbers into a presentable format in case you want to make a presentation or want the equivalent of a PowerPoint slide for the information. Create a working title, organize the info as you need, filter any unnecessary parts, and use any texts or themes which you really feel work best for the presentation. Preview it before it is ready to go and put it in an e-mail or on a projector.
As you may see Excel 2013 brings some decent new features to the table. So now it is up to you to consider if the latest capabilities warrant an upgrade.
Start out At the Beginning
The new Office 2013 software package utilizes a start screen that is different from the prior packages. In contrast to the older versions of Excel in which users chose between workbooks, calendars, and to-do lists, the start screen for Excel 2013 loads up the most current files automatically. This allows you to retain the worksheets pinned to a list of current activity to ensure that it is always visible and comes up free of any loading. You are able to automatically import existing workbooks or templates from your hard drive, a disk, as well as the cloud. New templates can be pinned alongside the current files to better let you boot up your work.
Look Towards the Rear
One of the popular functions of Office 2010 was the Backstage View, a way of calling up several files so as to import info with out swapping out tabs or pulling up a whole new program. This View has been re-vamped for Microsoft Office 2013, with a tab that lets you pull up recently accessed documents. This list can consist of e-mail chains, laptop or computer drives, lately browsed sites, and some online databases. What is more, you can make use of the View to open a SkyDrive account that shares files between registered users.
Seeing The Patterns
Pattern recognition software has come a long ways since the days of Office detecting what words you're about to type based only on the initial handful of letters. Microsoft's new algorithm can see patterns in numerical information. The Flash Fill tool of Excel 2013 allows you to find patterns inside the numbers you input and then automatically fill remaining entries using the data. For those who need to apply a common figure to existing numbers, for example a rise for inflation, the Flash Fill can without difficulty and instantly plug in numbers that would previously need making use of the calculator function. This applies to numbers at the same time as names and time, in order that you can Flash Fill the projected figures months and years from now.
Ask To get a Recommendation
One of several intuitive new capabilities of Excel 2013 certainly is the Recommended Charts app. This pulls up a subset of the figures you have input inside of a chart form, whether bar graph or pie chart or numbers over time. By inserting recommended charts, it is possible to click around to see how your numbers would appear in a number of visual styles. All you must do when you see the graph that appears correct is hit OK and it will be generated and added to your document.
Analyze In Rapid Time
Being able to work with all your info as quickly as it has been inserted into each cell is amongst the most exciting parts of what's new in Excel 2013. The Quick Analysis allows you to pull up a brick of cells or information and then play around with it. You may use Quick Analysis in an effort to format your numbers by dates or numerical orders; you may build new charts; you are able to total up the running tally; or you can make tables for other users. After previewing each tally or chart, only click OK and is going to be applied towards the numbers.
View Each Number In Each Dimension
The last versions of Excel had a compatible Power View app. In Office 2013, this app is now integrated within the application. Power View is fantastic for turning a bunch of numbers into a presentable format in case you want to make a presentation or want the equivalent of a PowerPoint slide for the information. Create a working title, organize the info as you need, filter any unnecessary parts, and use any texts or themes which you really feel work best for the presentation. Preview it before it is ready to go and put it in an e-mail or on a projector.
As you may see Excel 2013 brings some decent new features to the table. So now it is up to you to consider if the latest capabilities warrant an upgrade.
About the Author:
Want to sharpen your Excel skills? See our online excel training or browse the extensive online it training catalog on our site.