Get Excel to fill in the blanks under a name. if you have a name listed once in a column and then a few spaces until the next name you can get excel to copy each name down. Use Control G and use special Go to Blanks, (then all the blanks are selected) then type =A3 (the first blank) and control Enter. Excel will copy each name down as needed.
http://www.actionebiz.com/exceltraining.htm

Bert Twomey
MS Office and Excel Trainer
Toronto, Mississauga, Ontario Canada
905-271-1119

Array formulas in Excel workbooks - use COUNTIFS & SUMIFS instead

Often people have array formulas set up in their Excel workbooks but are not sure how they work. (you will usually know an array formula because of the { and } brackets at the ends. Often these array formulas are counting or summing some values based on multiple criteria (city 'ABC" and month "Jan" for instance (note the count array function will use SUM & IF)
How these array formulas work is too complex for this most BUT the good news is that COUNTIFS & SUMIFS in Excel 2007 or excel 2010  functions will usually replace them. Just work out what the criteria is and test

MS Excel 2010 formulas, COUNTIFS & SUMIFS Toronto Excel training

Bert Twomey
MS Office & Excel trainer
Mississauga, Toronto, Ontario
905-271-1119

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