| Title | WORKSHOP ON ADVANCED EXCEL |
|---|---|
| Date of Event(s) | 25th March– 27th March 2024 |
| Department/Association/Cell/Committee | School of commerce |
| Venue(Mention the platform if it is online) | Offline |
| Number of Participants | 56 |
| Target Audience | UG& PG Commerce Students |
| Resource Person(s) with qualification(if applicable) | Mr Roshan Ravi B.E, PGDM, (PhD), Rajairi College of Social Science |
| Place of visit/ details of Industrial Visit place (if applicable): | NP |
| Event Coordinator | Dr Geetha PS |
Objectives:
• To deepen students understanding of advanced Excel functionalities beyond basic spreadsheet operations.
• To enhance students’ efficiency by teaching them time-saving techniques and shortcuts for complex tasks.
• To teach advanced data analysis techniques such as PivotTables, data modeling, and scenario analysis.
• To create dynamic and visually appealing charts and graphs to effectively communicate insights from data.
The workshop covered a range of topics including:
Advanced functions and formulas.
PivotTable and PivotChart creation, manipulation, and customization.
Data validation, conditional formatting, and advanced filtering techniques.
Introduction to Power Query for data import, transformation, and analysis.
Automation using macros and VBA (Visual Basic for Applications).
Tips and tricks for efficient workbook management and navigation.
Best practices for data analysis, including data cleansing and outlier detection.
Learning Outcomes:
The Advanced Excel Training workshop was successful in providing students with advanced excel skills and techniques essential for effective data analysis and reporting. The workshop not only enhanced students' proficiency in Excel but also empowered them to optimize workflows and make informed decisions based on data insights. Overall, the workshop received positive feedback from participants, indicating its effectiveness in meeting the learning objectives.
Registration form link : https://forms.gle/Gog5HDTdGBE8GqKv8
Feedback form link : https://forms.gle/vnKvEjqghndtBW8s7