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

advance excel training

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Advance excel training - excel working files to practice

Advance excel training - excel working files to practice

ResolvedVersion 2010

Agnieszka has attended:
Excel Advanced course

Advance excel training - excel working files to practice

Hi,
I had an advance excel training in January this year which I found very useful. Could you please send me the excel soft files we were working on in the classroom so I can practice please. I've downloaded the manual but those files would be very very useful.

Many thanks,
Aga
Agnieszka Soltyszewska

RE: Advance excel training - excel working files to practice

Hi Agnieszka

Thanks for your request.

Attached is an Excel Advanced Exercise File completed with answers for you to look back over. It may not be exactly the same as the file you used on the day, but has lots of exercises for you to refresh your skills and the answers are in there so you can check you get it right!

Let us know if there's anything else we can help you with.

Regards,

Sarah
Excel Trainer

Attached files...

Excel Advanced with answers.xlsx

RE: Advance excel training - excel working files to practice

Great, thank you very much Sarah!

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

Server loaded in 0.1 secs.