« VLOOKUP 2nd Version (Advanced) | Custom Markers in Charts » |
VLOOKUP & HLOOKUP Basics
FormulasHi 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)
Difference between Wrap Text and Justify
Shortcut to open Ms Office Applications
Thanks,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments