Due to the latest release of the 2013 version of Microsoft Office, lots of people are wondering what exactly is new in Excel 2013 and what improvements have taken place in the most common software program on the planet. The new spreadsheet tool has not undergone any drastic modifications, but you'll notice a few tweaks that make it easier to work with for equally novice and veteran number-crunchers. New apps and Excel 2013 new functions permit users to browse through more quickly and compile information with less input.
Begin At the Beginning
The new Office 2013 computer software uses a start screen which is differing 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 enables you to retain the worksheets pinned to a selection of current activity in order that it is always visible and comes up with no need of any loading. It is possible to automatically import current workbooks or templates out of your hard drive, a disk, as well as the cloud. New templates may be pinned alongside the existing files to far better enable you to boot up your work.
Look To the Rear
One of many well-liked capabilities of Office 2010 was the Backstage View, a means of calling up several files so as to import information without swapping out tabs or pulling up a new 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 contain email chains, laptop or computer drives, lately browsed sites, and some online databases. What is more, it is possible to use the View to open a SkyDrive account that shares files between registered users.
Seeing The Patterns
Pattern recognition software has come a long ways since the days of Microsoft office detecting what words that you are about to type founded only around the first few letters. Microsoft's new algorithm can see patterns in numerical data. The Flash Fill tool of Excel 2013 allows you to discover patterns inside the numbers you input and then automatically fill remaining entries using the info. For those who must apply a common figure to existing numbers, such as an increase for inflation, the Flash Fill can without difficulty and immediately plug in numbers that would previously need making use of the calculator function. This applies to numbers as well as names and time, so 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've input in a chart form, whether bar graph or pie chart or numbers over time. By inserting recommended charts, you'll be able to click around to find out the way your numbers would appear in various visual styles. All you must do when you find the graph and or chart that appears correct is hit OK and it will be generated and added to your document.
Analyze In Rapid Time
Having the ability to work with all your data as quickly as it has been entered into every cell is one of the most interesting parts of what is new in Excel 2013. The Quick Analysis lets you pull up a brick of cells or data and then play around with it. You can use Quick Analysis as a way to format your numbers by dates or numerical orders; it is possible to make new charts; it is possible to total up the running tally; or you can build tables for other users. After previewing each and every tally or chart, just 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 incorporated inside the software. Power View is good 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 information as you need, remove any unnecessary parts, and use any texts or themes which you feel work best for the presentation. Preview it before it's ready to go and put it in an e-mail or on a projector.
As you may see Excel 2013 brings some good new capabilities to the table. Now it is up to you to determine if the new capabilities justify an upgrade.
Begin At the Beginning
The new Office 2013 computer software uses a start screen which is differing 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 enables you to retain the worksheets pinned to a selection of current activity in order that it is always visible and comes up with no need of any loading. It is possible to automatically import current workbooks or templates out of your hard drive, a disk, as well as the cloud. New templates may be pinned alongside the existing files to far better enable you to boot up your work.
Look To the Rear
One of many well-liked capabilities of Office 2010 was the Backstage View, a means of calling up several files so as to import information without swapping out tabs or pulling up a new 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 contain email chains, laptop or computer drives, lately browsed sites, and some online databases. What is more, it is possible to use the View to open a SkyDrive account that shares files between registered users.
Seeing The Patterns
Pattern recognition software has come a long ways since the days of Microsoft office detecting what words that you are about to type founded only around the first few letters. Microsoft's new algorithm can see patterns in numerical data. The Flash Fill tool of Excel 2013 allows you to discover patterns inside the numbers you input and then automatically fill remaining entries using the info. For those who must apply a common figure to existing numbers, such as an increase for inflation, the Flash Fill can without difficulty and immediately plug in numbers that would previously need making use of the calculator function. This applies to numbers as well as names and time, so 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've input in a chart form, whether bar graph or pie chart or numbers over time. By inserting recommended charts, you'll be able to click around to find out the way your numbers would appear in various visual styles. All you must do when you find the graph and or chart that appears correct is hit OK and it will be generated and added to your document.
Analyze In Rapid Time
Having the ability to work with all your data as quickly as it has been entered into every cell is one of the most interesting parts of what is new in Excel 2013. The Quick Analysis lets you pull up a brick of cells or data and then play around with it. You can use Quick Analysis as a way to format your numbers by dates or numerical orders; it is possible to make new charts; it is possible to total up the running tally; or you can build tables for other users. After previewing each and every tally or chart, just 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 incorporated inside the software. Power View is good 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 information as you need, remove any unnecessary parts, and use any texts or themes which you feel work best for the presentation. Preview it before it's ready to go and put it in an e-mail or on a projector.
As you may see Excel 2013 brings some good new capabilities to the table. Now it is up to you to determine if the new 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.
0 Comments