Due to the new release of the 2013 version of Microsoft Office, many people are wondering what exactly is new in Excel 2013 and what modifications have taken place in the most common software program on the planet. The recent spreadsheet tool hasn't undergone any drastic changes, but you'll find a few tweaks that make it less complicated to utilize for both novice and veteran number-crunchers. New apps and Excel 2013 new functions permit users to browse through more quickly and compile data with significantly less input.
Start At the Beginning
The new Office 2013 software makes use of a start screen that is certainly 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 lets you keep the worksheets pinned to a selection of recent activity so that it is always visible and comes up without any loading. It is possible to automatically import current workbooks or templates from your hard drive, a disk, or the cloud. New templates may be pinned alongside the existing files to far better let you boot up your work.
Look Towards the Rear
One of many well-known features of Office 2010 was the Backstage View, a way of calling up different files so as to import details with out swapping out tabs or pulling up a different software program. This View has been re-vamped for Office 2013, with a tab that allows you to pull up recently accessed documents. This list can include e mail chains, laptop or computer drives, recently browsed locations, and some online databases. What's more, you are able to use the View to open a SkyDrive account that shares files among registered users.
Seeing The Patterns
Pattern recognition software has come a long ways since the days of Office detecting what words that you're about to type founded only on the first few letters. Microsoft's new algorithm can see patterns in numerical information. The Flash Fill tool of Excel 2013 allows you to find patterns within the numbers you input and then automatically fill remaining entries with all the info. For those who need to apply a common figure to existing numbers, such as an increase for inflation, the Flash Fill can very easily and instantly plug in numbers that would previously need employing the calculator function. This applies to numbers as well as names and time, in order that you could Flash Fill the projected figures months and years from now.
Ask For a Recommendation
Among the list of intuitive new capabilities of Excel 2013 is definitely the Recommended Charts app. This pulls up a subset of the figures you have input in a chart form, whether bar graph or pie chart or numbers over time. By inserting recommended charts, you may click around to view how your numbers would appear in numerous visual shapes. All you must do once you find the graph and or chart that looks appropriate is hit OK and it will be created and added in your document.
Analyze In Rapid Time
Being able to work with the data as soon as it has been inserted into every cell is among the most exciting parts of what is new in Excel 2013. The Quick Analysis allows you to pull up a brick of cells or data and then play around with it. You are able to use Quick Analysis in an effort to format your numbers by dates or numerical orders; it is possible to produce new charts; you can total up the running tally; or you can make tables for other users. Immediately 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 incorporated within the software. Power View is fantastic for turning a bunch of numbers into a presentable format in case you need to make a presentation or want the equivalent of a PowerPoint slide for the data. Create a working title, organize the information as you need, filter out any unnecessary parts, and use any texts or themes which you feel work best for the presentation. Preview it before it is all set to go and put it in an e mail or on a projector.
As you can see Excel 2013 brings some good new functions to the table. Now it is up to you to determine if the new capabilities justify an upgrade.
Start At the Beginning
The new Office 2013 software makes use of a start screen that is certainly 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 lets you keep the worksheets pinned to a selection of recent activity so that it is always visible and comes up without any loading. It is possible to automatically import current workbooks or templates from your hard drive, a disk, or the cloud. New templates may be pinned alongside the existing files to far better let you boot up your work.
Look Towards the Rear
One of many well-known features of Office 2010 was the Backstage View, a way of calling up different files so as to import details with out swapping out tabs or pulling up a different software program. This View has been re-vamped for Office 2013, with a tab that allows you to pull up recently accessed documents. This list can include e mail chains, laptop or computer drives, recently browsed locations, and some online databases. What's more, you are able to use the View to open a SkyDrive account that shares files among registered users.
Seeing The Patterns
Pattern recognition software has come a long ways since the days of Office detecting what words that you're about to type founded only on the first few letters. Microsoft's new algorithm can see patterns in numerical information. The Flash Fill tool of Excel 2013 allows you to find patterns within the numbers you input and then automatically fill remaining entries with all the info. For those who need to apply a common figure to existing numbers, such as an increase for inflation, the Flash Fill can very easily and instantly plug in numbers that would previously need employing the calculator function. This applies to numbers as well as names and time, in order that you could Flash Fill the projected figures months and years from now.
Ask For a Recommendation
Among the list of intuitive new capabilities of Excel 2013 is definitely the Recommended Charts app. This pulls up a subset of the figures you have input in a chart form, whether bar graph or pie chart or numbers over time. By inserting recommended charts, you may click around to view how your numbers would appear in numerous visual shapes. All you must do once you find the graph and or chart that looks appropriate is hit OK and it will be created and added in your document.
Analyze In Rapid Time
Being able to work with the data as soon as it has been inserted into every cell is among the most exciting parts of what is new in Excel 2013. The Quick Analysis allows you to pull up a brick of cells or data and then play around with it. You are able to use Quick Analysis in an effort to format your numbers by dates or numerical orders; it is possible to produce new charts; you can total up the running tally; or you can make tables for other users. Immediately 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 incorporated within the software. Power View is fantastic for turning a bunch of numbers into a presentable format in case you need to make a presentation or want the equivalent of a PowerPoint slide for the data. Create a working title, organize the information as you need, filter out any unnecessary parts, and use any texts or themes which you feel work best for the presentation. Preview it before it is all set to go and put it in an e mail or on a projector.
As you can see Excel 2013 brings some good new functions to the table. Now it is up to you to determine if the new capabilities justify 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.
No comments:
Post a Comment