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 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 2007/2010 Training Tables Toronto Mississaugaga

In MS Excel 2007/2010 using the Home Tab you can format lists as Tables. Just use the "Format as table" button. This table has filters applied and also expands as you add to it - so handy for expanding pivot tables etc. Colour bands can be applied also
Go to MS Excel 2007/2010 Training Tables Toronto Mississaugaga
for more info

Bert Twomey
MS Office & Excel trainer
Toronto, Mississauga, Ontario

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 Functions Training Toronto Mississauga

MS Excel has many text useful text functions such as LEFT. The Excel Left function extracts a specified number of characters form the left. This can be very useful if you only need the first 4 characters on the left =LEFT(A4,4)
MS Excel Functions Left Training Toronto Mississauga

Bert Twomey
MS Excel Trainer
Toronto Mississauga

MS Excel Training Text Length Toronto, Mississauga

Excel 2010/2007 and older versions can examine and change text for you. Many people have product codes importing into Excel and then prepare reports but many times Excel does not work with the numbers. The first function to use is LEN - this tells you the length of the string ( as there may be blanks also). More training at http://www.actionebiz.com/exceltraining.htm

Bert Twomey
MS Excel Training
Toronto, Mississauga,

MS Excel 2010 new function Rank.AVG training Toronto, Mississauga

In Excel 2010 there is a new Average Rank function. If 2 values are the same and come in at second place then they get 2.5 each (versus 2 & 2 for Rank function). If 4 values came in second they would get 3.5 each and no second, fourth or fifth place versus all getting 2 in Rank. Take a look at http://www.actionebiz.com/exceltraining.htm for more Excel 2010 training

Bert Twomey
Excel Trainer






MS Excel 2010 new function Rank.AVG training Toronto, Mississauga