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
ARTICLESHIP 01 September 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
ARTICLESHIP 24 August 2026
Article Assistant

M/s.S.G.Salecha & Co.

Mumbai

CA Inter

View Details
Company
29 August 2026
Chartered Accountant

Velionit Consulting PVT LTd

Mumbai

CA

View Details
Company
27 August 2026
ACCOUNTANT

CHARUPREETI & CO

Noida

Graduate (Any)

View Details
Company
ARTICLESHIP 01 September 2026
Article Assistant

SGNG & Associates

New Delhi

CA Inter

View Details
Company
28 August 2026
Assistant Manager

NRS AND ASSOCIATES

Kozhikode

CA Inter

View Details
Company
08 September 2026
Audit Executive

Thammana & Associates

Srikakulam

B.Com

View Details
Company
Featured 11 September 2026
Audit Executive

RBSM Corporate Advisors Private Limited

Pune

CA

View Details