Neha Trivedi
Data Science, Excel, Coding & Robotics Tutor | 3+ Years Experience| Helping Students Master Tech Skills
Loading...
Show all photos
Neha Trivedi
Bachelors degree
/ 55 min
About your data science tutor
I am Neha Trivedi from Faridabad, a B.Tech graduate in Electronics and Communication with over three years of experience in online education. I specialize in teaching Data Science fundamentals, Excel, Coding, and Robotics, helping students build strong analytical, logical, and technical skills required in today’s rapidly evolving digital world. My goal as an educator is to make technology understandable, practical, and exciting for students so they can confidently apply their knowledge in real-world situations. Throughout my teaching journey, I have worked with well-known edtech platforms such as BrightChamps, TutorCare, and GyaanWorld, where I conducted engaging online sessions for students from different age groups and learning backgrounds. This experience has allowed me to interact with a diverse group of learners and understand how different students grasp concepts. It has also strengthened my ability to design lessons that are interactive, structured, and adapted to each learner’s pace. I have experience teaching students from various curricula including CBSE, IB, IGCSE, and ICSE. Working with international and national curricula has helped me understand the different learning approaches used around the world. I focus on ensuring that students not only complete their coursework but a concept understanding.
Meet Neha
Neha graduated from Maharishi Dayanand University
Data Science tutor skills
Statistical analysis
Assignment help
Business intelligence
Data visualization
Case Studies
CoTutorAI modules
Summary
Podcast
Quiz
Learnings
Flashcard
Spotlight
Zero Risk Guaranteed
15-days refund
Free tutor swap
No cancel fee
1-yr validity
24/7 support
Learner types for data science class
Data Science for beginners
Data Science for kids
Data Science for intermediate
Your data science tutor also teaches
Data Analysis
Excel
Data Science concepts taught by Neha
The Student and Tutor reviewed advanced Excel functions including XLOOKUP, SUMIF, COUNTIFS, and MAX for data consolidation and dashboard creation. They practiced creating dynamic KPIs, calculating spend by status and department, and generating various chart types for data visualization. The Tutor encouraged the Student to practice creating a month-wise revenue report and explore the MIN function.
Dashboard Creation
SUMIF and COUNTIF Functions
XLOOKUP Function
Pivot Tables for Data Summarization
The tutor and student reviewed spreadsheet data manipulation techniques, including adjusting raw data while maintaining totals and calculating percentages. They then delved into the advanced `IFS` formula for categorizing due dates and explored the potential of AI tools like ChatGPT for Excel automation. The next session will cover pivot tables and dashboard creation.
The IFS Function in Excel
Formula Copying and Pasting
AI Integration in Excel (Co-pilot/ChatGPT)
Pivot Tables vs. Raw Data
The tutor guided the student through several advanced Excel formulas, including `EOMONTH`, `IF` with `NETWORKDAYS`, `RANK.EQ`, and `CONCATENATE`. The student practiced applying these functions to analyze data, calculate business days, rank values, and combine text strings, with plans to cover pivot tables in a future session.
End of Month (EOMONTH) Function
CONCATENATE Function
RANK.EQ Function
IF with NETWORKDAYS
NETWORKDAYS Function
IF Function
The student and tutor worked extensively with Excel, focusing on pivot tables and lookup functions. They practiced data preparation, creating pivot tables for sales forecasting and analysis, and utilizing XLOOKUP and EOMONTH functions for data retrieval and date calculations. The session concluded with an introduction to the IF function for conditional analysis, with the student to practice these skills.
IF Statement for Conditional Logic
EOMONTH Function for Date Calculations
XLOOKUP: The Modern Data Retrieval Function
Pivot Tables for Data Summarization
Data Formatting: Numbers
Percentages
and Currency
VLOOKUP Function
Pivot Tables: Summarizing Your Data
Creating and Formatting Charts
Remove Duplicates & Conditional Formatting
The student demonstrated a created dashboard and discussed data issues with the tutor. They worked through refreshing mechanisms, data sources, and identified areas for improvement in data consolidation and reporting accuracy. The next steps involve fixing refresh issues, cleaning up the data structure, and then further refining the dashboard reports.
Master Data Tab
Data Refresh Mechanism
Dashboard Design Principles
Data Discrepancies and Resolution
Teaching tools used by data science tutor
Jupyter Notebook
RStudio
Data Science tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.