excel training courses - Codes

The UK's most regular instructor-led training courses.
Training information: excel training courses · Microsoft+excel+training · VBA courses London

Resolved · Low Priority · Version Standard

Codes

Wilma has attended:
Word Introduction course
Word Intermediate course
Excel Advanced course
Excel VBA course

by - delegate Wilma [3 posts] (2007 Jul 6 Fri, 16:30) Reply

Where do I find a dictionary on all the codes I can use?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 28 Thu	Southwark	0	FULL
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Sep 4 Thu	Bayswater	5	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
Full Schedule: See all 139 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Codes

by - trainer Richard platinum contributer [779 posts] (2007 Jul 11 Wed, 11:30) Reply

Wilma,

Are you referring to functions and formulas or are you looking for VBA codes?

Regards

~Richard

RE: Codes

by - delegate Wilma [3 posts] (2007 Jul 11 Wed, 11:35) Reply

Richard

The VBA Code.

Regards,
Wilma

RE: Codes

by - trainer Richard platinum contributer [779 posts] (2007 Jul 13 Fri, 12:03) Reply

Wilma

This Microsoft webpage will give you a comprehensive list of all aspects of VBA code.

http://msdn2.microsoft.com/en-us/library/aa272268(office.11).aspx

The "codes" you refer to are called methods or properties.
You can drill down to great detail using this website.

Regards

Richard

· Compare Different MS Excel Training Methods
· How to check for and reduce errors in Microsoft Excel
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Advanced Excel Training - takes you to the next level
· Features of Microsoft Excel that assist in Analysis of Financial Data

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips