Location: Pune (On-campus – Garware College)
Position Type: Visiting / Part-Time
Target Audience: B.Sc. Data Science Students
Course Duration: 60 Hours (Delivered across a semester)
Course Overview
This course equips students with strong practical skills in Excel for Data Analysis and Business Analytics. It progresses from foundational spreadsheet operations to advanced analytical tools used in industry.
The focus is on hands-on training, real datasets, business problem-solving, and analytical thinking. Students should complete the course with the ability to independently analyze, summarize, and present data-driven insights using Excel.
Strong emphasis will be placed on:
- Practical lab-based sessions
- Real-world case studies
- Structured problem-solving
- Dashboard creation
- Industry-oriented applications
Key Topics to Be Taught
Excel Fundamentals
- Interface, data entry, formatting
- Data types and data cleaning
- Sorting, filtering, and data validation
- Logical and lookup functions
Core Analytical Functions
- Statistical functions (AVERAGE, STDEV, etc.)
- Conditional functions (IF, nested IF)
- Lookup functions (VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH)
- Text and date functions
Data Analysis Tools
- Pivot Tables and Pivot Charts
- Data summarization and aggregation
- Conditional formatting
- What-if analysis (Goal Seek, Scenario Manager)
- Solver for optimization problems
Visualization & Dashboarding
- Charts and advanced chart formatting
- KPI tracking dashboards
- Dynamic dashboards using slicers
- Data storytelling using Excel
Advanced & Applied Analytics
- Regression analysis using Data Analysis Toolpak
- Forecasting basics
- Introduction to Power Query (basic exposure)
- Mini-project using real-world datasets
Ideal Candidate Profile
- Postgraduate degree in Statistics, Data Science, Commerce, Engineering, or related field
- Strong hands-on expertise in Microsoft Excel (advanced level)
- Experience using Excel for analytics, reporting, or business decision-making
- Prior teaching or corporate training experience preferred
- Ability to teach beginner to advanced levels clearly and patiently
- Strong focus on practical application and industry relevance
Commitment & Delivery Format
- 60 hours per semester
- Weekly 4–6 hours (Lecture + Hands-on Lab Sessions)
- On-campus delivery in Pune
- Preparation of assignments, practical exercises, and internal assessments
What We Value Most
- Practical training every session
- Clear, structured teaching style
- Real business case examples
- Student engagement and mentorship
- Focus on employability and analytical thinking
How to Apply
Send your resume to [email protected] or directly apply here
Job Types: Part-time, Contractual / Temporary
Contract length: 4 months
Pay: ₹30,000.00 - ₹50,000.00 per month
Experience:
- Data analytics: 5 years (Preferred)
- Microsoft Excel: 3 years (Preferred)
Language:
Work Location: In person
