Due to the new release of the 2013 version of Microsoft Office, plenty of people are wondering what's new in Excel 2013 and what improvements have taken place in the most common software program on the planet. The newest spreadsheet tool hasn't undergone any drastic modifications, but you'll notice some tweaks that make it less difficult to use for equally novice and veteran number-crunchers. New apps and Excel 2013 new options permit users to browse through quicker and compile information with a lesser amount of input.
Start off At the Beginning
The new Office 2013 software utilizes a start screen that's different from the prior packages. Unlike 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 permits you to retain the worksheets pinned to a list of recent activity to ensure that it's visible and comes up with no need of any loading. You are able to automatically import current workbooks or templates from your hard drive, a disk, as well as the cloud. New templates can be pinned alongside the current files to far better allow you to boot up your work.
Look To the Rear
Among the list of well known features of Office 2010 was the Backstage View, a method of calling up different files so as to import info with out swapping out tabs or pulling up a new software program. This View has been re-vamped for Office 2013, with a tab that enables you to pull up recently accessed documents. This list can include things like e mail chains, laptop or computer drives, lately browsed sites, and some online databases. What is more, you'll be able to make use of the View to open a SkyDrive account that shares files in 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 few letters. Microsoft's new algorithm can see patterns in numerical information. The Flash Fill tool of Excel 2013 permits you to identify patterns inside the numbers you input and then automatically fill remaining entries using the data. For those who want to apply a common figure to existing numbers, for example a rise for inflation, the Flash Fill can simply and quickly plug in numbers that would previously need employing the calculator function. This applies to numbers as well as names and time, to ensure that you could Flash Fill the projected figures months and years from now.
Ask To get a Recommendation
One of the intuitive new capabilities of Excel 2013 is the Recommended Charts app. This pulls up a subset of the figures you've 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 different visual forms. All you need to do when you find the graph that looks right is hit OK and it will be created and added in your document.
Analyze In Rapid Time
Being able to work with all your data as quickly as it has been inserted into every cell is amongst the most exciting parts of what is new in Excel 2013. The Quick Analysis allows you to pull up a brick of cells or info and then play around with it. You can use Quick Analysis in an effort to format your numbers by dates or numerical orders; it is possible to set up new charts; it is possible to total up the running tally; or you are able to produce tables for other users. Right after previewing each tally or chart, just click OK and is going to 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 integrated in the application. Power View is wonderful for turning a bunch of numbers into a presentable format in case you have 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 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 nice new features to the table. So now it is up to you to determine if the latest features warrant an upgrade.
Start off At the Beginning
The new Office 2013 software utilizes a start screen that's different from the prior packages. Unlike 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 permits you to retain the worksheets pinned to a list of recent activity to ensure that it's visible and comes up with no need of any loading. You are able to automatically import current workbooks or templates from your hard drive, a disk, as well as the cloud. New templates can be pinned alongside the current files to far better allow you to boot up your work.
Look To the Rear
Among the list of well known features of Office 2010 was the Backstage View, a method of calling up different files so as to import info with out swapping out tabs or pulling up a new software program. This View has been re-vamped for Office 2013, with a tab that enables you to pull up recently accessed documents. This list can include things like e mail chains, laptop or computer drives, lately browsed sites, and some online databases. What is more, you'll be able to make use of the View to open a SkyDrive account that shares files in 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 few letters. Microsoft's new algorithm can see patterns in numerical information. The Flash Fill tool of Excel 2013 permits you to identify patterns inside the numbers you input and then automatically fill remaining entries using the data. For those who want to apply a common figure to existing numbers, for example a rise for inflation, the Flash Fill can simply and quickly plug in numbers that would previously need employing the calculator function. This applies to numbers as well as names and time, to ensure that you could Flash Fill the projected figures months and years from now.
Ask To get a Recommendation
One of the intuitive new capabilities of Excel 2013 is the Recommended Charts app. This pulls up a subset of the figures you've 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 different visual forms. All you need to do when you find the graph that looks right is hit OK and it will be created and added in your document.
Analyze In Rapid Time
Being able to work with all your data as quickly as it has been inserted into every cell is amongst the most exciting parts of what is new in Excel 2013. The Quick Analysis allows you to pull up a brick of cells or info and then play around with it. You can use Quick Analysis in an effort to format your numbers by dates or numerical orders; it is possible to set up new charts; it is possible to total up the running tally; or you are able to produce tables for other users. Right after previewing each tally or chart, just click OK and is going to 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 integrated in the application. Power View is wonderful for turning a bunch of numbers into a presentable format in case you have 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 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 nice new features to the table. So now it is up to you to determine if the latest features 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.
No comments:
Post a Comment