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
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
ARTICLESHIP 17 November 2026
Vacancy for Articleship

Promptitude Accounting Services Private limited

Bengaluru

B.Com

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details