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. | NAME | DEPARTMENT | SALARY |
|---|---|---|---|
| 1 | SUMAN | TEACHER | 12000 |
| 2 | PRIYA | TEACHER | 10000 |
| 3 | ANKIT | DOCTOR | 25000 |
| 4 | AJAY | COMPUTER | 15000 |
| 5 | AMAN | AGRICULTURE | 13000 |
| 6 | VISHAL | DOCTOR | 8000 |
| 7 | MONA | AGRICULTURE | 9000 |
| 8 | MONIKA | COMPUTER | 17000 |
| 9 | PAYAL | TEACHER | 14000 |
| 10 | MAHIMA | DOCTOR | 20000 |
| 11 | RAM | NURSE | 8000 |
| 12 | SYAM | TEACHER | 10000 |
| 13 | MOHAN | LAWYER | 13000 |
| 14 | SUHAN | ADVOCATE | 9000 |
| 15 | SUNITA | DOCTOR | 14000 |
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 Labels | Sum of SALARY |
|---|---|
| AGRICULTURE | 22000 |
| AMAN | 13000 |
| MONA | 9000 |
| COMPUTER | 32000 |
| AJAY | 15000 |
| MONIKA | 17000 |
| DOCTOR | 67000 |
| ANKIT | 25000 |
| MAHIMA | 20000 |
| VISHAL | 8000 |
| SUNITA | 14000 |
| TEACHER | 46000 |
| PAYAL | 14000 |
| PRIYA | 10000 |
| SUMAN | 12000 |
| SYAM | 10000 |
| NURSE | 8000 |
| RAM | 8000 |
| LAWYER | 13000 |
| MOHAN | 13000 |
| ADVOCATE | 9000 |
| SUHAN | 9000 |
| Grand Total | 197000 |
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
| NAME | FATHER NAME | Result of the second formula |
|---|---|---|
| Mohd Ali | GAYYU AHMAD | MR. GAYYU AHMAD SON Mohd Ali |
| Ali Haider | YASEEN | MR. YASEEN SON Ali Haider |
| Mahin Alam | RIZWAN | MR. RIZWAN SON Mahin Alam |
Free study material for Computer Science
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
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.
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.
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.
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.
All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.
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.