excel training onsite

excel training onsite - Macros

Resolved · Low Priority · Version Standard

Macros

Bevan has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Bevan [2 posts] (2007 Sep 20 Thu, 16:32) Reply

Create a Macro

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 2 Tue	Bloomsbury	0	FULL
2003	2008 Dec 4 Thu	Bayswater	3	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	3	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
Full Schedule: See all 110 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Macros

by - delegate Paul gold contributer [121 posts] (2007 Sep 21 Fri, 16:01) Reply

Tools > Macro > Record New Macro

It's literally a recorder that memorises what you do before you stop recording.

such as creating a macro to put borders round cells

· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· Do You Really Need Excel VBA Training?
· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Training Budgets In A Bad Economy

Excel tip:

Get to the end of the used range

What’s the quickest way to get to the bottom right of the used range in your spreadsheet? The two-handed method is Ctrl+End (hold down Ctrl and press End). The one-handed method is End Home (press and release End, and then press and release Home).

The last cell so selected may appear to be empty. However, there is a cell in that row that has an entry or a format and there is a cell in that column that has an entry or format.

View all Excel hints and tips

Rate this page: