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
Wednesday, November 9, 2011
Wednesday, August 31, 2011
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 2003/2007/2010 camera Toronto, Mississauga, Ontario Canada
Bert Twomey
MS Excel Training Toronto, Mississauga Ontario
ACTION eBIZ INC
Thursday, May 5, 2011
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
Go to MS Excel 2007/2010 Training Tables Toronto Mississaugaga
for more info
Bert Twomey
MS Office & Excel trainer
Toronto, Mississauga, Ontario
Monday, April 11, 2011
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 Training Right Text Toronto Mississauga
Bert Twomey
MS Excel Trainer Toronto Mississauga
Tuesday, March 22, 2011
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 Functions Left Training Toronto Mississauga
Bert Twomey
MS Excel Trainer
Toronto Mississauga
Friday, March 18, 2011
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,
Bert Twomey
MS Excel Training
Toronto, Mississauga,
Monday, March 14, 2011
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
Bert Twomey
Excel Trainer
MS Excel 2010 new function Rank.AVG training Toronto, Mississauga
Monday, March 7, 2011
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
Ckeck out MS Excel 2007/2010 Sorting by colour training Toronto Mississauga for more Excel training
Bert Twomey
Excel Training
Monday, February 28, 2011
MS Excel Training Delete Duplicates Toronto, Mississauga
In Excel 2010 there is a button on the Data Tab to "remove duplicates" (maybe a good ideas to copy the original list and compare). This can also be done in Excel 2007 or Excel 2003 - select the list and use Data - Filter - Advanced filter, this gives a dialogue box that you can copy the list to a new location and at the bottom is the check box "unique values only" (no filter is applied). many more topics at:
MS Excel Training Delete Duplicates Toronto, Mississauga
Bert Twomey
MS Excel Training
MS Excel Training Delete Duplicates Toronto, Mississauga
Bert Twomey
MS Excel Training
Wednesday, February 23, 2011
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
Bert Twomey
MS Excel Trainer
Toronto Mississauga
Wednesday, February 9, 2011
Excel training Toronto Mississauga
new functions such AverageIFS are in Excel 2010, this means you can find the average of cells based on multiple criteria - very useful Excel function to save time. click on Excel training Toronto Mississauga, for more info re Excel training
Bert Twomey
Excel trainer
Bert Twomey
Excel trainer
Monday, February 7, 2011
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
Bert Twomey
MS Excel Training
Thursday, February 3, 2011
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
Bert Twomey
Excel Trainer Toronto Mississauga
Tuesday, February 1, 2011
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 2007 training Toronto, Mississauga for more training
Bert Twomey
MS Excel Trainer
Monday, January 24, 2011
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
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
Subscribe to:
Posts (Atom)