Due to the recent release of the 2013 version of Microsoft Office, many of us are itching to know what is new in Excel 2013 and what changes have taken place in the most well-known software program on the planet. The newest spreadsheet program has not undergone any drastic changes, but there are a couple of tweaks that make it less complicated to make use of for both novice and veteran number-crunchers. New apps and Excel 2013 new capabilities allow users to browse through quicker and compile data with much less input.
Start out At the Beginning
The new Office 2013 software package uses a start screen that's completely 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 allows you to hold the worksheets pinned to a list of recent activity to ensure that it is visible and comes up free of any loading. You are able to automatically import current workbooks or templates out of your hard drive, a disk, or the cloud. New templates may be pinned alongside the current files to better allow you to boot up your work.
Look Towards the Rear
One of many popular features of Office 2010 was the Backstage View, a method of calling up various files as a way to import data without swapping out tabs or pulling up a whole 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 include things like email chains, pc drives, recently browsed locations, and a few online databases. What's more, it is possible to make use of 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 might be about to type founded only on the first couple of letters. Microsoft's new algorithm can see patterns in numerical information. The Flash Fill tool of Excel 2013 allows you to identify patterns within the numbers you input and then automatically fill remaining entries using the information. For all those who want to apply a common figure to existing numbers, for instance an increase for inflation, the Flash Fill can effortlessly and instantaneously plug in numbers that would previously call for using the calculator function. This applies to numbers at the same time as names and time, in order that you can Flash Fill the projected figures months and years from now.
Ask For a Recommendation
Among the list of intuitive new functions of Excel 2013 certainly 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 see the way your numbers would appear in a variety of visual shapes. All you have to do when you see 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
Being able to work with your data as soon as it has been typed into each cell is amongst the most interesting 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 are able to use Quick Analysis as a way to format your numbers by dates or numerical orders; you can set up new charts; you can total up the running tally; or you are able to produce tables for other users. Immediately after previewing 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 incorporated in the software. Power View is excellent 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 info as you need, filter any unnecessary parts, and use any texts or themes that you really 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 nice new features to the table. So now it is up to you to determine if the latest capabilities warrant an upgrade.
Start out At the Beginning
The new Office 2013 software package uses a start screen that's completely 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 allows you to hold the worksheets pinned to a list of recent activity to ensure that it is visible and comes up free of any loading. You are able to automatically import current workbooks or templates out of your hard drive, a disk, or the cloud. New templates may be pinned alongside the current files to better allow you to boot up your work.
Look Towards the Rear
One of many popular features of Office 2010 was the Backstage View, a method of calling up various files as a way to import data without swapping out tabs or pulling up a whole 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 include things like email chains, pc drives, recently browsed locations, and a few online databases. What's more, it is possible to make use of 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 might be about to type founded only on the first couple of letters. Microsoft's new algorithm can see patterns in numerical information. The Flash Fill tool of Excel 2013 allows you to identify patterns within the numbers you input and then automatically fill remaining entries using the information. For all those who want to apply a common figure to existing numbers, for instance an increase for inflation, the Flash Fill can effortlessly and instantaneously plug in numbers that would previously call for using the calculator function. This applies to numbers at the same time as names and time, in order that you can Flash Fill the projected figures months and years from now.
Ask For a Recommendation
Among the list of intuitive new functions of Excel 2013 certainly 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 see the way your numbers would appear in a variety of visual shapes. All you have to do when you see 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
Being able to work with your data as soon as it has been typed into each cell is amongst the most interesting 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 are able to use Quick Analysis as a way to format your numbers by dates or numerical orders; you can set up new charts; you can total up the running tally; or you are able to produce tables for other users. Immediately after previewing 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 incorporated in the software. Power View is excellent 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 info as you need, filter any unnecessary parts, and use any texts or themes that you really 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 nice new features to the table. So now it is up to you to determine 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.
