Course Documentation

Resolved · High Priority · Version 2003

Tue 21 Sep 2010, 14:42 Delegate Florian said...

Florian has attended:
Excel VBA Advanced course

Course Documentation

Hello,

While in training last July, I was told that the doc provided with my Advanced VBA course would be updated shortly after. As the end of September is approaching, I was wondering when would this doc be availlable?

Thanks,

Florian

Tue 21 Sep 2010, 15:23 Trainer Stephen said...

RE: Course Documentation

Hi Florian

I am currently working on this, and hope to have things finalised within the next few weeks.
If you email me on sw@stl-training.co.uk I will email you back when it is complete

Regards

Stephen

Tue 28 Sep 2010: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

View all Excel hints and tips