v look up , r look up, pivot table
This query is : Resolved
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
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.
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
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Is this income indian or foreign income?
- ITC temporary reversal and reclaim
- Applicable TDS rate for sale of property in Nov 2024
- Inventory of finished goods
- Can we claim ITC of Feb-2024 in the month of November-2024 which was not claimed by oversight
- Tds on building rent monthly
- Clarification on Documentation of Paid-Up Capital Contribution by Directors
- Quiery in relation to GST liability in case of an advocate who has obtained GST registration.
- RCM INVOICING FROM NOV-2024
- Confusion around Form 26QB fields
- REGARDING ACCOUNTING CODE FOR SERVICE TAX PAYMENT
- Redevolpment of bldg in mumbai
- Refund of AY 22-23
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
Trending Online Classes
CAclubindia
