v look up , r look up, pivot table

This query is : Resolved

Share Report Follow Query Ask a Query

Querist : Anonymous

Querist : Anonymous (Querist)

16 July 2010 some body tell me that wt is the use of v look up, r look up and pivot table in exel it's urgent

CA. BIJENDER KR. BANSAL

CA. BIJENDER KR. BANSAL (Expert)
Follow

16 July 2010 VLOOK UP
This function scans down the row headings at the side of a table to find a specified item.When the item is found, it then scans across to pick a cell entry.

There is no R look up in excel

HLOOKUPThis function scans across the column headings at the top of a table to find a specified item.When the item is found, it then scans down the column to pick a cell entry.

pivot table

biggest advantage to using Pivot Tables is the fact that we can generate and extract meaningful information from a large table of information within a matter of minutes. Or perhaps it is because they will not use up a lot of memory from your PC. In a lot of cases we could get the same results from a table of data by using Excels built in functions, but this would take more time and use far more memory. On top of this, if we wanted some new information we can simply drag-and-drop (pivot). We can also opt to have our information update each time we open the Workbook and/or by clicking refresh.

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Similar Resolved Queries

Unanswered Queries

Popular
Recent

Trending Online Classes

Direct Tax Laws & International Taxation May 26,Sept 26 & Jan 27

CA Arvind Tuli

Enroll Now
Audit Fast Track Recorded Batch For May 26,Sept 26 & Jan 27

CA Aarti Lahoti

Enroll Now
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English

CA Bhanwar Borana & CA Shubham Keswani

Enroll Now

view all classess

Meet our CAclubindia PRO Members

bhavesh

Srikanthan S

rana andcompany

Pranab Banerjee

Gurunathan kannan

Subscribe Now

v look up , r look up, pivot table

Similar Resolved Queries

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

GST CONSULTANT

GST CONSULTANCY

Senior Executive

Accountant

CA Final

Manager- Finance and Compliance