Due to the brand-new release of the 2013 version of Microsoft Office, most people are curious about what is new in Excel 2013 and what improvements have taken place in the most popular software program on the planet. The newest spreadsheet program hasn't undergone any drastic modifications, but you'll notice a number of tweaks that make it easier to work with for both novice and veteran number-crunchers. New apps and Excel 2013 new options permit users to browse through quicker and compile data with less input.
Start off At the Beginning
The new Office 2013 software package utilizes a start screen that's totally different from the prior packages. In contrast 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 enables you to hold the worksheets pinned to a list of recent activity so that it is always visible and comes up free of any loading. You can automatically import old workbooks or templates out of your hard drive, a disk, as well as the cloud. New templates may be pinned alongside the current files to far better permit you to boot up your work.
Look Towards the Rear
One of many well-liked functions of Office 2010 was the Backstage View, a means of calling up several files as a way to import info without swapping out tabs or pulling up a brand new software program. This View has been re-vamped for Microsoft Office 2013, with a tab that allows you to pull up recently accessed documents. This list can consist of email chains, pc drives, lately browsed sites, and a few online databases. What's more, it is possible to use the View to open a SkyDrive account that shares files amongst 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 founded only around the initial couple of 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 using the data. For those who need to apply a common figure to existing numbers, like a rise for inflation, the Flash Fill can simply and quickly plug in numbers that would previously need utilizing the calculator function. This applies to numbers at the same time as names and time, in order that you'll be able to Flash Fill the projected figures months and years from now.
Ask For a Recommendation
Among the list of intuitive new functions of Excel 2013 is the Recommended Charts app. This pulls up a subset of the figures you have input inside 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 how your numbers would appear in numerous visual styles. All you need to do when you see the graph that appears correct is hit OK and it will be created and added to your document.
Analyze In Rapid Time
Being able to work with all your info as quickly as it has been inserted into each cell is among the most exciting parts of what is new in Excel 2013. The Quick Analysis lets you pull up a brick of cells or information and then play around with it. You may use Quick Analysis so as to format your numbers by dates or numerical orders; you may produce new charts; you may total up the running tally; or you may build tables for other users. Right 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 prior versions of Excel had a compatible Power View app. In Office 2013, this app is now included in the software. 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 data as you need, remove any unnecessary parts, and use any texts or themes which you feel work best for a presentation. Preview it before it's prepared to go and put it in an e mail or on a projector.
As you may see Excel 2013 brings some decent new features to the table. So now it is up to you to consider if the latest capabilities warrant an upgrade.
Start off At the Beginning
The new Office 2013 software package utilizes a start screen that's totally different from the prior packages. In contrast 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 enables you to hold the worksheets pinned to a list of recent activity so that it is always visible and comes up free of any loading. You can automatically import old workbooks or templates out of your hard drive, a disk, as well as the cloud. New templates may be pinned alongside the current files to far better permit you to boot up your work.
Look Towards the Rear
One of many well-liked functions of Office 2010 was the Backstage View, a means of calling up several files as a way to import info without swapping out tabs or pulling up a brand new software program. This View has been re-vamped for Microsoft Office 2013, with a tab that allows you to pull up recently accessed documents. This list can consist of email chains, pc drives, lately browsed sites, and a few online databases. What's more, it is possible to use the View to open a SkyDrive account that shares files amongst 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 founded only around the initial couple of 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 using the data. For those who need to apply a common figure to existing numbers, like a rise for inflation, the Flash Fill can simply and quickly plug in numbers that would previously need utilizing the calculator function. This applies to numbers at the same time as names and time, in order that you'll be able to Flash Fill the projected figures months and years from now.
Ask For a Recommendation
Among the list of intuitive new functions of Excel 2013 is the Recommended Charts app. This pulls up a subset of the figures you have input inside 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 how your numbers would appear in numerous visual styles. All you need to do when you see the graph that appears correct is hit OK and it will be created and added to your document.
Analyze In Rapid Time
Being able to work with all your info as quickly as it has been inserted into each cell is among the most exciting parts of what is new in Excel 2013. The Quick Analysis lets you pull up a brick of cells or information and then play around with it. You may use Quick Analysis so as to format your numbers by dates or numerical orders; you may produce new charts; you may total up the running tally; or you may build tables for other users. Right 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 prior versions of Excel had a compatible Power View app. In Office 2013, this app is now included in the software. 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 data as you need, remove any unnecessary parts, and use any texts or themes which you feel work best for a presentation. Preview it before it's prepared to go and put it in an e mail or on a projector.
As you may see Excel 2013 brings some decent new features to the table. So now it is up to you to consider if the latest capabilities 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