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

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, 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