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

MS Excel 2007/2010 Sorting by colour training Toronto Mississauga

Do you know you can sort by colour in Excel 2010. Beware of subtle shades as that would lead to confusion but this feature work well with Conditional formatting. With Excel sort and colours applied by a conditional format you can see the data that is relevant to you
Ckeck out MS Excel 2007/2010 Sorting by colour training Toronto Mississauga for more Excel training

Bert Twomey
Excel Training