Registration Open For 2021 : MBA, MCA, BBA, B.Com, BCA, BA.LLB, LLB, D.El.Ed, B.Ed     Click for Admission Enquiry  |   Apply for GD/PI (MBA/MCA Session 21-23)    Click Here  |   International E-Conference on " Computing and Data Science" on 25th September 2021    Click Here for Registration  |   Admission open for B.Ed 2021-23.    Click Here  |   Registration open for D.El.Ed. 2021-23    Click Here  |   UGC Important Links    Click Here  |   | Career@IPEM     Click Here for Apply    

Advance Excel Tips & Tricks - Online Event Activity Report


On June 2, 2021, the IPEM IT Club hosted an online competition Advance Excel Tips & Tricks. The purpose of this Competition was to judge and evaluate the advanced excel skills of students. Each participant was given 10 excel sheets to solve within 60 minutes and submit the answer sheet on Microsoft Teams. The activity drew a total of 35 students from IPEM's Departments of Management, Computer Applications, CTE, and Law. All of the students took part enthusiastically. The first position and second were grabbed by Ms. Shruti Singh Chauhan (CTE), and Ankita Jain (CTE) respectively

Title of Activity: Inter-Departmental ”Advance Excel – Tips and Tricks” (Online)
Purpose and Objectives: The purpose of this competition was to judge and evaluate the advanced excel skills of students. This competition helped students to improve their excel knowledge and skills.
Organising Department:
Computer Application Club
Date:2nd June 2021 (Wednesday) Time:03:00 pm to 04:00 pm


Dr. Pooja Sharma
HOD (Computer Application Department)

Activity Members

Faculty Name
Mr.Shivoham Tiwari
Computer Application Department
Mr. Pankaj Sharma
Management Department
Ms. Swati Garg
Education Department
Ms. Neeraj Nagar
Law Department

Student Coordinators

Student Coordinators
Akash Pundhir
Akash Aggarwal
Computer Application Department
Neha Tyagi
Management Department
Education Departmen
Madhu Kumari
Sadiq Ali
Law Department

Runner Ups

Ms. Shruti Singh Chauhan (First Position)
1st Year, Education Department
Ms. Ankita Jain (Runner Up)
1st Year, Education Department

Category and Number of Participants:

Total number of Participants: 35         Platform Used: Microsoft Teams Promotional Material Prepared: Sample PPTs, and Posters, were shared on WhatsApp and Email. Social and Print Media used for promotion

  • Students were given 10 excel sheets to solve
  • Only individual participants will be allowed
  • Total 60 minutes were given to solve the problems
  • Participants must submit answer sheet on teams only
  • Platform will be Microsoft teams

    • Conduct Methodology:

      • The Advanced Excel: Tips & Tricks competition activity was online.
      • Time limit was 60 minutes.
      • Students with the highest right answers shall be declared as the Winner.
      • Respective faculty gave suggestions for further Improvement.

      Outcomes & Objectives Achieved:

      • Firstly students learned tips and tricks of excel.
      • This activity will help them to develop an understanding of excel.

      Observation & Shortcomings:

      • Students need to improve advanced excel skills.
      • Excel formulas skills are still at the novice level.

      Recommendation for Future Improvements:

      • We need to encourage more of our students for better performance.

      Any other suggestions:

      • We need to give more opportunities to our students to participate in Advance Excel competitions so that students can be more confident.

Gallery OfAdvance Excel Tips & Tricks - Online Event Activity

Verify Student