Together with the recent release of the 2013 version of Microsoft Office, a lot of people are wondering what's new in Excel 2013 and what modifications have taken place in the most well-liked software program on the planet. The latest spreadsheet tool hasn't undergone any drastic changes, but there are several tweaks that make it much easier to utilize for equally novice and veteran number-crunchers. New apps and Excel 2013 new features permit users to browse through more rapidly and compile information with much less input.
Start out At the Beginning
The new Office 2013 software package uses a start screen that is certainly 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 permits you to keep the worksheets pinned to a selection of current activity to ensure that it is always visible and comes up free of any loading. You can automatically import existing workbooks or templates out of your hard drive, a disk, or the cloud. New templates may be pinned alongside the existing files to better allow you to boot up your work.
Look To the Rear
Among the list of popular features of Office 2010 was the Backstage View, a method of calling up different files in order to import data with out swapping out tabs or pulling up a different software program. This View has been re-vamped for Microsoft Office 2013, with a tab that enables you to pull up recently accessed documents. This list can contain email 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 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 are about to type founded only around the initial handful of letters. Microsoft's new algorithm can see patterns in numerical data. The Flash Fill tool of Excel 2013 lets you find patterns within the numbers you input and then automatically fill remaining entries with the info. For those who need to apply a common figure to existing numbers, for example an increase for inflation, the Flash Fill can easily and immediately plug in numbers that would previously require employing the calculator function. This applies to numbers at the same time as names and time, to ensure that you could Flash Fill the projected figures months and years from now.
Ask To get a Recommendation
Among the list of intuitive new features of Excel 2013 is 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 find out the way your numbers would appear in a variety of visual forms. All you need to do when you find the graph and or chart that appears correct is hit OK and it will be produced and added in your document.
Analyze In Rapid Time
Having the ability to work with your information as soon as it has been entered into each cell is among the most thrilling 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 may use Quick Analysis so as to format your numbers by dates or numerical orders; it is possible to create new charts; you can total up the running tally; or it is possible to set up tables for other users. Right after previewing each tally or chart, merely 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 included in the software. Power View is good 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 data. Create a working title, organize the data as you need, filter out any unnecessary parts, and use any texts or themes that you really feel work best for a presentation. Preview it before it is ready to go and put it in an e mail or on a projector.
As you may see Excel 2013 brings some nice new features to the table. So now it is up to you to decide if the latest features warrant an upgrade.
Start out At the Beginning
The new Office 2013 software package uses a start screen that is certainly 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 permits you to keep the worksheets pinned to a selection of current activity to ensure that it is always visible and comes up free of any loading. You can automatically import existing workbooks or templates out of your hard drive, a disk, or the cloud. New templates may be pinned alongside the existing files to better allow you to boot up your work.
Look To the Rear
Among the list of popular features of Office 2010 was the Backstage View, a method of calling up different files in order to import data with out swapping out tabs or pulling up a different software program. This View has been re-vamped for Microsoft Office 2013, with a tab that enables you to pull up recently accessed documents. This list can contain email 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 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 are about to type founded only around the initial handful of letters. Microsoft's new algorithm can see patterns in numerical data. The Flash Fill tool of Excel 2013 lets you find patterns within the numbers you input and then automatically fill remaining entries with the info. For those who need to apply a common figure to existing numbers, for example an increase for inflation, the Flash Fill can easily and immediately plug in numbers that would previously require employing the calculator function. This applies to numbers at the same time as names and time, to ensure that you could Flash Fill the projected figures months and years from now.
Ask To get a Recommendation
Among the list of intuitive new features of Excel 2013 is 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 find out the way your numbers would appear in a variety of visual forms. All you need to do when you find the graph and or chart that appears correct is hit OK and it will be produced and added in your document.
Analyze In Rapid Time
Having the ability to work with your information as soon as it has been entered into each cell is among the most thrilling 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 may use Quick Analysis so as to format your numbers by dates or numerical orders; it is possible to create new charts; you can total up the running tally; or it is possible to set up tables for other users. Right after previewing each tally or chart, merely 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 included in the software. Power View is good 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 data. Create a working title, organize the data as you need, filter out any unnecessary parts, and use any texts or themes that you really feel work best for a presentation. Preview it before it is ready to go and put it in an e mail or on a projector.
As you may see Excel 2013 brings some nice new features to the table. So now it is up to you to decide 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.