Advance excel

Resolved · Medium Priority · Version 365

Tue 6 Feb 2024, 16:39 Delegate Yemisi said...

Yemisi has attended:
Excel Intermediate course

Advance excel

V- look up

Thu 8 Feb 2024, 08:14 Trainer Martin said...

RE: Advance excel

Hi Yemisi,

Thankyou for your question to the forum.

The VLOOKUP is a very powerful tool for being able to do a search on specific data and also cross referencing lists. Here is a link to a tutorial on the VLOOKUP:

https://www.youtube.com/watch?v=hwL6KKJP-_I

I hope you find this useful

Kind regards
Martin Sutherland
(IT Trainer)

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Line breaks in a cell

You can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it.

Click the cell where you want the label or heading to appear.
Type the first line of information.
Press ALT+ENTER.

View all Excel hints and tips