Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Support / screenshots

Support / screenshots

ResolvedVersion 2003

Fri 25 Jul 2008, 16:32 Delegate Adele said...

Adele has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Support / screenshots

Is it possible to post screenshots as an aid to explain where and with what you need help? Or can a screenshot be emailed to trainers?

Sat 26 Jul 2008, 09:05 Trainer Pete said...

RE: Support / screenshots

Hi Adele,

Thank you for your post, there is a facility to attach a file to a post, however I would suggest that you contact our office to discuss this, as depending upon the complexity and time required to answer your questions, your request for assistance could fall into a consultancy category. regards Pete

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Support / screenshots

Support / screenshots

RE: Support / screenshots

Excel articles

Excel tip:

LARGE and SMALL functions and their uses