Excel

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

Resolved · Low Priority · Version 2007

2 posts

ReplyFri 3 Jul 2009, 16:13Delegate Grace said...

Grace has attended:
Excel Intermediate course
Excel Advanced course

Excel

What are the main advantages of using Macros and are they easy to self learn?

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Fri 19 Mar 2010	Bloomsbury	0	FULL
2003	Wed 24 Mar 2010	Limehouse	7		£212	£217
2007	Fri 26 Mar 2010	Rochester (Hoo)	0	FULL
2007	Mon 29 Mar 2010	Bloomsbury	3		£235	£240
2003	Wed 31 Mar 2010	Southwark	7		£219	£224
2007	Tue 6 Apr 2010	Limehouse	5		£235	£240
Full Schedule: See all 70 Excel Advanced course dates. Bookings currently available until 22nd December 2010.

2,024 posts

ReplyTue 7 Jul 2009, 09:39Trainer Amanda said...

RE: Excel

Hello Grace

Thank you for your question and welcome to the forum.

Macros can be created from within Excel using the macro recorder, found on the Developer Ribbon. Creating a macro this way allows you to record yourself going through a series of steps you would take in Excel to complete a certain task; then play the macro whenever you need to do the same task again in the future.

Macros can also be created by writing VBA code, it is possible to learn this yourself if required however like anything else you might find that you end up having knowledge of certain areas but not a more general or rounded knowledge of VBA coding that is more likely to be acquired through structured training.

Kind regards
Amanda

Mon 13 Jul 2009: Automatically marked as resolved.

· What's In A Name?
· From novice to expert users - Microsoft Excel fits all
· Basic Excel Training
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· How to check for and reduce errors in Microsoft Excel

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

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes

View all Excel hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms and Conditions

Excel

Excel

RE: Excel

Related articles

Excel tip:

Difference between Two Dates