Excel VBA

The UK's most regular instructor-led training courses.
Training information: vba-excel-training · Excel courses london · VBA training in London

Resolved · Low Priority · Version 2003

Excel VBA

Jenny has attended:
Excel VBA course
Excel VBA course
Project Management course

by - delegate Jenny [2 posts] (2008 Apr 29 Tue, 12:27) Reply

What Excel VBA book would you recommend as a bible?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003	2008 Sep 3 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	7	book now	£203	£230
Full Schedule: See all 127 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excel VBA

by - trainer Alan silver contributer [59 posts] (2008 May 18 Sun, 16:55) Reply

Microsoft publishes its own range of books - these are subject specific or you can buy a set which covers all the Office applications VBA options.

Personally I would use books published by QUE as they are written by users and not programmers!

· Do You Really Need Excel VBA Training?
· How to Create Better Excel Spreadsheets: Part Four
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Customized Financial Excel Courses in London
· Database Tips from an Excel Training Course

Please browse our web site to find out more about
vba-excel-training and other Microsoft training courses.

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips