Excel query


This query is : Resolved 

Quick Summary
This discussion explains how to summarise data in an Excel sheet, specifically demonstrating how to use a Pivot Table. It addresses a user's question about placing text within the values field of a Pivot Table. For further assistance and learning, users are directed to the Excel forums at excelforum.com and mrexcel.com.

Profile Image

Guest

Profile Image

Guest (Querist)
25 May 2020 How to summarize the data given in Excel sheet below? I have also shown the manner in which data is required.

https://docs.google.com/spreadsheets/d/1T64Zc-QFPqhzPwpgZxIcje7Qzyb9vtf7h4ibaIDU65A/edit?usp=drivesdk

26 May 2020 Use Pivot Table function

Profile Image

Guest

Profile Image

Guest (Querist)
28 May 2020 Sir please guide me on how to place text in values field of pivot table?

04 June 2020 You can learn a lot of Microsoft Excel. Please register and post you query in the below forums

https://www.excelforum.com/
https://www.mrexcel.com/

Profile Image

Guest

Profile Image

Guest (Querist)
04 June 2020 Thank you so much. This forums are very useful.


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
08 October 2026
Account Executive

Elite Taxation

New Delhi

CA Foundation

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
ARTICLESHIP 30 September 2026
CA Article Assistant

CA Suraj Garg & Associates

New Delhi

CA Final

View Details
Company
ARTICLESHIP 01 October 2026
Articled Assistant

KPSN & Associates LLP

Chennai

CA Inter

View Details
Company
19 October 2026
Accountants/Articles (Freshers/Experienced)

ADY & CO.

New Delhi

Graduate (Any)

View Details
Company
ARTICLESHIP 17 October 2026
Articled Assistant

RRPM & Associates LLP

Chennai

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
Articled Trainee

J Y & CO

Hyderabad

CA Inter

View Details
Company
12 October 2026
AUDIT , ACCOUNTS AND TAXATION

KDSS

New Delhi

B.Com

View Details