Excel

The UK's most regular instructor-led training courses.
Training information: learn excel in london · Excel training courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Excel

Shane has attended:
Excel Introduction course

by - delegate Shane [1 post] (2008 Apr 23 Wed, 16:49) Reply

What is the purpose of macro's, what are the benfits of using them and when is it needed on an excel file.

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

by - trainer Pete platinum contributer [799 posts] (2008 Apr 24 Thu, 08:44) Reply

Hi Shane, welcome to the forum, thank you for your post; the writing/editing and using of macros is covered comprehensively in our Excel Advanced and Excel VBA courses.
But to answer your question; a macro is a recording of mouse clicks and/or of keyboard entries which are recorded by Excel and played back (like a tape recording) whenever required, a macro is usually recorded to undertake mundane or repetitive tasks, either simple or complex, which saves continuously resolving the function manually.
I hope this has helped, if so please click the Resolved link, best regards Pete.

· Microsoft Excel Training - Numerical excellence for all
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· How to check for and reduce errors in Microsoft Excel
· Tips to Facilitate Printing of Excel worksheets
· Microsoft Excel Training: Not Just for Newbies Anymore

Please browse our web site to find out more about
learn excel in london and other Microsoft training courses.

Excel tip:

Counting Non Number Cells (Text)

If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values.

View all Excel hints and tips