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, Excel 2010 Camera Icon to Display Data

There is camera feature in Excel 2007 & Excel 2010 BUT you have to find it. Use Customize Toolbar or Ribbon in Excel 2007/2010 - find the Camera icon (looks like a camera) and drag to toolbar or Quick Access Toolbar. This camera can then take a screen shot of data and can be placed elsewhere AND the data updates
MS Excel 2003/2007/2010 camera Toronto, Mississauga, Ontario Canada

Bert Twomey
MS Excel Training Toronto, Mississauga Ontario
ACTION eBIZ INC

MS Excel Training Right Text Toronto Mississauga

You can extract some text or numbers form the right (of a product code for example) using the RIGHT function. Right(A2,4) extracts the 4 right characters from A2
MS Excel Training Right Text Toronto Mississauga

Bert Twomey
MS 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