MS Excel 2010 - Sort by Colour, Training
In Excel 2010 it is possible to sort by colour, this can be useful on it's own but also used with conditional formatting )where Excel applies the colours)

Excel 2010 training Toronto, Mississauga, Ontario

Bert Twomey
MS Office, Excel MOS Trainer

A good way to organize and protect Named Ranges in Excel is to place all of them on a separate  worksheet. This sheet can then be protected and also hidden from view (but the named ranges still work)
An added bonus is the ability to copy this sheet to a new workbook so all your named ranges are ready for use. Excel training Toronto, Ontario

Bert Twomey
Excel 2010/2007/2003 trainer
Mississauga, Toronto, Ontario

Pivot Tables in Excel 2007 & Excel 2010

The Pivot Tables in Excel 2007 & 2010 are easier to use that the older Excel 2003 versions. To sort values just right click on the relevant number and a context menu will show the "Sort" option.
That's all you have to do
Excel 2010 training Toronto, Mississauga, Ontario

Bert Twomey
Excel 2010 & 2007 trainer Toronto

MS Excel 2007 & 2010 shortcut keys Training Toronto

While it is great to have the Ribbon, some people do not like it. Instead you can use the shortcut keys such as Control & 1 keys to pop up the Format cell dialogue box. This Excel 2007 2010 training Toronto can help you

Bert Twomey
MS Office & Excel Trainer

MS Excel 2010 Training Toronto, Ontario, Mississauga GTA

In MS Excel 2010 (and also Excel 2007/2003) it is possible to lock some cells which means people can edit and update certain cells but not others. So the Excel file can be sent out and people will not ruin the format. Take a look at MS Excel 2010 Training:http://www.actionebiz.com/exceltraining.htm for more training

Bert Twomey
MS Excel Trainer
Toronto Mississauga

Excel training Toronto Mississauga Ontario Info tab

The File Info tab in Excel 2010 is very useful as shows information such as the authors name etc. You may want to remove these from an Excel file (training or real) before you send the Excel file. Take a look at Excel training Toronto Mississauga Ontario for more Excel training Toronto

Bert Twomey
MS Excel Training

Excel pivot tables training Toronto Mississauga Ontario

One of the features that is improved with every version of Excel is pivot tables. In Excel 2010 there is the new Splicer option. Take a look at the follow excel link for more Excel pivot tables training Toronto Mississauga Pivot tables can save you a lot of time

Bert Twomey
Excel Trainer Toronto Mississauga

MS Excel 2007/2010 Functions Training Toronto Mississauga, Ontario

A useful new function in MS Excel 2007/2010 is IFERROR which returns a text message or zero etc. if there is an error. Easy to do and a real time saver, check out
MS Excel 2007 training Toronto, Mississauga for more training

Bert Twomey
MS Excel Trainer

MS Excel Training Toronto & Mississauga

While the Ribbon interface is useful to show new users all the features of MS Excel, one area which could lead to trouble is the "Delete" button on the Home Tab of MS Excel 2007 and 2010.
If an MS Excel user presses the "delete" button they delete the contents of the Excel cell and also the Excel cell itself. This can misalign all the rows beneath that deleted cell and make the table worse than worthless, if fact all wrong
See http://www.actionebiz.com/exceltraining.htm
for excel training topics
Bert Twomey
MS Office Excel trainer
Excel training Toronto Mississauga