Together with the new release of the 2013 version of Microsoft Office, lots of people are curious about what exactly is new in Excel 2013 and what modifications have taken place in the most well-known software program on the planet. The newest spreadsheet program hasn't undergone any drastic modifications, but you'll notice a couple of tweaks that make it less complicated to work with for equally 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 At the Beginning
The new Office 2013 software package makes use of a start screen that is definitely differing 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 current files automatically. This permits you to hold the worksheets pinned to a list of recent activity in order that it's visible and comes up without any loading. You are able to automatically import old workbooks or templates out of your hard drive, a disk, or the cloud. New templates can be pinned alongside the existing files to far better let you boot up your work.
Look To the Rear
One of several well-known capabilities of Office 2010 was the Backstage View, a method of calling up different files in order to import details without swapping out tabs or pulling up a different software program. This View has been re-vamped for Office 2013, with a tab that permits you to pull up recently accessed documents. This list can include things like e-mail chains, pc drives, lately browsed sites, and some online databases. What's more, you'll be able to make use of the View to open a SkyDrive account that shares files in 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're about to type founded only on the first few letters. Microsoft's new algorithm can see patterns in numerical information. The Flash Fill tool of Excel 2013 allows you to find patterns inside the numbers you input and then automatically fill remaining entries with all the information. For those who want to apply a common figure to existing numbers, such as a rise for inflation, the Flash Fill can without difficulty and instantly plug in numbers that would previously require using the calculator function. This applies to numbers at the same time as names and time, so that you are 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 definitely the Recommended Charts app. This pulls up a subset of the figures you have input in a chart form, whether bar graph or pie chart or numbers over time. By inserting recommended charts, it is possible to click around to determine how your numbers would appear in several visual styles. All you have to do when you find the graph that looks appropriate is hit OK and it will be generated and added in your document.
Analyze In Rapid Time
Having the ability to work with all your info as quickly as it has been typed into every cell is one of the most appealing parts of what's new in Excel 2013. The Quick Analysis allows you to pull up a brick of cells or information and then play around with it. You can use Quick Analysis so as to format your numbers by dates or numerical orders; you are able to make new charts; you'll be able to total up the running tally; or you are able to make tables for other users. After previewing each and every tally or chart, just click OK and is going to 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 integrated inside the application. 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 info 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 prepared to go and put it in an email 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 decide if the latest capabilities justify an upgrade.
Start At the Beginning
The new Office 2013 software package makes use of a start screen that is definitely differing 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 current files automatically. This permits you to hold the worksheets pinned to a list of recent activity in order that it's visible and comes up without any loading. You are able to automatically import old workbooks or templates out of your hard drive, a disk, or the cloud. New templates can be pinned alongside the existing files to far better let you boot up your work.
Look To the Rear
One of several well-known capabilities of Office 2010 was the Backstage View, a method of calling up different files in order to import details without swapping out tabs or pulling up a different software program. This View has been re-vamped for Office 2013, with a tab that permits you to pull up recently accessed documents. This list can include things like e-mail chains, pc drives, lately browsed sites, and some online databases. What's more, you'll be able to make use of the View to open a SkyDrive account that shares files in 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're about to type founded only on the first few letters. Microsoft's new algorithm can see patterns in numerical information. The Flash Fill tool of Excel 2013 allows you to find patterns inside the numbers you input and then automatically fill remaining entries with all the information. For those who want to apply a common figure to existing numbers, such as a rise for inflation, the Flash Fill can without difficulty and instantly plug in numbers that would previously require using the calculator function. This applies to numbers at the same time as names and time, so that you are 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 definitely the Recommended Charts app. This pulls up a subset of the figures you have input in a chart form, whether bar graph or pie chart or numbers over time. By inserting recommended charts, it is possible to click around to determine how your numbers would appear in several visual styles. All you have to do when you find the graph that looks appropriate is hit OK and it will be generated and added in your document.
Analyze In Rapid Time
Having the ability to work with all your info as quickly as it has been typed into every cell is one of the most appealing parts of what's new in Excel 2013. The Quick Analysis allows you to pull up a brick of cells or information and then play around with it. You can use Quick Analysis so as to format your numbers by dates or numerical orders; you are able to make new charts; you'll be able to total up the running tally; or you are able to make tables for other users. After previewing each and every tally or chart, just click OK and is going to 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 integrated inside the application. 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 info 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 prepared to go and put it in an email 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 decide if the latest 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.
No comments:
Post a Comment