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

further training needs

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Further training needs

Further training needs

ResolvedVersion 2007

Christine has attended:
Excel Advanced course

Further training needs

Are there any courses which concertrate on look ups

RE: Further training needs

Hi Christine

Thanks for getting in touch, I hope you enjoyed your Excel Advanced course.

VLOOKUPS were of course covered during the day, although some delegates like to take this knowledge further. We offer a 1 day course covering many different formulas and functions, including LOOKUPS. There are also many similar functions discussed, including INDEX and MATCH which are often used when a LOOKUP is inadequate. You will also look at how and when to nest LOOKUP functions, and combining them with an IF function to make your workbooks more error-tolerant.

If you'd like more information, you can find out about it here:

https://www.stl-training.co.uk/syl/26/excel-formulas-functions.html

I hope this helps, if you have any further questions or something specific about the LOOOKUP please let us know.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 23 Jan 2013: Automatically marked as resolved.

Excel tip:

Trace Dependents / Precedents without the blue arrows

Rather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula.

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.09 secs.