Together with the brand-new release of the 2013 version of Microsoft Office, many of us are curious about what exactly is new in Excel 2013 and what modifications have taken place in the most well-known software program on the planet. The new spreadsheet program has not undergone any drastic changes, but there are a number of tweaks that make it less difficult to make use of for equally novice and veteran number-crunchers. New apps and Excel 2013 new features enable users to browse through quicker and compile information with significantly less input.
Start out At the Beginning
The new Office 2013 software package makes use of a start screen that is 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 allows you to keep the worksheets pinned to a list of current activity so that it is always visible and comes up without requiring any loading. You'll be able to 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 much better permit you to boot up your work.
Look To the Rear
Among the list of well known features of Office 2010 was the Backstage View, a method of calling up different files in order 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 enables you to pull up recently accessed documents. This list can include things like e-mail chains, pc drives, lately browsed locations, and a few online databases. What is more, you are able to make use of the View to open a SkyDrive account that shares files amongst 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 initial couple of letters. Microsoft's new algorithm can see patterns in numerical data. The Flash Fill tool of Excel 2013 allows you to discover patterns within the numbers you input and then automatically fill remaining entries with the data. For all those who have to apply a common figure to existing numbers, for instance 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 as well as names and time, so that you could Flash Fill the projected figures months and years from now.
Ask For a Recommendation
Among the list of intuitive new functions of Excel 2013 is 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 may click around to find out how your numbers would appear in different visual styles. All you must do once you find the graph that looks right is hit OK and it will be produced and added to your document.
Analyze In Rapid Time
Being able to work with your info as soon as it has been inserted into every cell is amongst the most thrilling parts of what is 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 are able to use Quick Analysis as a way to format your numbers by dates or numerical orders; you'll be able to build new charts; you'll be able to total up the running tally; or you are able to build tables for other users. Following previewing each and every tally or chart, just click OK and is going to 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 within the software. Power View is good for turning a bunch of numbers into a presentable format in case you want to make a presentation or want the equivalent of a PowerPoint slide for the information. Create a working title, organize the information as you need, filter out any unnecessary parts, and use any texts or themes which you really feel work best for the presentation. Preview it before it is prepared to go and put it in an e-mail or on a projector.
As you may see Excel 2013 brings some nice new functions to the table. Now it is up to you to determine if the latest capabilities warrant an upgrade.
Start out At the Beginning
The new Office 2013 software package makes use of a start screen that is 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 allows you to keep the worksheets pinned to a list of current activity so that it is always visible and comes up without requiring any loading. You'll be able to 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 much better permit you to boot up your work.
Look To the Rear
Among the list of well known features of Office 2010 was the Backstage View, a method of calling up different files in order 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 enables you to pull up recently accessed documents. This list can include things like e-mail chains, pc drives, lately browsed locations, and a few online databases. What is more, you are able to make use of the View to open a SkyDrive account that shares files amongst 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 initial couple of letters. Microsoft's new algorithm can see patterns in numerical data. The Flash Fill tool of Excel 2013 allows you to discover patterns within the numbers you input and then automatically fill remaining entries with the data. For all those who have to apply a common figure to existing numbers, for instance 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 as well as names and time, so that you could Flash Fill the projected figures months and years from now.
Ask For a Recommendation
Among the list of intuitive new functions of Excel 2013 is 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 may click around to find out how your numbers would appear in different visual styles. All you must do once you find the graph that looks right is hit OK and it will be produced and added to your document.
Analyze In Rapid Time
Being able to work with your info as soon as it has been inserted into every cell is amongst the most thrilling parts of what is 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 are able to use Quick Analysis as a way to format your numbers by dates or numerical orders; you'll be able to build new charts; you'll be able to total up the running tally; or you are able to build tables for other users. Following previewing each and every tally or chart, just click OK and is going to 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 within the software. Power View is good for turning a bunch of numbers into a presentable format in case you want to make a presentation or want the equivalent of a PowerPoint slide for the information. Create a working title, organize the information as you need, filter out any unnecessary parts, and use any texts or themes which you really feel work best for the presentation. Preview it before it is prepared to go and put it in an e-mail or on a projector.
As you may see Excel 2013 brings some nice new functions to the table. Now it is up to you to determine if the latest 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.