Because of the recent release of the 2013 version of Microsoft Office, a lot of people are wondering what exactly is new in Excel 2013 and what modifications have taken place in the most well known software program on the planet. The new spreadsheet tool hasn't undergone any drastic modifications, but there are actually a couple of tweaks that make it less complicated to work with for both novice and veteran number-crunchers. New apps and Excel 2013 new options permit users to browse through faster and compile data with less input.
Start out At the Beginning
The new Office 2013 software package utilizes a start screen which is totally different from the prior packages. As opposed to the older versions of Excel where users chose between workbooks, calendars, and to-do lists, the start screen for Excel 2013 loads up the most recent files automatically. This lets you retain the worksheets pinned to a selection of recent activity so that it is always visible and comes up without the need for any loading. You'll be able to automatically import current workbooks or templates out of your hard drive, a disk, as well as the cloud. New templates can be pinned alongside the current files to much better let you boot up your work.
Look Towards the Rear
One of many popular functions of Office 2010 was the Backstage View, a means of calling up different files so as to import information with out swapping out tabs or pulling up a different software program. This View has been re-vamped for Microsoft Office 2013, with a tab that enables you to pull up recently accessed documents. This list can contain e-mail chains, pc drives, recently browsed locations, and some online databases. What's more, you'll be able to 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 might be about to type based only around the initial handful of letters. Microsoft's new algorithm can see patterns in numerical data. The Flash Fill tool of Excel 2013 permits you to discover patterns inside the numbers you input and then automatically fill remaining entries using the data. For all those who must apply a common figure to existing numbers, for instance an increase for inflation, the Flash Fill can simply and instantaneously plug in numbers that would previously call for using the calculator function. This applies to numbers as well as names and time, so that you could Flash Fill the projected figures months and years from now.
Ask To get a Recommendation
One of several intuitive new features 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 the way your numbers would appear in various visual forms. All you will need to do once you find the graph that appears right is hit OK and it will be created and added to your document.
Analyze In Rapid Time
Being able to work with your information as quickly as it has been inserted into every cell is among the most exciting parts of what's new in Excel 2013. The Quick Analysis allows you to pull up a brick of cells or info and then play around with it. It is possible to use Quick Analysis in order to format your numbers by dates or numerical orders; you can set up new charts; you may total up the running tally; or you can build tables for other users. Right after previewing each tally or chart, merely click OK and it will be applied to the numbers.
View Each Number In Each Dimension
The prior versions of Excel had a compatible Power View app. In Office 2013, this app is now included within the application. Power View is great 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 feel work best for your presentation. Preview it before it is ready to go and put it in an e-mail or on a projector.
As you can see Excel 2013 brings some nice new features to the table. So now it is up to you to consider if the new capabilities justify an upgrade.
Start out At the Beginning
The new Office 2013 software package utilizes a start screen which is totally different from the prior packages. As opposed to the older versions of Excel where users chose between workbooks, calendars, and to-do lists, the start screen for Excel 2013 loads up the most recent files automatically. This lets you retain the worksheets pinned to a selection of recent activity so that it is always visible and comes up without the need for any loading. You'll be able to automatically import current workbooks or templates out of your hard drive, a disk, as well as the cloud. New templates can be pinned alongside the current files to much better let you boot up your work.
Look Towards the Rear
One of many popular functions of Office 2010 was the Backstage View, a means of calling up different files so as to import information with out swapping out tabs or pulling up a different software program. This View has been re-vamped for Microsoft Office 2013, with a tab that enables you to pull up recently accessed documents. This list can contain e-mail chains, pc drives, recently browsed locations, and some online databases. What's more, you'll be able to 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 might be about to type based only around the initial handful of letters. Microsoft's new algorithm can see patterns in numerical data. The Flash Fill tool of Excel 2013 permits you to discover patterns inside the numbers you input and then automatically fill remaining entries using the data. For all those who must apply a common figure to existing numbers, for instance an increase for inflation, the Flash Fill can simply and instantaneously plug in numbers that would previously call for using the calculator function. This applies to numbers as well as names and time, so that you could Flash Fill the projected figures months and years from now.
Ask To get a Recommendation
One of several intuitive new features 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 the way your numbers would appear in various visual forms. All you will need to do once you find the graph that appears right is hit OK and it will be created and added to your document.
Analyze In Rapid Time
Being able to work with your information as quickly as it has been inserted into every cell is among the most exciting parts of what's new in Excel 2013. The Quick Analysis allows you to pull up a brick of cells or info and then play around with it. It is possible to use Quick Analysis in order to format your numbers by dates or numerical orders; you can set up new charts; you may total up the running tally; or you can build tables for other users. Right after previewing each tally or chart, merely click OK and it will be applied to the numbers.
View Each Number In Each Dimension
The prior versions of Excel had a compatible Power View app. In Office 2013, this app is now included within the application. Power View is great 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 feel work best for your presentation. Preview it before it is ready to go and put it in an e-mail or on a projector.
As you can see Excel 2013 brings some nice new features to the table. So now it is up to you to consider 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