Due to the brand-new release of the 2013 version of Microsoft Office, lots of people are itching to know what's new in Excel 2013 and what improvements have taken place in the most popular software program on the planet. The new spreadsheet tool has not undergone any drastic changes, but there are actually a number of tweaks that make it less difficult to work with for equally novice and veteran number-crunchers. New apps and Excel 2013 new options allow users to browse through quicker and compile information with less input.
Begin At the Beginning
The new Office 2013 software package uses a start screen which is 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 current files automatically. This lets you hold the worksheets pinned to a selection of current activity to ensure that it's visible and comes up without any loading. You'll be able to automatically import current workbooks or templates from your hard drive, a disk, and the cloud. New templates may be pinned alongside the current files to better permit you to boot up your work.
Look To the Rear
One of the popular capabilities of Office 2010 was the Backstage View, a method of calling up various files so as to import info 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 lets you pull up recently accessed documents. This list can contain e mail chains, laptop or computer drives, recently browsed locations, and a few online databases. What's more, you'll be able to use 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 that you're about to type founded only around the initial few letters. Microsoft's new algorithm can see patterns in numerical data. The Flash Fill tool of Excel 2013 lets you discover patterns within the numbers you input and then automatically fill remaining entries with the information. For all those who must apply a common figure to existing numbers, such as a rise for inflation, the Flash Fill can simply and quickly plug in numbers that would previously call for using the calculator function. This applies to numbers at the same time 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 many intuitive new features of Excel 2013 is definitely the Recommended Charts app. This pulls up a subset of the figures you've 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 view the way your numbers would appear in several visual styles. All you must do once you find the graph and or chart that appears appropriate is hit OK and it will be generated and added to your document.
Analyze In Rapid Time
Being able to work with the data as soon as it has been inserted into each cell is one of the most exciting parts of what's new in Excel 2013. The Quick Analysis lets you pull up a brick of cells or information and then play around with it. You'll be able to use Quick Analysis so as to format your numbers by dates or numerical orders; you'll be able to make new charts; you are able to total up the running tally; or you can produce tables for other users. Immediately after previewing each and every tally or chart, simply click OK and it will be applied to 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 in the application. Power View is excellent 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 information. Create a working title, organize the info 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 options to the table. Now it is up to you to consider if the latest features warrant an upgrade.
Begin At the Beginning
The new Office 2013 software package uses a start screen which is 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 current files automatically. This lets you hold the worksheets pinned to a selection of current activity to ensure that it's visible and comes up without any loading. You'll be able to automatically import current workbooks or templates from your hard drive, a disk, and the cloud. New templates may be pinned alongside the current files to better permit you to boot up your work.
Look To the Rear
One of the popular capabilities of Office 2010 was the Backstage View, a method of calling up various files so as to import info 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 lets you pull up recently accessed documents. This list can contain e mail chains, laptop or computer drives, recently browsed locations, and a few online databases. What's more, you'll be able to use 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 that you're about to type founded only around the initial few letters. Microsoft's new algorithm can see patterns in numerical data. The Flash Fill tool of Excel 2013 lets you discover patterns within the numbers you input and then automatically fill remaining entries with the information. For all those who must apply a common figure to existing numbers, such as a rise for inflation, the Flash Fill can simply and quickly plug in numbers that would previously call for using the calculator function. This applies to numbers at the same time 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 many intuitive new features of Excel 2013 is definitely the Recommended Charts app. This pulls up a subset of the figures you've 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 view the way your numbers would appear in several visual styles. All you must do once you find the graph and or chart that appears appropriate is hit OK and it will be generated and added to your document.
Analyze In Rapid Time
Being able to work with the data as soon as it has been inserted into each cell is one of the most exciting parts of what's new in Excel 2013. The Quick Analysis lets you pull up a brick of cells or information and then play around with it. You'll be able to use Quick Analysis so as to format your numbers by dates or numerical orders; you'll be able to make new charts; you are able to total up the running tally; or you can produce tables for other users. Immediately after previewing each and every tally or chart, simply click OK and it will be applied to 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 in the application. Power View is excellent 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 information. Create a working title, organize the info 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 options to the table. Now it is up to you to consider 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