Because of the latest release of the 2013 version of Microsoft Office, most people are wondering what is new in Excel 2013 and what modifications have taken place in the most popular software program on the planet. The latest spreadsheet tool has not undergone any drastic modifications, but there are actually a few tweaks that make it easier to make use of for both novice and veteran number-crunchers. New apps and Excel 2013 new features enable users to browse through more quickly and compile data with much less input.
Start At the Beginning
The new Office 2013 software 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 hold the worksheets pinned to a selection of recent activity so that it is always visible and comes up with out any loading. You'll be able to automatically import existing workbooks or templates out of your hard drive, a disk, and the cloud. New templates can be pinned alongside the current files to much better permit you to boot up your work.
Look Towards the Rear
One of several well-liked capabilities of Office 2010 was the Backstage View, a method of calling up several files to be able to import information with out swapping out tabs or pulling up a whole 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 consist of e mail chains, pc drives, recently browsed locations, and a few online databases. What's more, you can make use of 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 Microsoft office detecting what words that you're about to type based only around the first few letters. Microsoft's new algorithm can see patterns in numerical data. The Flash Fill tool of Excel 2013 enables you to find patterns inside the numbers you input and then automatically fill remaining entries with all the information. For those who must apply a common figure to existing numbers, like an increase for inflation, the Flash Fill can very easily and instantly plug in numbers that would previously require employing the calculator function. This applies to numbers as well as names and time, to ensure that you'll be able to 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've input in a chart form, whether bar graph or pie chart or numbers over time. By inserting recommended charts, it is possible to click around to find out how your numbers would appear in several visual forms. All you must do when you see the graph and or chart that appears right is hit OK and it will be produced and added in your document.
Analyze In Rapid Time
Having the ability to work with all your information as soon as it has been inserted into every cell is one of the most thrilling parts of what's 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'll be able to use Quick Analysis in an effort 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'll be able to build tables for other users. 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 included inside the software. Power View is great 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 data as you need, filter out any unnecessary parts, and use any texts or themes that you feel work best for a presentation. Preview it before it's all set to go and put it in an e-mail or on a projector.
As you can see Excel 2013 brings some fine new functions to the table. Now it is up to you to decide if the latest capabilities justify an upgrade.
Start At the Beginning
The new Office 2013 software 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 hold the worksheets pinned to a selection of recent activity so that it is always visible and comes up with out any loading. You'll be able to automatically import existing workbooks or templates out of your hard drive, a disk, and the cloud. New templates can be pinned alongside the current files to much better permit you to boot up your work.
Look Towards the Rear
One of several well-liked capabilities of Office 2010 was the Backstage View, a method of calling up several files to be able to import information with out swapping out tabs or pulling up a whole 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 consist of e mail chains, pc drives, recently browsed locations, and a few online databases. What's more, you can make use of 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 Microsoft office detecting what words that you're about to type based only around the first few letters. Microsoft's new algorithm can see patterns in numerical data. The Flash Fill tool of Excel 2013 enables you to find patterns inside the numbers you input and then automatically fill remaining entries with all the information. For those who must apply a common figure to existing numbers, like an increase for inflation, the Flash Fill can very easily and instantly plug in numbers that would previously require employing the calculator function. This applies to numbers as well as names and time, to ensure that you'll be able to 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've input in a chart form, whether bar graph or pie chart or numbers over time. By inserting recommended charts, it is possible to click around to find out how your numbers would appear in several visual forms. All you must do when you see the graph and or chart that appears right is hit OK and it will be produced and added in your document.
Analyze In Rapid Time
Having the ability to work with all your information as soon as it has been inserted into every cell is one of the most thrilling parts of what's 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'll be able to use Quick Analysis in an effort 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'll be able to build tables for other users. 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 included inside the software. Power View is great 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 data as you need, filter out any unnecessary parts, and use any texts or themes that you feel work best for a presentation. Preview it before it's all set to go and put it in an e-mail or on a projector.
As you can see Excel 2013 brings some fine new functions to the table. Now it is up to you to decide if the latest 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