Because of the new release of the 2013 version of Microsoft Office, lots 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 newest spreadsheet tool has not undergone any drastic modifications, but you'll notice some tweaks that make it less complicated to work with for both novice and veteran number-crunchers. New apps and Excel 2013 new options permit users to browse through faster and compile information with significantly less input.
Start off At the Beginning
The new Office 2013 software utilizes a start screen that is definitely different from the prior packages. As opposed to the older versions of Excel in which users chose between workbooks, calendars, and to-do lists, the start screen for Excel 2013 loads up the most recent files automatically. This lets you retain the worksheets pinned to a selection of current activity so that it is visible and comes up without requiring any loading. You'll be able to automatically import existing workbooks or templates from your hard drive, a disk, as well as the cloud. New templates can be pinned alongside the existing files to far better allow you to boot up your work.
Look To the Rear
One of many well-liked capabilities of Office 2010 was the Backstage View, a way of calling up various files so as to import info without swapping out tabs or pulling up a different software program. This View has been re-vamped for Office 2013, with a tab that allows you to pull up recently accessed documents. This list can incorporate e mail chains, pc drives, lately browsed sites, and some online databases. What's more, it is possible to use 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 Microsoft office detecting what words you might be 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 permits you to identify patterns inside the numbers you input and then automatically fill remaining entries with the data. For all those who must apply a common figure to existing numbers, for example an increase for inflation, the Flash Fill can easily and instantaneously 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 can Flash Fill the projected figures months and years from now.
Ask For a Recommendation
One of several intuitive new capabilities of Excel 2013 is definitely 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, you can click around to view the way your numbers would appear in a variety of visual styles. All you have to do once you see the graph that appears correct is hit OK and it will be produced and added in your document.
Analyze In Rapid Time
Being able to work with your info as quickly as it has been inserted into every cell is one of the most appealing parts of what's 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 as a way to format your numbers by dates or numerical orders; you'll be able to build new charts; you may total up the running tally; or you are able to make tables for other users. Immediately after previewing each tally or chart, simply click OK and it will be applied towards 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 integrated in the application. Power View is great for turning a bunch of numbers into a presentable format in case you need 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 feel work best for your presentation. Preview it before it's all set to go and put it in an email or on a projector.
As you may see Excel 2013 brings some fine new functions to the table. So now it is up to you to determine if the latest features warrant an upgrade.
Start off At the Beginning
The new Office 2013 software utilizes a start screen that is definitely different from the prior packages. As opposed to the older versions of Excel in which users chose between workbooks, calendars, and to-do lists, the start screen for Excel 2013 loads up the most recent files automatically. This lets you retain the worksheets pinned to a selection of current activity so that it is visible and comes up without requiring any loading. You'll be able to automatically import existing workbooks or templates from your hard drive, a disk, as well as the cloud. New templates can be pinned alongside the existing files to far better allow you to boot up your work.
Look To the Rear
One of many well-liked capabilities of Office 2010 was the Backstage View, a way of calling up various files so as to import info without swapping out tabs or pulling up a different software program. This View has been re-vamped for Office 2013, with a tab that allows you to pull up recently accessed documents. This list can incorporate e mail chains, pc drives, lately browsed sites, and some online databases. What's more, it is possible to use 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 Microsoft office detecting what words you might be 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 permits you to identify patterns inside the numbers you input and then automatically fill remaining entries with the data. For all those who must apply a common figure to existing numbers, for example an increase for inflation, the Flash Fill can easily and instantaneously 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 can Flash Fill the projected figures months and years from now.
Ask For a Recommendation
One of several intuitive new capabilities of Excel 2013 is definitely 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, you can click around to view the way your numbers would appear in a variety of visual styles. All you have to do once you see the graph that appears correct is hit OK and it will be produced and added in your document.
Analyze In Rapid Time
Being able to work with your info as quickly as it has been inserted into every cell is one of the most appealing parts of what's 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 as a way to format your numbers by dates or numerical orders; you'll be able to build new charts; you may total up the running tally; or you are able to make tables for other users. Immediately after previewing each tally or chart, simply click OK and it will be applied towards 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 integrated in the application. Power View is great for turning a bunch of numbers into a presentable format in case you need 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 feel work best for your presentation. Preview it before it's all set to go and put it in an email or on a projector.
As you may see Excel 2013 brings some fine new functions to the table. So now it is up to you to determine 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.
0 comments:
Post a Comment