Due to the new release of the 2013 version of Microsoft Office, a lot of people are itching to know what is new in Excel 2013 and what modifications have taken place in the most common software program on the planet. The latest spreadsheet program has not undergone any drastic changes, but you will find some tweaks that make it much easier to utilize for equally novice and veteran number-crunchers. New apps and Excel 2013 new capabilities enable users to browse through more rapidly and compile information with a lesser amount of input.
Start At the Beginning
The new Office 2013 computer software utilizes 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 permits you to hold the worksheets pinned to a list of recent activity in order that it is always visible and comes up free of any loading. You can automatically import current workbooks or templates from your hard drive, a disk, or the cloud. New templates can be pinned alongside the existing files to much better enable you to boot up your work.
Look To the Rear
Among the well-known features of Office 2010 was the Backstage View, a way of calling up various files as a way to import details 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 permits you to pull up recently accessed documents. This list can include things like e mail chains, laptop or computer drives, lately browsed locations, and a few online databases. What is more, you can 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 Office detecting what words you're about to type based only on the first 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 all the information. For those who have to apply a common figure to existing numbers, for instance a rise for inflation, the Flash Fill can without difficulty and quickly plug in numbers that would previously call for employing the calculator function. This applies to numbers as well as names and time, in order that you could Flash Fill the projected figures months and years from now.
Ask For a Recommendation
Among the intuitive new features of Excel 2013 is 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 find out the way your numbers would appear in different visual shapes. All you have to do once you find the graph that appears right is hit OK and it will be produced and added in your document.
Analyze In Rapid Time
Having the ability to work with the data as soon as it has been inserted into every cell is among the most thrilling 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 are able to use Quick Analysis in order to format your numbers by dates or numerical orders; you'll be able to make new charts; you can total up the running tally; or it is possible to set up tables for other users. Immediately after previewing each tally or chart, merely 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 included inside the application. 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 info as you need, filter out any unnecessary parts, and use any texts or themes which you feel work best for the presentation. Preview it before it is ready to go and put it in an email or on a projector.
As you can see Excel 2013 brings some fine new options to the table. So now it is up to you to decide if the latest features justify an upgrade.
Start At the Beginning
The new Office 2013 computer software utilizes 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 permits you to hold the worksheets pinned to a list of recent activity in order that it is always visible and comes up free of any loading. You can automatically import current workbooks or templates from your hard drive, a disk, or the cloud. New templates can be pinned alongside the existing files to much better enable you to boot up your work.
Look To the Rear
Among the well-known features of Office 2010 was the Backstage View, a way of calling up various files as a way to import details 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 permits you to pull up recently accessed documents. This list can include things like e mail chains, laptop or computer drives, lately browsed locations, and a few online databases. What is more, you can 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 Office detecting what words you're about to type based only on the first 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 all the information. For those who have to apply a common figure to existing numbers, for instance a rise for inflation, the Flash Fill can without difficulty and quickly plug in numbers that would previously call for employing the calculator function. This applies to numbers as well as names and time, in order that you could Flash Fill the projected figures months and years from now.
Ask For a Recommendation
Among the intuitive new features of Excel 2013 is 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 find out the way your numbers would appear in different visual shapes. All you have to do once you find the graph that appears right is hit OK and it will be produced and added in your document.
Analyze In Rapid Time
Having the ability to work with the data as soon as it has been inserted into every cell is among the most thrilling 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 are able to use Quick Analysis in order to format your numbers by dates or numerical orders; you'll be able to make new charts; you can total up the running tally; or it is possible to set up tables for other users. Immediately after previewing each tally or chart, merely 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 included inside the application. 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 info as you need, filter out any unnecessary parts, and use any texts or themes which you feel work best for the presentation. Preview it before it is ready to go and put it in an email or on a projector.
As you can see Excel 2013 brings some fine new options to the table. So now it is up to you to decide if the latest features 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 Response to "What Is New In Excel 2013"
Post a Comment