excel training uk - The training CD that came with my pack

The UK's most regular instructor-led training courses.
Training information: excel training uk · Excel course · VBA courses London UK

Resolved · Low Priority · Version Standard

The training CD that came with my pack

Ben has attended:
Excel VBA course
Access Introduction course

by - delegate Ben [11 posts] (2007 Dec 6 Thu, 16:10) Reply

The CD that came with my MS Excel VBA course book does not work. Please could I be sent another.

Thanks,

Ben

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	3	book now	£475	£495
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	3	book now	£475	£495
2003	2008 Oct 23 Thu + 24 Fri	Southwark	4	book now	£475	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: The training CD that came with my pack

by - trainer Amanda platinum contributer [968 posts] (2007 Dec 11 Tue, 15:35) Reply

Hi Ben

Thank you for bringing this to our attention. I will arrange to have another CD sent out to you.

Amanda

· Microsoft Office and the Small Business: Part 1 Excel
· A Beginners Guide To Formulas In Excel
· Tap the Power of Recorded Macros with MS Excel Courses
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Compare Different MS Excel Training Methods

Excel tip:

Use RANDBETWEEN to generate random numbers

There may be occassions where you need to generate random numbers in your spreadsheet. Use the RANDBETWEEN function to generate random numbers between two values that you specify.

The function looks like this:

=randbetween(LOW,HIGH)

where LOW is the lowest number you want generated; and HIGH is the highest number you want generated.

This formula will work with both positive and negative LOWs and HIGHs. Also it will only generate integer numbers unless forced to do otherwise by the following:

=randbetween(LOW*10^PRECISION,
HIGH*10^PRECISION)/(10^PRECISION).

where PRECISION represents the levels of decimal precision needed (i.e. if you need numbers with one decimal place, PRECISION would be 1; 2 for two decimal places and so on).

One final note, if the RANDBETWEEN formula does not work in your spreadsheet or returns a "#NAME" error, you need to install the Analysis Toolpak Add-In. You will need to press F2 then Enter following the installation.