CAPACITY BUILDING PROGRAM ON MS EXCEL - April 29, 2025
Date: April 29, 2025
Duration:
5 day(s)
Venue:
JKC Lab, ELL Lab, Math-Stat Lab, Robotics Lab
Target:
Students of B.Sc. Honours Mathematics and B.Sc. Honours Computational Mathematics (2023–24 Batch)
Number of Participants:
66
Capacity Building Program on Microsoft Excel for Internship and
Employability Readiness
This Capacity Building Program was carefully structured to provide progressive, hands-on training in Microsoft Excel. The sessions were aligned with
internship tasks and industry expectations. Each topic was selected to build
on the previous one, resulting in comprehensive skill development.
1. Introduction to Microsoft Excel
• Overview of Excel interface
• Workbook and worksheet basics
• Data entry and cell formatting
• File management and templates
2. Formulas and Functions
• Basic arithmetic operations
• Common functions: SUM, AVERAGE, IF, COUNTIF, MAX, MIN
• Relative, absolute, and mixed cell referencing
3. Data Handling and Validation
• Sorting and filtering data
• Data validation tools (dropdown lists, error alerts)
• Removing duplicates and text-to-columns
4. Conditional Formatting and Charting
• Applying rules for cell formatting
• Highlighting trends and exceptions
Creating basic charts: Bar, Line, Pie
• Customizing chart elements and layouts
5. Pivot Tables and Pivot Charts
• Summarizing large datasets
• Filtering and grouping data in pivot tables
• Creating interactive dashboards
6. Advanced Excel Features
• Logical functions: AND, OR, IFERROR
• Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH
• Working with multiple worksheets and linking data
7. Introduction to Macros
• Recording simple macros
• Automating repetitive tasks
• Understanding macro security
8. Mini Project and Assessment
• Case study: Data analysis project using Excel
• Practical test to assess skill acquisition
• Feedback and interaction session
Organizer(s):
Department of Mathematics
Outcome:
The training was well-organized and methodically planned, providing
a gradual build-up from basic to advanced Excel operations.
• Faculty appreciated the hands-on nature of the sessions and found the
exercises closely aligned with real-life teaching and research data tasks.
• The inclusion of modules such as Pivot Tables, Lookup Functions, and
Conditional Formatting were found to be particularly valuable.
• Many faculty participants noted an increase in confidence to handle student data, research analysis, and administrative tasks more efficiently
using Excel.
Feedback:
Student Feedback
The Capacity Building Program received overwhelmingly positive feedback
from the participants. A structured feedback form was distributed on the
final day, assessing the program across multiple dimensions including content
relevance, clarity of instruction, hands-on practice, and overall satisfaction.
• 95% of the participants rated the training sessions as “Very Good” or
“Excellent”.
• 90% appreciated the progression of topics from basics to advanced
features, which helped build a strong conceptual foundation.
• 92% felt confident in applying Excel skills to real-life internship or
academic tasks after attending the program.
• Feedback highlights:
– “The pace was ideal and instructors were very approachable.”
– “I never thought Excel could do so much — pivot tables and
lookup functions were a revelation.”
– “Hands-on practice made all the difference; I feel well-prepared
for internship data work.”
– “The mini-project gave a real-world perspective. A very useful
and well-organized program.”
• Participants also suggested topics like advanced data visualization and
dashboard creation for future workshops.
31
Niel’s Henrik Abel’s Birthday Celebrations On the occasion of Abel's Birthday Celebrations, the Dept. of Mathematics and Mat Club jointly organized a guest Lecture by Mahalakshmi Naidu on "Power Series of Ordinary Differential Equations."
