Advanced Excel Course Pivot Table Notes Set 01

Computer Science Study Guide: Advanced Excel Course Pivot Table Notes Set 01

Explore structured advanced study materials through the Advanced Excel Course Pivot Table Notes Set 01. Tailored for learners, utilizing these Computer Science resources ensures thorough preparation and strengthens foundational knowledge before final evaluations.

Download MS Office Study Material PDF

Access the complete useful resource PDF for Computer Science below. Regular practice with these targeted academic notes builds familiarity with complex topics and helps secure higher marks in final school evaluations.

A Pivot Table is built from a staff list of names, departments and salaries: the Create PivotTable dialog box, the PivotTable Fields pane with its Filters, Columns, Rows and Values areas, and the finished department-wise report of salaries. A short example of joining text with the ampersand follows.

Source data

The staff list has four columns: S.N., NAME, DEPARTMENT and SALARY.

S.N.NAMEDEPARTMENTSALARY
1SUMANTEACHER12000
2PRIYATEACHER10000
3ANKITDOCTOR25000
4AJAYCOMPUTER15000
5AMANAGRICULTURE13000
6VISHALDOCTOR8000
7MONAAGRICULTURE9000
8MONIKACOMPUTER17000
9PAYALTEACHER14000
10MAHIMADOCTOR20000
11RAMNURSE8000
12SYAMTEACHER10000
13MOHANLAWYER13000
14SUHANADVOCATE9000
15SUNITADOCTOR14000

Creating the Pivot Table

1. Click any cell of the list and choose Insert > PivotTable. The Create PivotTable dialog box opens.
2. Under Choose the data that you want to analyze, keep Select a table or range, and check the Table/Range box (it shows the full data range of the sheet). The other choice is Use an external data source.
3. Under Choose where you want the PivotTable report to be placed, select New Worksheet (or Existing Worksheet and a Location). Click OK.
4. A blank PivotTable and the PivotTable Fields pane appear. The pane lists the fields S.N., NAME, DEPARTMENT and SALARY and has four areas below it: Filters, Columns, Rows and Values.
5. Drag DEPARTMENT and then NAME to the Rows area and SALARY to the Values area.

Result

The report shows the sum of salary for each department with the names of the employees under it, and the Grand Total.

Row LabelsSum of SALARY
AGRICULTURE22000
AMAN13000
MONA9000
COMPUTER32000
AJAY15000
MONIKA17000
DOCTOR67000
ANKIT25000
MAHIMA20000
VISHAL8000
SUNITA14000
TEACHER46000
PAYAL14000
PRIYA10000
SUMAN12000
SYAM10000
NURSE8000
RAM8000
LAWYER13000
MOHAN13000
ADVOCATE9000
SUHAN9000
Grand Total197000

Joining text with the ampersand

The ampersand (&) joins text and cell contents. In the first example the text MR. followed by a space is joined to the name in B2 and the formula is copied down. In the second example the father's name (column H) and the name (column G) are joined with the word SON.

="MR. "&B2
="MR. "&H2&" SON "&G2
NAMEFATHER NAMEResult of the second formula
Mohd AliGAYYU AHMADMR. GAYYU AHMAD SON Mohd Ali
Ali HaiderYASEENMR. YASEEN SON Ali Haider
Mahin AlamRIZWANMR. RIZWAN SON Mahin Alam

CBSE Computer Science Study Material: MS Office

Quick Revision Material for MS Office

Explore essential learning tools for Computer Science MS Office. This curated collection features in-depth notes and targeted practice questions built around the active 2026 curriculum to streamline your daily revision.

Expert Notes and Solved Exam Questions

Built using official NCERT guidelines for Computer Science, these materials provide reliable academic support. Integrating past examination questions and step-by-step solutions helps students understand official CBSE grading criteria.

Additional Study Resources for

For peak performance in upcoming evaluations, integrate official Computer Science sample papers directly into your study schedule. Follow up your revision by attempting online MCQ tests for MS Office to refine calculation speed and precision.

FAQs

Where can I find the most advanced study material for [current-page:node:field_board] [current-page:node:field_class] Computer Science for 2026-27?

The latest 2026-27 advanced study resources for Computer Science are available for free on StudiesToday.com which includes NCERT Exemplars, high-order thinking skills (HOTS) questions, and deep-dive concept summaries.

What does the 2026-27 Computer Science study package for [current-page:node:field_class] include?

Our exhaustive Computer Science package includes chapter wise revision notes, solved practice sheets, important formulas and Concept Maps to help in better understanding of all topics.

Is this study material enough for both [current-page:node:field_board] exams and competitive tests?

Yes. For , our resources have been developed to help you get better marks in school exams and also build fundamental strength needed for entrance tests including Competency Based learning.

How should [current-page:node:field_class] students use this Computer Science material for maximum marks?

in , students should use Active Recall method, read the concept summary, then solve the Important Questions section without looking at the answers and then check your answers.

Can I download [current-page:node:field_class] Computer Science study notes in PDF for offline use?

All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.

Are the [current-page:node:field_class] Computer Science resources updated for the latest NEP guidelines?

Yes, our team has ensured that all Computer Science materials for are strictly aligned with the National Education Policy (NEP) 2020 and the latest 2026-27 syllabus.