if statements and v

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » If statements and v look ups

If statements and v look ups

resolvedResolved · Urgent Priority · Version 2016

Saima has attended:
Excel Intermediate course
Excel Advanced course

If statements and v look ups

could i please be sent as much information as possible for if statements and v look ups to get a better understanding.

RE: if statements and v look ups

Hi Saima,

Thank you for you question via our forum, I would recommend you watch the following YouTube videos;

IF Formula: Simple to Advanced
https://www.youtube.com/watch?v=KkTaQ5OjAGc

VLookup Basics
https://www.youtube.com/watch?v=E7gQ-PgYkMc

If you would like to have some content to read, download the following folder;

https://www.stl-training.co.uk/download/delegate/onsite/Excel_Adv_Post-Course_458792.zip


Hope I have answered your question, if you have any more questions don't hesitate to contact us via the Forum.


Regards,
Max SHAMSAN
Hi Saima,

Thank you for you question via our forum, I would recommend you watch the following YouTube videos;

IF Formula: Simple to Advanced
https://www.youtube.com/watch?v=KkTaQ5OjAGc

VLookup Basics
https://www.youtube.com/watch?v=E7gQ-PgYkMc

If you would like to have some content to read, download the following folder;

https://www.stl-training.co.uk/download/delegate/onsite/Excel_Adv_Post-Course_458792.zip


Hope I have answered your question, if you have any more questions don't hesitate to contact us via the Forum.


Regards,
Max SHAMSAN
Microsoft & Apple Applications Specialist Trainer

Tel: 0207 987 3777
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

Fri 7 Dec 2018: Automatically marked as resolved.


 

Excel tip:

Hide separate columns in Excel 2010

If you want to hide columns not adjacent to each other for example, Columns A, C and E then:-

1) Click on the fist column to be hidden i.e. A

2) Press and hold down the CTRL key

3) While holding the CTRL key, left click on the rest of the columns you want to hide i.e. C and E

4) Right click and choose Hide

View all Excel hints and tips


Server loaded in 0.11 secs.