If statements and v look ups

Resolved · Urgent Priority · Version 2016

Thu 29 Nov 2018, 16:43 Delegate Saima said...

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.

Fri 30 Nov 2018, 12:18 Trainer Max said...

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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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