Quality & value training trusted by thousands of UK businesses

We'll call during UK business hours

0207 987 3777

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

	98.8 % recommend us
	More live stats...

Training information:

Macros

Resolved · Low Priority · Version 2007

Thu 30 Apr 2009, 16:56

Reply Delegate HELGA said...

HELGA has attended:
Excel Intermediate course

Macros

what is the macro?

For upcoming training course dates see: Pricing & availability

Thu 30 Apr 2009, 17:11

Reply Trainer Carlos said...

RE: Macros

Hi Helga

A macro is a small program that uses Visual Basic code to automate a sequence of actions.

Macros can be simple holding a few instructions or quite complex involving massive data manipulation and calculations

Hope this helps

Carlos

Thu 7 May 2009: Automatically marked as resolved.

Excel articles

· How To Use Filtering In Excel 2010
· Some Interesting Finds In Excel 2007/2010 Using Find And Select
· How To Use The New Excel Web App
· How To Use The Research Functionality In Excel 2010
· How Excel Can Help You See Into Your Business's Future

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

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips

MS Project training

Course rating:

4.8 stars - based on 5149 reviews

Connect with us: Facebook · Twitter · Google+ · LinkedIn · Pinterest

Resources