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).
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 www.microsofttraining.net
Previous Articles Highlighter:
Working Together Is Easier Than Ever With Excel 2010 (1)
Conditional formatting of data provides an intuitive solution to identifying improving and diminishing figures, or to highlight successes and concerns, either by changing the colour of the data cell or with a range of easily understood symbols (such as stars or traffic lights).
Tips To Help You Excel (2)
You should stick doggedly to the task in hand like the captain of a sailing ship ploughing through a storm; never mind the crashing waves and bolts of lightning going on around you, getting home safely is all that matters.
Using Color Pool Lights To Enhance Your Pool (3)
They can be used for a number of different reasons. If your family enjoys taking night time dips in the pool, color pool lights can be used to determine where the shallow end of the pool is and where the deep end begins.
Create Buttons To Navigate Between Worksheets (4)
Go to the Insert menu and select Shapes. From the collection of various shapes choose the rectangle with curved corners as before. Pull out the rectangle to the desired size and then, in the Format menu, go to Shapes Styles.
How To Use Functions In Excel 2010 (5)
Using the Insert Function for help on particular functions If you select a cell already containing a function, and then click the Fx icon or button, the function panel will open with the help screen for that particular function.
Underwater Pool Lights (6)
One good thing is that it is usually not necessary to lessen the water's level in your pool. Most all underwater lights have a long enough cord which allows for the device to easily be brought up on the ledge for repair.
Pool Light Fixture (7)
The solution is a pool light fixture installed every so often in or around the pool. It's much safer when you have waterproof lights to turn on when swimming at night.
Excel 2010 Can Make Your Reports Better And More Detailed Than Ever (8)
The management haven't got where they are today by making rash decisions, though, so they'll be looking at the situation over a period of time, taking into account the difficulties of establishing the new arm of the company and looking for signs of reliable growth.
Home Wind Turbine - Installing Wind Generators At Home (9)
Depending on your local zoning laws, you may be able to install your home wind turbine on the top of your house. It's like a large fan on the roof!
Data Validation In Excel (10)
So first of all set all cells under the Salary heading to currency format. Now we'll set Data Validation of these salary cells to numbers between 10,000 and 30,000.
Newer Articles Highlighter:
How To Make Excel Open A Particular File When It Launches (1)
The Individual User XLStart folder locations are different for Windows XP and Windows 7. For Windows XP the location is: C:Documents and SettingsUsernameApplication DataMicrosoftExcelXLSTART where Username is your actual username.
How To Use The Subtotal Function In Excel (2)
The most frequently used code numbers are 1 for "AVERAGE", 2 for "COUNT" and 9 for "SUM". To see the full code list, first add the subtotal function to a cell and use, for example, the 9 code to sum some cells.
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)
If I was to have a month when my outgoings exceeded my income and my total slipped into the red, there would be nothing to draw my attention to this other than a miniscule minus sign.
Document Management Solutions: Combining Process Automation And AP (6)
Happy Customers, Happy Employees Prior to the implementation, the insurance company's VP of UW estimated that many of the calls to the call center required someone to pull a file from the file room and call a policy holder back.
Want To Create A Presentation In Excel? (7)
In the View tab you can untick the options for Formula Bar, Status Bar, Row and Column Headers, Horizontal scroll bar, Vertical scroll bar, Sheet tabs and Gridlines. Then click OK to apply.
Excel Brings You The Tools To Spice Up Your Spreadsheets (8)
Other new and improved picture-editing tools available in Excel include a picture corrections tool that allows you to really fine tune the colour of a picture, or adjust brightness, contrast, or sharpness - all without having to use additional photo-editing software.
Why You Should Use The Copy Center (9)
They become a qualified place for drop off for UPS, FEDEX or the Post Office. By doing this they can help supplement their income from their other services as well as be on the radar at the top of people's minds when they determine that they do need to go to a copy place.
Summing Up Scenarios With Excel (10)
You can rename and reposition the Scenario Summary worksheet before you save it as part of the workbook. And if you have two or more Microsoft Excel worksheets that are identical to each other (except that the values are different), you can use the Data Consolidate feature in Excel to consolidate the worksheets into a summary report.