Pivot Table

This query is : Resolved

Satyanarayanan (Querist)
Follow

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

Nischint Kumar Somani

Nischint Kumar Somani (Expert)
Follow

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,

Ram Avtar Singh

Ram Avtar Singh (Expert)
Follow

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

Join the CA Students WhatsApp Community for ICAI Updates, Trending Courses & Notes!

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

Tushar Gupta

zafar chandwale

CA Narender Yarragorla

NICKOONJ VANANI

S. AGARWAL & ASSOCIATES

Subscribe Now

Pivot Table

Similar Resolved Queries

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

Senior Executive

Manager- Finance and Compliance

GST CONSULTANT

GST CONSULTANCY

Accountant

CA Final

Article Assistant

Associate CA