advanced excel ms training

advanced excel ms training - Macros

Resolved · Low Priority · Version Standard

Macros

James has attended:
Excel Intermediate course
Excel Advanced course

by - delegate James [2 posts] (2007 Sep 14 Fri, 09:41) Reply

How do I create custom buttons for a macro on my toolbar

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	1	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	6	book now	£214	£230
Full Schedule: See all 96 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Macros

by - trainer Anthony gold contributer [113 posts] (2007 Sep 25 Tue, 16:05) Reply

Hi James. Go to Tools - Customise and select the Command tab. Then in Categories, choose macros and drag one of the smileys on the left hand side up onto your toolbar. Then right click on that smiley and select assign macro. Simple as that!

Hope this helps,

Anthony

· A Beginners Guide To Formulas In Excel
· Microsoft Excel Training Course
· Advanced Excel Training - takes you to the next level
· Do You Really Need Excel VBA Training?
· Microsoft Excel's Best Kept Secret

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips

Rate this page: