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
- Tax Audit Applicability – Newly Formed Partnership Firm with Profit Below 6%/8%
- TDS CREDIT MISMATCHING
- Buy back of shares u/s69
- Unregistered suppliers utility
- Difference between Date of Payment and Date of Deduction?
- The TDS balance for March 26 shows a mismatch between the books and the portal; what should be done
- Bank details not Visible on Traces Portal
- Taxability of Partnership firm for FY 2025-26
- Need Professional Opinion - AY 2012-13 Old Demand & AY 2026-27 Refund Adjustment
- Cash balance limit and property purchases limit
- EXPORT COMMERCIAL INVOICE HSN CODE
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
- LLP audit under companies act
- Experienced CA recommendation from Kolkata for FNO return filing
- Interest Reporting in Form 168
- Sales of goods of amount Rs77 lakhs to a party
- Tax Demand of ₹4,650 for AY 2026-27
- Concept of Vendor and customner reconciliation
- Mistake in e-invoice identified after 24 hours
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
