Excel Macro with Loop to Repeat actions

If you have a repeating series of actions (such as inserting a label 12 times) then you can add a Loop to an Excel macro. Just record you macro as you need then at the start of the repeating step put:

For i = 1 to 12

then your recorded code

Next i

This will make the Excel macro repeat 12 times. Excel training Toronto Mississauga Hamilton Ontario can help you with this and other Excel functions. Note "i" is used here but any word will do.

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

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

MS Excel 2010 - Sort by Colour, Training
In Excel 2010 it is possible to sort by colour, this can be useful on it's own but also used with conditional formatting )where Excel applies the colours)

Excel 2010 training Toronto, Mississauga, Ontario

Bert Twomey
MS Office, Excel MOS Trainer

A good way to organize and protect Named Ranges in Excel is to place all of them on a separate  worksheet. This sheet can then be protected and also hidden from view (but the named ranges still work)
An added bonus is the ability to copy this sheet to a new workbook so all your named ranges are ready for use. Excel training Toronto, Ontario

Bert Twomey
Excel 2010/2007/2003 trainer
Mississauga, Toronto, Ontario

Pivot Tables in Excel 2007 & Excel 2010

The Pivot Tables in Excel 2007 & 2010 are easier to use that the older Excel 2003 versions. To sort values just right click on the relevant number and a context menu will show the "Sort" option.
That's all you have to do
Excel 2010 training Toronto, Mississauga, Ontario

Bert Twomey
Excel 2010 & 2007 trainer Toronto

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