With the brand-new release of the 2013 version of Microsoft Office, lots of people are itching to know what exactly is new in Excel 2013 and what improvements have taken place in the most popular software program on the planet. The recent spreadsheet tool hasn't undergone any drastic changes, but you'll find some tweaks that make it much easier to work with for both novice and veteran number-crunchers. New apps and Excel 2013 new functions permit users to browse through quicker and compile data with less input.
Start out At the Beginning
The new Office 2013 software package makes use of a start screen which is completely different from the prior packages. Unlike 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 keep the worksheets pinned to a selection of current activity so that it is always visible and comes up with no need of any loading. You can automatically import old workbooks or templates out of your hard drive, a disk, or 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 many well-known capabilities of Office 2010 was the Backstage View, a way of calling up several files in order to import information 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 allows you to pull up recently accessed documents. This list can consist of email chains, laptop or computer drives, recently browsed locations, and a few online databases. What is more, you are able to use 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 you are about to type based only around the initial couple of letters. Microsoft's new algorithm can see patterns in numerical data. The Flash Fill tool of Excel 2013 lets you find patterns inside the numbers you input and then automatically fill remaining entries using the data. For all those who have to apply a common figure to existing numbers, for instance a rise for inflation, the Flash Fill can easily and quickly plug in numbers that would previously need utilizing the calculator function. This applies to numbers as well as names and time, in order that you'll be able to Flash Fill the projected figures months and years from now.
Ask To get a Recommendation
Among the list of intuitive new capabilities of Excel 2013 is definitely 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 determine the way your numbers would appear in different visual styles. All you need to do when you see the graph and or chart that looks correct is hit OK and it will be produced and added in your document.
Analyze In Rapid Time
Being able to work with all your information as soon as it has been inserted into each cell is amongst the most exciting 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 are able to use Quick Analysis so as to format your numbers by dates or numerical orders; it is possible to create new charts; you'll be able to total up the running tally; or it is possible to make tables for other users. Following previewing each tally or chart, merely click OK and it will be applied towards 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 incorporated inside the application. Power View is excellent 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 information as you need, filter out any unnecessary parts, and use any texts or themes which you really feel work best for a presentation. Preview it before it is all set to go and put it in an email or on a projector.
As you can see Excel 2013 brings some fine new features to the table. Now it is up to you to consider if the new capabilities warrant an upgrade.
Start out At the Beginning
The new Office 2013 software package makes use of a start screen which is completely different from the prior packages. Unlike 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 keep the worksheets pinned to a selection of current activity so that it is always visible and comes up with no need of any loading. You can automatically import old workbooks or templates out of your hard drive, a disk, or 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 many well-known capabilities of Office 2010 was the Backstage View, a way of calling up several files in order to import information 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 allows you to pull up recently accessed documents. This list can consist of email chains, laptop or computer drives, recently browsed locations, and a few online databases. What is more, you are able to use 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 you are about to type based only around the initial couple of letters. Microsoft's new algorithm can see patterns in numerical data. The Flash Fill tool of Excel 2013 lets you find patterns inside the numbers you input and then automatically fill remaining entries using the data. For all those who have to apply a common figure to existing numbers, for instance a rise for inflation, the Flash Fill can easily and quickly plug in numbers that would previously need utilizing the calculator function. This applies to numbers as well as names and time, in order that you'll be able to Flash Fill the projected figures months and years from now.
Ask To get a Recommendation
Among the list of intuitive new capabilities of Excel 2013 is definitely 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 determine the way your numbers would appear in different visual styles. All you need to do when you see the graph and or chart that looks correct is hit OK and it will be produced and added in your document.
Analyze In Rapid Time
Being able to work with all your information as soon as it has been inserted into each cell is amongst the most exciting 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 are able to use Quick Analysis so as to format your numbers by dates or numerical orders; it is possible to create new charts; you'll be able to total up the running tally; or it is possible to make tables for other users. Following previewing each tally or chart, merely click OK and it will be applied towards 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 incorporated inside the application. Power View is excellent 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 information as you need, filter out any unnecessary parts, and use any texts or themes which you really feel work best for a presentation. Preview it before it is all set to go and put it in an email or on a projector.
As you can see Excel 2013 brings some fine new features to the table. Now it is up to you to consider if the new 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