exceltoxl.com

Hi there,

Are you new to Excel? Do you want to Master Excel Functions, VLOOKUP & HLOOKUP?

Here is an opportunity. I have made this video to one of our viewer who wants to learn these functions from basics.

However, I am sharing to all of you if at all you are looking for the same. So, here you go:

You can also watch this video here VLOOKUP and HLOOKUP Basics

...

Download working file here, VLOOKUP and HLOOKUP_Basics.xlsx

WHAT YOU CAN LEARN FROM THIS VIDEO?

1. How to Start a Formula?

2. Importance of + Symbol in Formula?

3. Define VLOOKUP & HLOOKUP?

4. How to Change Range Selection from Mouse?

5. How Effectively you can use VLOOKUP Function?

6. When These Functions Work? and When Not?

7. Difference Between VLOOKUP & HLOOKUP?

WHAT YOU NEED TO SEE In NEXT VERSION?

Next series of VLOOKUP & HLOOKUP is getting ready and if at all you want to share your tips and tricks to add it to the video, you are welcome.

Please leave a comment if at all I need to include your points to my next video.

Do you want to Join Our Family?

SOME IMPORTANT LINKS:

Combine all text cells to one cell

20 ways of pasting techniques (revealed) 

Auto Filling tricks in Excel

Difference between Wrap Text and Justify 

Shortcut to open Ms Office Applications

Thanks,