Discover the top ten changes in excel 2010

Discover The Top Ten Changes In Excel 2010

Topics: excel training

Want to find out the key changes in Excel 2010? This article brings you details of the top ten changes to help you to get to grips with what’s new in Excel 2010.

Change one: The Customisable Ribbon

The biggest change to Excel 2010 is that the Ribbon navigator, introduced with Excel 2007, is now fully customisable, so you can add or remove any command to or from any Ribbon Tab. You can also create your own tabs with any commands, so the entire Ribbon can be customised.

Change Two: The Backstage View

The new Backstage View, accessed by the new File Tab, replaces the Office Button in Excel 2007. The Backstage View contains all the Excel file management, Excel options, Help and security features.

Change Three: Recover unsaved files

Excel 2010 users can recover the most recently used file even if it was not saved. To set this, choose the File Tab, then Options, then Save. Under the “Save Autorecover…” box you’ll see a new checkbox “keep the last autosaved version if I close without saving”. Tick it to enable this really useful feature.

Change Four: New Sparklines

These are mini graphs which are placed in single cells. The Sparkline can show a mini chart in a single cell. The chart can be a line, column or Win/Loss bar (shows bar above and below zero) and you can set a Sparkline to data from a range of cells just as you would setup a regular chart. Sparklines are useful to show a trend or data comparison without having to create a separate graph.

Change Five: Pivot Table Slicers

Pivot tables have a new feature called Slicers. These allow you to filter the entire pivot table for one particular item. So if you have a pivot table setup showing various rows, columns and numerical analysis, then you can click the Slicers button to show a panel listing all the pivot table fields. Click on one of the fields in the panel and the entire pivot table is filtered to only show the data for that field. This would be particularly useful for pivot table showing large and relatively complex sets of data. For very large data sets, there’s a new PowerPivot Excel add-in to allow fast data processing.

Change Six: Improved Graphics and Image Editing

Image and picture editing has been improved in Excel 2010 giving you features previously only found in image editing software. For example you can now editing colour saturation and colour temperature in addition to brightness, contrast and sharpness. You can also add artistic effects to an image such as sketch, drawing and texture effects. There’s also a new one click screen capture feature right from within Excel. And there are additional SmartArt graphics which can include images within the graphics.

Change Seven: Improved Conditional Formatting

Excel 2010 contains additional icon sets for conditional formatting such as triangles, starts, boxes and more data bars, and you can also customise icon sets. You can also now set conditional formatting rules from other worksheets.

Change Eight: Improved Collaboration

Individuals or small business users can collaborate on Excel files stored on the web by using the new Excel web app. Users need a free Windows Live ID which allows them to save to up to 25G on the SkyDrive. Saved files can be marked for sharing as appropriate, allowing multi users editing at the same time.

For users in larger organisations using SharePoint, Excel 2010 files can be saved to the SharePoint 2010 server which allows multi user editing through appropriate permissions.

Change Nine: New Security Features

Excel 2010 has a new Protected View which is used if you open a file in from a questionable source such as the internet or from an email attachment. You can set Excel2010 to open files from trusted sources on your computer or a network share, or you can choose to open a protected view file.

Change Ten: Improvements to Solver Add-In

The Excel add-in Solver has been improved to allow the user to choose from different solving methods (non linear as well as linear for those who work in this area).

Additional Changes

There have been improvements to some of the more specialised Excel functions for example some statistical functions have been renamed and there is more accuracy for others.

There are a number of improvements to charts in Excel 2010 for example to be more easily built from large sets of data. If you’re interested in macros, you can now include moving and resizing charts and editing chart formatting within the macro recorder actions.

There are changes to the Excel Paste feature. If you copy one or more cells in Excel 2010, then choose a target cell, you can choose the new Paste live preview lets you see how the various paste options such as values, formulas, formatting etc look prior to applying.

Other Excel improvements include the ability to add equations inside text boxes, and the use of additional themes and styles.

And there are more! To find out more about working with Excel 2010 why not attend a training course and really boost your skills to the next level.

Author is a freelance copywriter. For more information on excel training, please visit

Previous Articles Highlighter:

Working Together Is Easier Than Ever With Excel 2010 (1)
Fortunately, Microsoft Excel 2010 provides all the tools he needs to forge a team effort that's as effective and cohesive as it is appealing and professional. Co-authoring Doug expects there to be a huge quantity and variety of data involved, and knows that the finished work will be both more effective and completed more smoothly if he can work in tandem with colleagues, rather than having data submitted to him to be processed.

Tips To Help You Excel (2)
Like a designer trying to optimise streamlining on a new model of car you should pare away anything that will slow your progress so that you can achieve maximum efficiency with minimum drag.

Using Color Pool Lights To Enhance Your Pool (3)
The pool lighting also makes it very easy for you to see if there is anything in the water. The best reasons to have color pool lights is for the parties.

Create Buttons To Navigate Between Worksheets (4)
You can save even more time by creating a Return button on each sheet and, using the same process as above, create Hyperlinks back to your main page. This does not take very long as you only need create a single button to copy and paste, with no alteration to the text.

How To Use Functions In Excel 2010 (5)
To select it just double click it, and Excel completes the full function name followed by an open bracket. All you then do is complete the rest of the function, for example by dragging a range of cells if appropriate, type a close bracket and press Enter key.

Underwater Pool Lights (6)
There are a few things involved in changing your underwater pool lights. First and most importantly you will want to be sure that the power is shut off both at the breaker and at any other switches.

Pool Light Fixture (7)
Topics: pool light fixture, waterproof lights, swimming pool light fixtures, pool lighting fixtures During the summer, most people like to take advantage of as much swimming pool time as they can get.

Excel 2010 Can Make Your Reports Better And More Detailed Than Ever (8)
He produces a dashboard of key data, both in graphic and numeric form, so that management have all the data they need at their fingertips. And PowerPivot also plays a role in creating this dashboard, and making it more effective.

Home Wind Turbine - Installing Wind Generators At Home (9)
For example, you can do your laundry on windy days and take the chance to charge the batteries whenever it's possible. Having a wind powered generator installed might appear costly, but you will eventually recoup your investment from the energy savings you enjoy.

Data Validation In Excel (10)
How to setup Data Validation Suppose you have a section of an Excel worksheet where you want a user to enter a table of data. For example say we have a table used for entering staff details.

Newer Articles Highlighter:

How To Make Excel Open A Particular File When It Launches (1)
To demonstrate the all users option in Excel 2010 first create or open a workbook you want to auto start with Excel. Then save this file to the XLStart folder at C:Program FilesMicrosoft OfficeOffice14XLStart.

How To Use The Subtotal Function In Excel (2)
Ensure the cell containing the subtotal function is still selected and click on the fx symbol to the immediate left of the editing panel above the spreadsheet. In the Functions Arguments panel the subtotal function should be showing.

Backstage Management With Excel 2010 (3)
The technical stuff may not be hugely exciting but it is absolutely essential and without it the spectacle you have enjoyed would simply not happen. This may seem like a strange metaphor to use at the beginning of an article about Microsoft Excel 2010 but it is not for nothing that Microsoft have chosen to call their substitute File menu Backstage View.

Tell AutoFill What To Do And It Will Oblige (4)
This is at its most basic but it can perform many more intricate tasks than entering the days of the week. But before we look at those here are a few points about the basics of AutoFill.

Conditional Formatting: A Useful Feature Of Excel (5)
I have a workbook set up to track my finances for the whole of 2011 (where each monthly sheet is accessed by the use of nifty buttons) and I have applied a simple formula to do some of the calculating for me.

Document Management Solutions: Combining Process Automation And AP (6)
Ron Thompson, Jr. is the owner and CEO of OSAM Document Solutions, Inc. OSAM provides dynamic, customized document management solutions. For more information about document management solutions, visit

Want To Create A Presentation In Excel? (7)
Firstly scroll down to the section "Display" and untick "Show formula bar". Then secondly in the section "Display options for this workbook" untick "Show horizontal scrollbar", "Show vertical scrollbar" and "Show sheet tabs".

Excel Brings You The Tools To Spice Up Your Spreadsheets (8)
And if you want to use other graphics such as drawings or SmartArt to help display your data, there's more features at your fingertips: Why not take a screenshot and add to your workbook?

Why You Should Use The Copy Center (9)
In a business world that utilized email and the internet to deliver much of their marketing materials, there is still place for the printed flyer or other form of advertisement.

Summing Up Scenarios With Excel (10)
For example, if you reduce the amount of money allocated to advertising, what will you have left to spend on research and development? In Excel 2010, scenarios can be saved, so that you can apply them again with a quick click of the mouse.

Leave a Comment