Hello Dear Freinds, can anybody explain me in details regarding Vlookup, Hlookup, Pivot table with suitable illustration. As now a days this are the necessacity of an organisation. It would be great help if anybody provide me suitable examples and also let me know in which version of excel it is usefull. Thanks in advance.
2 Replies
Mehul Thakkar
(CA CISA DISA CEH MOS Excel Expert)
(194 Points)
Replied 23 August 2014
Hi,
if you are willing to spend some time seeing following youtube videos then pls see the following videos of vlookup, hlookup and pivot tables
Sharmila Sharma
(CFA)
(49 Points)
Replied 24 August 2014
Hello Bhavesh,
I am running a blog where I post on MS Excel options and formulas. In my last post I have discussed about Vlookup function. My focus is to relate every feature of Excel with our day to day life so it becomes easy to understand the concept behind. Following is the link to blog. Hope it will be useful for you to understand the concept. My next post will be on Hlookup function. If you want to get my post on regular basis than you can share your mail id with me I will send you my post.
https://cfasharmilaprasad.wordpress.com/
I also run online classes on traing of Advance MS Excel. Detail is given on the blog.
Happy Sunday :)
Recent Topics
- CLAIMING OF U CLAIMED RCM
- Building construction works
- REGARDING GSTR-9 F.Y 2023-24
- Rectification to decrease income in SCHEDULE OS
- Can Statutory Auditor of a subsidiary become concu
- Client Asking for the Revised Invoice
- Share office desk in bkc, near family court
- 80D claim for payment paid by parent
- TDS on purchase of Flat under subvention scheme be
- GST registration for medical shop in Karnataka
CAclubindia
