Due to the brand-new release of the 2013 version of Microsoft Office, many people are curious about what exactly is new in Excel 2013 and what modifications have taken place in the most well-liked software program on the planet. The latest spreadsheet tool has not undergone any drastic changes, but you'll find a couple of tweaks that make it easier to utilize for equally novice and veteran number-crunchers. New apps and Excel 2013 new functions enable users to browse through more quickly and compile information with much less input.
Start At the Beginning
The new Office 2013 software package utilizes a start screen that's different 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 recent files automatically. This permits you to keep the worksheets pinned to a list of current activity to ensure that it's visible and comes up free of any loading. It is possible to automatically import old workbooks or templates from your hard drive, a disk, or even 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-liked capabilities of Office 2010 was the Backstage View, a method of calling up several files to be able to import data without swapping out tabs or pulling up a brand new program. This View has been re-vamped for Office 2013, with a tab that enables you to pull up recently accessed documents. This list can include things like e-mail chains, laptop or computer drives, lately browsed sites, and some online databases. What's more, you can make use of the View to open a SkyDrive account that shares files among registered users.
Seeing The Patterns
Pattern recognition software has come a long ways since the days of Office detecting what words that 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 permits you to find patterns inside the numbers you input and then automatically fill remaining entries with all the data. For those who want to apply a common figure to existing numbers, like an increase for inflation, the Flash Fill can easily and instantaneously plug in numbers that would previously need utilizing the calculator function. This applies to numbers as well as names and time, to ensure that you could Flash Fill the projected figures months and years from now.
Ask To get a Recommendation
One of the intuitive new functions 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, it is possible to click around to find out the way your numbers would appear in a variety of visual forms. All you will need to do once you find the graph 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 all your data as quickly as it has been entered into every cell is one of the most interesting 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 can use Quick Analysis as a way to format your numbers by dates or numerical orders; you can make new charts; you are able to total up the running tally; or you are able to create tables for other users. Immediately after previewing each and every tally or chart, just 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 integrated inside the application. Power View is excellent 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 information as you need, filter out any unnecessary parts, and use any texts or themes which 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 can see Excel 2013 brings some nice new functions to the table. 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 utilizes a start screen that's different 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 recent files automatically. This permits you to keep the worksheets pinned to a list of current activity to ensure that it's visible and comes up free of any loading. It is possible to automatically import old workbooks or templates from your hard drive, a disk, or even 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-liked capabilities of Office 2010 was the Backstage View, a method of calling up several files to be able to import data without swapping out tabs or pulling up a brand new program. This View has been re-vamped for Office 2013, with a tab that enables you to pull up recently accessed documents. This list can include things like e-mail chains, laptop or computer drives, lately browsed sites, and some online databases. What's more, you can make use of the View to open a SkyDrive account that shares files among registered users.
Seeing The Patterns
Pattern recognition software has come a long ways since the days of Office detecting what words that 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 permits you to find patterns inside the numbers you input and then automatically fill remaining entries with all the data. For those who want to apply a common figure to existing numbers, like an increase for inflation, the Flash Fill can easily and instantaneously plug in numbers that would previously need utilizing the calculator function. This applies to numbers as well as names and time, to ensure that you could Flash Fill the projected figures months and years from now.
Ask To get a Recommendation
One of the intuitive new functions 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, it is possible to click around to find out the way your numbers would appear in a variety of visual forms. All you will need to do once you find the graph 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 all your data as quickly as it has been entered into every cell is one of the most interesting 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 can use Quick Analysis as a way to format your numbers by dates or numerical orders; you can make new charts; you are able to total up the running tally; or you are able to create tables for other users. Immediately after previewing each and every tally or chart, just 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 integrated inside the application. Power View is excellent 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 information as you need, filter out any unnecessary parts, and use any texts or themes which 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 can see Excel 2013 brings some nice new functions to the table. 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.
Không có nhận xét nào:
Đăng nhận xét