Pivot Table
This query is : Resolved
25 April 2010
Can anyone plz. explain me
1.what is pivot table( in MS-Excel), what are its uses in a corporate and how to put pivot table.
2.Whats V look up and H look up how to put those and what are its uses.
3. Is there any other function or tools which will be helpful for decision making available in MS-Excel
1.what is pivot table( in MS-Excel), what are its uses in a corporate and how to put pivot table.
2.Whats V look up and H look up how to put those and what are its uses.
3. Is there any other function or tools which will be helpful for decision making available in MS-Excel
25 April 2010
pivot table is used to extract the dat from a mass scale of data in the desired format, for example you are having a list of products sold in 10 different states further there are different products and having different prices and many other criteria. and u want to check about a particular product than pivot table is useful.
V lookup is used to extract the data from 2 similar data, but different on some aspect,
V lookup is used to extract the data from 2 similar data, but different on some aspect,
25 April 2010
Nice reply
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
- Difference between Date of Payment and Date of Deduction?
- Tax Audit Applicability – Newly Formed Partnership Firm with Profit Below 6%/8%
- Unregistered suppliers utility
- ITDS U/S.194T of Firm
- TDS CREDIT MISMATCHING
- Buy back of shares u/s69
- Need Professional Opinion - AY 2012-13 Old Demand & AY 2026-27 Refund Adjustment
- ITR 4 and Bank transactions
- URGENT-Eligible leaves being shown as 24 days for 3 years Articleship instead of 156 days in 108
- FCRA 6 E- Intimation
- 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
- EXPORT PAYMENT
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
