Computer Services

Due to the recent release of the 2013 version of Microsoft Office, plenty of people are curious about what exactly is new in Excel 2013 and what changes have taken place in the most common software program on the planet. The latest spreadsheet program hasn't undergone any drastic modifications, but there are a couple of tweaks that make it easier to use for equally novice and veteran number-crunchers. New apps and Excel 2013 new options enable users to browse through more rapidly 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 differing 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 current files automatically. This permits you to hold the worksheets pinned to a selection of current activity so that it is visible and comes up with no need of any loading. You are able to automatically import old workbooks or templates from your hard drive, a disk, or the cloud. New templates may be pinned alongside the current files to much better allow you to boot up your work.

Look Towards the Rear

One of many popular capabilities of Office 2010 was the Backstage View, a means of calling up several files to be able to import data with out swapping out tabs or pulling up a new software program. This View has been re-vamped for Microsoft Office 2013, with a tab that allows you to pull up recently accessed documents. This list can include e mail chains, laptop or computer drives, lately browsed locations, and some online databases. What's more, you'll be 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 Microsoft office detecting what words you might be about to type founded only on the first couple of letters. Microsoft's new algorithm can see patterns in numerical data. The Flash Fill tool of Excel 2013 permits you to discover patterns inside the numbers you input and then automatically fill remaining entries with all the information. For those who must apply a common figure to existing numbers, for example an increase for inflation, the Flash Fill can very easily and quickly plug in numbers that would previously call for using the calculator function. This applies to numbers at the same time as names and time, in order that you can Flash Fill the projected figures months and years from now.

Ask To get a Recommendation

One of many intuitive new functions of Excel 2013 is the Recommended Charts app. This pulls up a subset of the figures you've 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 various visual styles. All you have to do when you see the graph that looks appropriate 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 inserted into each cell is among the most exciting parts of what is new in Excel 2013. The Quick Analysis lets you pull up a brick of cells or data and then play around with it. You'll be able to use Quick Analysis in order to format your numbers by dates or numerical orders; you'll be able to create new charts; you can total up the running tally; or you are able to produce tables for other users. Immediately after previewing each and every tally or chart, merely click OK and it will be applied to 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 incorporated within 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 information as you need, filter out any unnecessary parts, and use any texts or themes that you really 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 nice new capabilities to the table. So now it is up to you to consider if the latest features justify an upgrade.