excel training uk - macros
The UK's Number 1 for Microsoft Office Training
Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training uk - Macros

Recommend training98.1 %
recommend us
More live stats...

The UK's most regular
instructor-led training courses.

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

See also:
Hints and tips
Forum topics

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

excel training uk - Macros

resolvedResolved · Low Priority · Version Standard

replyReply Wed 10 Oct 2007, 16:25Delegate Justin said...

Justin has attended:
Powerpoint Intermediate Advanced course

Macros

can I find any pre-prepared macros anywhere

For upcoming training course dates see: Pricing & availability

replyReply Mon 15 Oct 2007, 10:17 Edited on Mon 15 Oct 2007, 10:17Trainer David said...

RE: macros

Hi Justin

You may find the following site helpful if you are looking for VBA macros that have already been created and are ready for use.

VBA macro code

Hope this helps
David

 

Excel articles

· How To Create A Macro In Excel 2010
· Compare Different MS Excel Training Methods
· Share And Share Alike - Use Excel To Collaborate As A Winning Team!
· Excel 2010 - Is It Worth The Upgrade?
· Using Excel In Any Condition

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. infomst
All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy