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
Monday, February 28, 2011
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
Subscribe to:
Posts (Atom)