iklan ads
With the latest 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 tool has not undergone any drastic modifications, but you will find several tweaks that make it easier to utilize for both novice and veteran number-crunchers. New apps and Excel 2013 new features enable users to browse through more quickly and compile information with significantly less input.
Start out At the Beginning
The new Office 2013 software uses a start screen that is 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 current files automatically. This lets you hold the worksheets pinned to a selection of recent activity in order that it's visible and comes up with no need of any loading. You can automatically import current workbooks or templates from your hard drive, a disk, and the cloud. New templates may be pinned alongside the current files to far better permit you to boot up your work.
Look Towards the Rear
One of many well-known features of Office 2010 was the Backstage View, a means of calling up different files as a way to import data without swapping out tabs or pulling up a different software program. This View has been re-vamped for Office 2013, with a tab that lets you pull up recently accessed documents. This list can incorporate e-mail chains, pc drives, lately browsed sites, and some online databases. What is more, it is possible 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 Office detecting what words you're about to type founded only around the first couple of letters. Microsoft's new algorithm can see patterns in numerical information. The Flash Fill tool of Excel 2013 enables you to discover patterns within the numbers you input and then automatically fill remaining entries with all the info. For those who need to apply a common figure to existing numbers, such as an increase for inflation, the Flash Fill can effortlessly and quickly plug in numbers that would previously require making use of the calculator function. This applies to numbers at the same time as names and time, in order that you are able to Flash Fill the projected figures months and years from now.
Ask For a Recommendation
Among the intuitive new features 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, you'll be able to click around to find out how your numbers would appear in numerous visual styles. All you must do when you find the graph that looks right is hit OK and it will be created and added to your document.
Analyze In Rapid Time
Having the ability to work with the info as quickly as it has been typed into every cell is amongst the most appealing parts of what's new in Excel 2013. The Quick Analysis allows you to pull up a brick of cells or info and then play around with it. You may use Quick Analysis so as 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 create tables for other users. Immediately after previewing each and every tally or chart, simply 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 in 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 information as you need, remove any unnecessary parts, and use any texts or themes which you feel work best for the presentation. Preview it before it's ready to go and put it in an email or on a projector.
As you may see Excel 2013 brings some decent new options to the table. Now it is up to you to determine if the latest features justify an upgrade.
Start out At the Beginning
The new Office 2013 software uses a start screen that is 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 current files automatically. This lets you hold the worksheets pinned to a selection of recent activity in order that it's visible and comes up with no need of any loading. You can automatically import current workbooks or templates from your hard drive, a disk, and the cloud. New templates may be pinned alongside the current files to far better permit you to boot up your work.
Look Towards the Rear
One of many well-known features of Office 2010 was the Backstage View, a means of calling up different files as a way to import data without swapping out tabs or pulling up a different software program. This View has been re-vamped for Office 2013, with a tab that lets you pull up recently accessed documents. This list can incorporate e-mail chains, pc drives, lately browsed sites, and some online databases. What is more, it is possible 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 Office detecting what words you're about to type founded only around the first couple of letters. Microsoft's new algorithm can see patterns in numerical information. The Flash Fill tool of Excel 2013 enables you to discover patterns within the numbers you input and then automatically fill remaining entries with all the info. For those who need to apply a common figure to existing numbers, such as an increase for inflation, the Flash Fill can effortlessly and quickly plug in numbers that would previously require making use of the calculator function. This applies to numbers at the same time as names and time, in order that you are able to Flash Fill the projected figures months and years from now.
Ask For a Recommendation
Among the intuitive new features 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, you'll be able to click around to find out how your numbers would appear in numerous visual styles. All you must do when you find the graph that looks right is hit OK and it will be created and added to your document.
Analyze In Rapid Time
Having the ability to work with the info as quickly as it has been typed into every cell is amongst the most appealing parts of what's new in Excel 2013. The Quick Analysis allows you to pull up a brick of cells or info and then play around with it. You may use Quick Analysis so as 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 create tables for other users. Immediately after previewing each and every tally or chart, simply 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 in 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 information as you need, remove any unnecessary parts, and use any texts or themes which you feel work best for the presentation. Preview it before it's ready to go and put it in an email or on a projector.
As you may see Excel 2013 brings some decent new options to the table. Now it is up to you to determine 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.
iklan ads