Microsoft Excel 2010-MS Excel 2010 new features

Because it was in Excel 2007 when you start a major new software applications, companies are some wrong-getting the inevitable. Fixed a couple of mistakes Microsoft now and Excel 2010 introduces some new features, but is too much of a difference. Whether or not you agree to read this article, see!

On the file menu

In Excel 2007, open, close and delegate training course with us. To save the confusion was used Office button. File disguised as a Ribbon of Microsoft, file tab,, menu click recover now. Now please click the print tab we can?

Customizable Ribbon

In Excel 2003 is to manage time wasn't easy and could not create a number of different toolbar. In Microsoft Excel 2007 was less than the (knew if you had XML way round this) determined only for the user to add to the Quick Access toolbar tool, the default. Excel 2010 we're happy compromise: you can also create your own Ribbon tabs can customize the Quick Access toolbar for users, by default.

Sparklines

Sparklines miniature chart shows in one cell.

In the data table to imagine you're looking for. Each row, see the company 12 months (one per month figure) sales data for name, column 1. Did Sparklines column 14 charts showing sales and same graph to copy this cell, and then create a 12 months, this company. Nice idea, but we see that the impact cannot be.

Slicer

Slicers hope can be forgotten in the static or the next version of Excel, is one of those ideas. Another set of data in a pivot table, it is recommended to create an easy way to search. This problem is what more easy?? using page fields, previous default method we just room for this extra hassle is already an incredible to was very easy to use.

Don't think if you have Excel 2007 features taking screenshots of Excel and other features to increase the maximum file size is a worthy upgrade.

Andy Brown train and develop the Wise Owl business solutions (http://www.wiseowl.co.uk/excel/index.htm) in Excel. You can see more details about the http://www.wiseowl.co.uk/versions/excel/excel-2010.htm Excel 2010 new features.

There is no functionality of Microsoft Excel Excel 2020, some proposals.

Excel training for almost 20 years, but we pretty good ideas to find what people and easy to use is difficult. From this, here are some suggestions of new features Excel 2020 (or due to the next version of when). Small, big range!

Removes the named range.

Here is how to remove the Excel range names you can.

Click the name box drop-down. Right click on the name you want to delete. Select the delete!

We... keep looking for this feature to all new versions of Excel

Autotyping range names, or functions

You can highlight the option when entering formulas in the range name or function, and then enter to continue. For example, type.

Then, + < c 5 = TotalR

Fill automatically TotalRevenue scope name for you to press TAB key or enter this completely. OK, so we are annoying, but do this in Microsoft Visual Studio and the VBA to managed.

Click the print tab of the Ribbon to the

Why not? Bring all that to one print under the roof of one tab will mean a lot.

Conditional formatting to properly integrate.

First conditional formatting since introduction (is in Excel 97, quite remember this, I think) stood apart from the other formatting features. See the style we would like to.
Numeric format alignment font border background protection; and conditional formatting

You must allow to apply a style to cell can affect all available formats.

Bar side indicating the worksheet and workbook

Blue Sky ideas that this: why all worksheets in the workbook in the current image of the sheet of display all open workbooks, or task pane. Click to go to just click the worksheet can. Just a thought.

Style drop-down

Used to move the version of Excel 2003, and press ALT + apostrophe in the style box. Much can also change the style of the current existing cell formatting easily. All new theme very cute, but we sure can have these features back?

At the end (this post is a little if you whingy), we can close the new features are a few good Excel. Ribbon (you are familiar with it and is) a great idea, look and feel better we even Sparklines is like that. Microsoft keep up good work!

Andy Brown is a developer of Excel traner and Wise Owl (http://www.wiseowl.co.uk). You can find details of the differences between the various versions of Excel Http://www.wiseowl.co.uk/versions/excel/index.htm.