Darshankumar Chauhan
Data Science Expert over 9 years plus experience total academic experience 15 years
Loading...
Show all photos
Darshankumar Chauhan
Masters degree
/ 55 min
About your data science tutor
I am Darshankumar Chauhan, a Data Science tutor with over 9 years of experience. I hold a Master's degree and specialize in Excel, Data Science, and Data Analysis tutoring. My expertise spans a wide range of subjects including Business Intelligence, Machine Learning, Data Visualization, and more. I offer personalized learning experiences tailored to students of all levels, from beginners to advanced learners. Whether you are a kid venturing into the world of Data Science or an adult looking to deepen your understanding, I can help you excel in your Data Science journey. My specialities include providing assistance with assignments, conducting mock tests, creating study plans, and improving grades through comprehensive concept learning. I focus on practical applications such as Case Studies, Predictive Modeling, and Statistical Analysis to ensure a holistic understanding. Join me to explore the realms of Data Science through engaging sessions that enhance your skills in Excel, Data Analysis, and beyond. Let's embark on this educational adventure together and unlock your full potential in the world of Data Science! Thank you so much if you need more help contact me . All the Best .
Darshankumar graduated from JNU
Data Science tutor skills
Assignment help
Data engineering
Deep Learning
Data visualization
Statistical analysis
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 intermediate
Data Science for advanced
Data Science for kids
Data Science for adults
Your data science tutor also teaches
Data Analysis
Data Science
Excel
Data Science concepts taught by Darshankumar
The tutor and student practiced advanced VLOOKUP functions in Excel, covering exact and approximate matches, handling multiple criteria, and using wildcards for partial text searches. They also began exploring two-way lookups using the MATCH function within VLOOKUP, with plans to continue this topic in the next session.
VLOOKUP Exact Match
VLOOKUP Approximate Match
Handling Duplicates in VLOOKUP
VLOOKUP with Wildcards
Two-Way Lookup (VLOOKUP with MATCH)
The Tutor and Student reviewed several Excel functionalities, including shortcuts for deleting rows and cells, converting formulas to values, and advanced copy-paste methods. They practiced line break formatting and extensively explored the VLOOKUP function for data retrieval, with the Student completing VLOOKUP exercises and receiving additional homework.
VLOOKUP Function
Line Break Insertion (Alt + Enter)
Copying and Pasting Values Only
Converting Formulas to Values
Keyboard Shortcuts for Deletion
The tutor provided an in-depth lesson on Excel keyboard shortcuts, covering basic operations, navigation, selection, formatting, and function keys. The student practiced various shortcuts to improve efficiency in Excel. The session concluded with a discussion on scheduling future classes.
Basic Excel Navigation and Selection Shortcuts
Excel Selection Techniques
Excel Formula and Formatting Shortcuts
Workbook Management Shortcuts
Function Key Shortcuts (F1-F12)
Inserting Rows and Columns with Shortcuts
The class provided an in-depth tutorial on using various date and time functions in Excel, including YEAR, MONTH, DAY, DATE, NOW, TODAY, and DATEDIF. The student practiced extracting date components, performing date arithmetic, and calculating differences between dates, while also learning how to create static date/time entries. The tutor emphasized practical application through hands-on exercises and problem-solving.
Extracting Date Components
Date and Time Manipulation with Formulas
Current Date and Time Functions
DATEDIF Function for Date Differences
Working with Time Components
The Tutor instructed the Student on advanced Excel functions including the SWITCH function, and various cell referencing techniques such as relative, absolute, and mixed references. They also practiced 3D referencing, using the Name Box, and calculating percentage changes, with practical exercises to reinforce learning.
Cell References (Relative
Absolute
Mixed)
3D References in Excel
Name Box and Named Ranges
Percentage Change Calculations
The Tutor taught the Student about logical functions (IF, AND, OR, NOT) and comparison operators in Excel. The Student practiced applying these functions in various scenarios, including grading and tax calculations. The Student was assigned to practice these concepts in their system and share the file in the next session.
The IF Function
Comparison Operators
Nested IF Statements
Combining IF
AND
and OR
The NOT Function
The OR Function
Teaching tools used by data science tutor
Jupyter Notebook
Google Colab
Data Science tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.