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
- Are the income criteria and turnover criteria of 4
- Codonation of delay for filing for 10 BB
- Gst on hired vehicle repair maintenance
- Return defective due to turnover mismatched with I
- Ineligible ITC availed and later reversed under wr
- Temples GST HSN
- Tax filing for the belated payment credit
- Legal service RCM
- OUT OF STATE ADDITIONAL PLACE OF BUSINESS
- Excess claim and paid with DRC03
Trending Online Classes
-
25 Hours GST Scrutiny of Return and Notice Handling(With Recording)
Industry Expert14 February 2025 -
Survey, Search and Seizure under Income Tax Act 1961
CA Hari Agarwal
CAclubindia
