Because of the latest 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 popular software program on the planet. The new spreadsheet program has not undergone any drastic changes, but you'll notice a couple of tweaks that make it easier to use for equally novice and veteran number-crunchers. New apps and Excel 2013 new options enable users to browse through more quickly and compile data with a lesser amount of input.
Start At the Beginning
The new Office 2013 software package uses a start screen that's totally 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 permits you to hold the worksheets pinned to a selection of recent activity in order that it is visible and comes up with no need of any loading. You'll be able to automatically import existing 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 enable you to boot up your work.
Look To the Rear
One of the well-known features of Office 2010 was the Backstage View, a means of calling up various files in order to import data with out swapping out tabs or pulling up a new program. This View has been re-vamped for Microsoft Office 2013, with a tab that lets you pull up recently accessed documents. This list can incorporate email chains, laptop or computer drives, recently browsed sites, and a few online databases. What is more, you'll be able to make use of 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 Office detecting what words you are about to type founded only on the initial handful of letters. Microsoft's new algorithm can see patterns in numerical data. The Flash Fill tool of Excel 2013 enables you to find patterns within the numbers you input and then automatically fill remaining entries with the information. For those who have to apply a common figure to existing numbers, like an increase for inflation, the Flash Fill can without difficulty and instantaneously plug in numbers that would previously require employing the calculator function. This applies to numbers as well as names and time, so that you can Flash Fill the projected figures months and years from now.
Ask For a Recommendation
One of many intuitive new capabilities 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, you may click around to determine the way your numbers would appear in a number of visual forms. All you will need to do when you see the graph and or chart that appears correct is hit OK and it will be created and added in your document.
Analyze In Rapid Time
Being able to work with the info as quickly as it has been typed into each cell is one of the most exciting 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 in an effort to format your numbers by dates or numerical orders; you may create new charts; you'll be able to total up the running tally; or you can make tables for other users. Following previewing every tally or chart, simply 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 within 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 data. Create a working title, organize the data as you need, filter any unnecessary parts, and use any texts or themes which you feel work best for a presentation. Preview it before it's prepared to go and put it in an e-mail or on a projector.
As you may see Excel 2013 brings some fine new capabilities to the table. Now it is up to you to decide if the new capabilities warrant an upgrade.
Start At the Beginning
The new Office 2013 software package uses a start screen that's totally 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 permits you to hold the worksheets pinned to a selection of recent activity in order that it is visible and comes up with no need of any loading. You'll be able to automatically import existing 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 enable you to boot up your work.
Look To the Rear
One of the well-known features of Office 2010 was the Backstage View, a means of calling up various files in order to import data with out swapping out tabs or pulling up a new program. This View has been re-vamped for Microsoft Office 2013, with a tab that lets you pull up recently accessed documents. This list can incorporate email chains, laptop or computer drives, recently browsed sites, and a few online databases. What is more, you'll be able to make use of 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 Office detecting what words you are about to type founded only on the initial handful of letters. Microsoft's new algorithm can see patterns in numerical data. The Flash Fill tool of Excel 2013 enables you to find patterns within the numbers you input and then automatically fill remaining entries with the information. For those who have to apply a common figure to existing numbers, like an increase for inflation, the Flash Fill can without difficulty and instantaneously plug in numbers that would previously require employing the calculator function. This applies to numbers as well as names and time, so that you can Flash Fill the projected figures months and years from now.
Ask For a Recommendation
One of many intuitive new capabilities 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, you may click around to determine the way your numbers would appear in a number of visual forms. All you will need to do when you see the graph and or chart that appears correct is hit OK and it will be created and added in your document.
Analyze In Rapid Time
Being able to work with the info as quickly as it has been typed into each cell is one of the most exciting 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 in an effort to format your numbers by dates or numerical orders; you may create new charts; you'll be able to total up the running tally; or you can make tables for other users. Following previewing every tally or chart, simply 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 within 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 data. Create a working title, organize the data as you need, filter any unnecessary parts, and use any texts or themes which you feel work best for a presentation. Preview it before it's prepared to go and put it in an e-mail or on a projector.
As you may see Excel 2013 brings some fine new capabilities to the table. Now it is up to you to decide 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