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
- GST Regis.
- Tds on building rent monthly
- Sale of property furniture sale
- Clarification on Documentation of Paid-Up Capital Contribution by Directors
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- RCM INVOICING FROM NOV-2024
- Individual capital equal to which assets of balance sheet
- 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?
- Query for dubts
- Regarding einvoice taken on nil rated sales
Trending Online Classes
CAclubindia
